1,添加NOPI的引用

下载地址:http://download-codeplex.sec.s-msft.com/Download/Release?ProjectName=npoi&DownloadId=1432518&FileTime=130691232697500000&Build=21066

2,添加命名空间

using NPOI.HSSF.UserModel;

using NPOI.SS.UserModel;

using NPOI.XSSF.UserModel;

/// 
        /// 导入       /// 
       /// 
             public ActionResult ImportExcel()        {            Dictionary
     
       result = new Dictionary
      
       ();            StringBuilder errorMsg = new StringBuilder(); // 错误信息            try            {                string tempFile = Server.MapPath("~/ExcelFiles/");//路径                string repath = Request["repath"];                //将Excel文件上传到本地服务器                              HttpPostedFileBase uploadFile = Request.Files[repath];// 获取上传的文件                                var filePath = string.Format("{0}{1}", tempFile, uploadFile.FileName); // 上传服务器的文件保存路径                uploadFile.SaveAs(filePath);//保存文件                ////Excel文档流转换成DataTable                               DataTable dt = ExcelToDataTable(filePath, true);                               // 将数据存储到数据库                AidMeasureService.ExcelDataSave(dt);                //将上传的文件删除                System.IO.FileInfo nfile = new System.IO.FileInfo(filePath);                if (nfile.Exists)                {                    nfile.Delete();                }            }            catch (Exception ex)            {                LogHelper.WriteLog("MeasureController.ImportExcel()", ex);                result.Add("Success", false);                result.Add("ErrorInfo", ex.ToString());                return Json(result);            }            result.Add("Success", true);            return Json(result);        }              /// 
       
          /// 将excel导入到datatable          /// 
          /// 
       excel路径          /// 
       第一行是否是列名          /// 
       
        返回datatable
                 public DataTable ExcelToDataTable(string filePath, bool isColumnName)        {            DataTable dataTable = null;            FileStream fs = null;            DataColumn column = null;            DataRow dataRow = null;            IWorkbook workbook = null;            ISheet sheet = null;            IRow row = null;            ICell cell = null;            int startRow = 0;            try            {                using (FileStream stream = new FileStream(filePath, FileMode.Open, FileAccess.Read))                {                    // 2007版本                      if (filePath.IndexOf(".xlsx") > 0)                        workbook = new XSSFWorkbook(stream);                    // 2003版本                      else if (filePath.IndexOf(".xls") > 0)                        workbook = new HSSFWorkbook(stream);                    if (workbook != null)                    {                        sheet = workbook.GetSheetAt(0);//读取第一个sheet，当然也可以循环读取每个sheet                          dataTable = new DataTable();                        if (sheet != null)                        {                            int rowCount = sheet.LastRowNum;//总行数                              if (rowCount > 0)                            {                                IRow firstRow = sheet.GetRow(0);//第一行                                  int cellCount = firstRow.LastCellNum;//列数                                  //构建datatable的列                                  if (isColumnName)                                {                                    startRow = 1;//如果第一行是列名，则从第二行开始读取                                      for (int i = firstRow.FirstCellNum; i < cellCount; ++i)                                    {                                        cell = firstRow.GetCell(i);                                        if (cell != null)                                        {                                            if (cell.StringCellValue != null)                                            {                                                column = new DataColumn(cell.StringCellValue);                                                dataTable.Columns.Add(column);                                            }                                        }                                    }                                }                                else                                {                                    for (int i = firstRow.FirstCellNum; i < cellCount; ++i)                                    {                                        column = new DataColumn("column" + (i + 1));                                        dataTable.Columns.Add(column);                                    }                                }                                //填充行                                  for (int i = startRow; i <= rowCount; ++i)                                {                                    row = sheet.GetRow(i);                                    if (row == null) continue;                                    dataRow = dataTable.NewRow();                                    for (int j = row.FirstCellNum; j < cellCount; ++j)                                    {                                        cell = row.GetCell(j);                                        if (cell == null)                                        {                                            dataRow[j] = "";                                        }                                        else                                        {                                            //CellType(Unknown = -1,Numeric = 0,String = 1,Formula = 2,Blank = 3,Boolean = 4,Error = 5,)                                              switch (cell.CellType)                                            {                                                case CellType.BLANK:                                                    dataRow[j] = "";                                                    break;                                                case CellType.NUMERIC:                                                    short format = cell.CellStyle.DataFormat;                                                    //对时间格式（2015.12.5、2015/12/5、2015-12-5等）的处理                                                      if (format == 14 || format == 31 || format == 57 || format == 58)                                                        dataRow[j] = cell.DateCellValue;                                                    else                                                        dataRow[j] = cell.NumericCellValue;                                                    break;                                                case CellType.STRING:                                                    dataRow[j] = cell.StringCellValue;                                                    break;                                            }                                        }                                    }                                    dataTable.Rows.Add(dataRow);                                }                            }                        }                    }                }                return dataTable;            }            catch (Exception)            {                if (fs != null)                {                    fs.Close();                }                return null;            }        }