1.引用一个DLL文件:AppLibrary
2.应用实例:
string fileName = Session["Upload_FileName"].ToString();
AppLibrary.ReadExcel.Workbook workbook = null;
workbook = AppLibrary.ReadExcel.Workbook.getWorkbook(Server.MapPath("../../temp/" + fileName + ""));
AppLibrary.ReadExcel.Sheet sheet = workbook.getSheet(0); //取得Excel中的第一个Sheeet
for (int i = 1; i < sheet.Rows; i++) //默认从1开始,因为第一行为列名的行
{
string Name = sheet.getCell(1, i).Contents.ToString(); //获取第一列 第i行的内容
}