取得excel有效信息

最新推荐文章于 2024-09-29 12:15:00 发布

最新推荐文章于 2024-09-29 12:15:00 发布 · 91 阅读

本文介绍了一种使用C#和Microsoft Excel进行交互的方法。通过创建Excel应用程序实例并打开指定文件，可以读取工作表中从第二行开始的所有数据。此过程涉及判断文件是否存在、打开Excel文件、遍历单元格并获取其值。

//0/加入using Excel;

string strFileName = "test.xls";
//1、判斷file this.Server.MapPath(strFileName)存在
//2、取信息
object missing = System.Reflection.Missing.Value;

ApplicationClass appc = new ApplicationClass();//lauch excel application

if (appc != null)
{
//open excel file
if (appc.Application.Workbooks != null)
{
Workbook wb = appc.Application.Workbooks.Open(this.Server.MapPath(strFileName), missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);

int srow = 2;
int erow = ws.UsedRange.Rows.Count;
int scolumn = 1;
int ecolumn = ws.UsedRange.Columns.Count;
for (int irow = srow; irow <= erow; irow++)
{
strValue += "Row" + (irow-1);
for (int icolu = scolumn; icolu <= ecolumn; icolu++)
{
strValue += " Cell" + icolu + ":" + ((Range)ws.Cells.get_Item(irow, icolu)).Value2.ToString();
}
strValue += "<br/>";
}
this.Response.Write(strValue);
}

}
appc.Quit();

appc = null;