1  DataTable data = new DataTable();
 2 
 3 
 4             DataColumn column=new DataColumn();
 5             using (FileStream fsRead = File.OpenRead(Path))
 6             {
 7                 //首先创建工作簿
 8                 IWorkbook wk = new HSSFWorkbook(fsRead);
 9                 //读取sheet
10                 for (int i = 0; i < wk.NumberOfSheets; i++)
11                 {
12                     ISheet sheet = wk.GetSheetAt(i);
13                     //定义从第二行开始
14                     for (int r = 1; r <= sheet.LastRowNum; r++)
15                     {
16                         IRow row = sheet.GetRow(r);
17                         //读取单元格内容
18                         for (int c = 1; c < row.LastCellNum; c++)
19                         {
20                             ICell cell = row.GetCell(c);
21 
22                             row.GetCell(7).SetCellType(CellType.STRING);
23                             row.GetCell(8).SetCellType(CellType.STRING);
24                             row.GetCell(9).SetCellType(CellType.STRING);
25                             row.GetCell(10).SetCellType(CellType.STRING);
26                             row.GetCell(11).SetCellType(CellType.STRING);
27                             row.GetCell(12).SetCellType(CellType.STRING);
28                             if (cell != null)
29                             {
30                                
31                                 string cellValue = Convert.ToString(cell.StringCellValue);
32 
33                              35                                     column = new DataColumn(cellValue);
36 37                             }
38                             data.Columns.Add(column);
39                         }
40                     }
41                 }
42             }
43             return data;