1.引用.net组件Microsoft.Office.Interop.Excel,
using Excel = Microsoft.Office.Interop.Excel;
2.Coding;
try
{
Microsoft.Office.Interop.Excel.Application excelApp = null;
Excel.Workbook excelWorkbook = null;
Excel.Worksheet excelWorksheet = null;
Excel.Range range = null;
string fileName = "sl.xlsx";
excelApp = new Excel.ApplicationClass();
excelWorkbook = excelApp.Workbooks.Open(
fileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);//打开文件
excelWorksheet = (Excel.Worksheet)excelWorkbook.Worksheets[1];//excelSheets[1],读取第一个工作表
int RowNum = excelWorksheet.UsedRange.Cells.Rows.Count; //有效行数
this.Label1.Text += "RowNum="+Convert.ToString(RowNum)+"|";
string start = "A"; //列起始位置
string end = "B";//列终止位置
for (int i = 1; i <= RowNum; i++)
{
range = excelWorksheet.get_Range(start+"" +i.ToString(),end+""+i.ToString());
Array array = (Array)range.Cells.Value2;
this.Label1.Text += array.GetValue(1, 1).ToString() + "|";
}
}
catch
{
}