1. 读Excel ,将结果封装成一个dataTable
public static DataTable readExcel(string filePath) {
DataTable dt = new DataTable();
HSSFWorkbook workbook = null;
FileStream fs = null ;
try
{
fs = new FileStream(filePath, FileMode.Open,FileAccess.Read);
workbook = new HSSFWorkbook(fs);
HSSFSheet sheet = (HSSFSheet)workbook.GetSheetAt(0);
//获取Excle的行信息
HSSFRow headerRow = sheet.GetRow(0) as HSSFRow;
//获取一行有多少列
int cellsCount = headerRow.LastCellNum;
for (int i = 0; i < cellsCount;i++ )
{
HSSFCell headerCell = headerRow.GetCell(i) as HSSFCell;
dt.Columns.Add(headerCell.ToString());
}
//读取Excel具体的信息
for (int i = sheet.FirstRowNum + 1; i <= sheet.LastRowNum;i++ )
{
HSSFRow row = sheet.GetRow(i) <