NPOI读取Excel

 1             IWorkbook workbook = null; 2             string fileExt = Path.GetExtension(path); 3             try 4             { 5                 using (var file = new FileStream(path, FileMode.Open, Fileaccess.Read)) 6                 { 7                     if (fileExt == ".xls") 8                         workbook = new HSSFWorkbook(file); 9                     else if (fileExt == ".xlsx")10                         workbook = new XSSFWorkbook(file);11                     else12                     {13 14                     }15                 }16             }17             catch (Exception ex)18             { }

 1 //获取sheet页 2             var sheet = workbook.GetSheetAt(0); 3             //获取总条数 4             int RowCount = sheet.LastRowNum; 5             //获取sheet页的第一条数据 6             IRow firstRow = sheet.GetRow(0); 7             //获取总列数 8             int CellCount = firstRow.LastCellNum; 9 10             DataTable dt = new DataTable();11             for (int j = 0; j < CellCount; j++)12             {13                 string value = firstRow.GetCell(j).StringCellValue;14                 DataColumn dc = new DataColumn(value, typeof(String));15                 dt.Columns.Add(dc);16             }17 18             for (int i = 1; i <= RowCount; i++)19             {20                 IRow row = sheet.GetRow(i);21                 DataRow dr = dt.NewRow();22                 for (int j = 0; j < CellCount; j++)23                 {24                     object obj = row.GetCell(j);25                     if (obj != null)26                         dr[j] = obj.ToString();27                     else28                         dr[j] = "";29                 }30                 dt.Rows.Add(dr);31             }