NPOI 操作Excel

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) <