npoi读取exc

npoi读取exc //configÖÐÅäÖõÄÉÏ??µÄExcelÂ??? static object basePath = ConfigurationManager.AppSettings["FilePath"]; #region ?ÁÈ?ExcelÎÄ?þ ///

/// ?ÁÈ?ExcelÎÄ?þµ?tableÖÐ ///

/// excelÎÄ?þÂ??? /// public static DataTable ReadExcel(string fileName) { DataTable dt = new DataTable(); string filePath = ""; if (basePath != null) { filePath = HostingEnvironment.MapPath((basePath.ToString() + fileName)); dt = ImportExcelFile(filePath); } //ÎÄ?þÊÇ?ñ?æÔÚ if (System.IO.File.Exists(filePath)) { } return dt; } public static DataTable ImportExcelFile(string filePath) { HSSFWorkbook hssfworkbook; #region//?õÊ???ÐÅÏ? try { using (FileStream file = new FileStream(filePath, FileMode.Open, FileAccess.Read)) { hssfworkbook = new HSSFWorkbook(file); } } catch (Exception e) { throw e; } #endregion NPOI.SS.UserModel.ISheet sheet = hssfworkbook.GetSheetAt(0); System.Collections.IEnumerator rows = sheet.GetRowEnumerator(); DataTable dt = new DataTable(); rows.MoveNext(); HSSFRow row = (HSSFRow)rows.Current; for (int j = 0; j < (sheet.GetRow(0).LastCellNum); j++) { //dt.Columns.Add(Convert.ToChar(((int)'A') + j).ToString()); //??µÚÒ?ÁÐ×?ΪÁÐ?íÍ? dt.Columns.Add(row.GetCell(j).ToString ()); } while (rows.MoveNext()) { row = (HSSFRow)rows.Current; DataRow dr = dt.NewRow(); for (int i = 0; i < row.LastCellNum; i++) { NPOI.SS.UserModel.ICell cell = row.GetCell(i); if (cell == null) { dr[i] = null; } else { dr[i] = cell.ToString(); } } dt.Rows.Add(dr); } return dt; } #endregion