[Asp.Net]NPOI操作Excel

NPOI是Excel的优秀操作类库，就不多说了。直接上代码，记录一下这段代码

 

方法一：读取Excel

        /// <summary>
        /// Excel转换成DataTable（.xls）
        /// </summary>
        /// <param name="filePath">Excel文件路径</param>
        /// <returns></returns>
        public static DataTable ExcelToDataTable(string filePath,bool firstRowHeader)
        {
            var dt = new DataTable();
            using (var file = new FileStream(filePath, FileMode.Open, FileAccess.Read))
            {
                //根据文件名判断excel版本，创建workbook
                IWorkbook hssfworkbook = null;
                if (filePath.ToLower().IndexOf(".xlsx") > 0)
                {
                    hssfworkbook = new XSSFWorkbook(file);
                }
                else
                {
                    hssfworkbook = new HSSFWorkbook(file);
                }
                var sheet = hssfworkbook.GetSheetAt(0);

                //表头
                int startIndex = 0;// sheet.FirstRowNum;
                int lastIndex = sheet.LastRowNum;
                
                if (firstRowHeader)
                {
                    startIndex = 1;
                    var row = sheet.GetRow(0);
                    for (int i = 0; i < row.LastCellNum; i++)
                    {
                        I