public static DataTable ReadExcelToDataTable(string fileName, string sheetName = null, bool isFirstRowColumn = false)
        {//定义要返回的datatable对象DataTable data = new DataTable();
            NPOI.SS.UserModel.ISheet sheet = null;//数据开始行(排除标题行)int startRow = 0;if (!File.Exists(fileName))
            {return null;
            }//根据指定路径读取文件FileStream fs = new FileStream(fileName, FileMode.Open, FileAccess.Read);
            NPOI.SS.UserModel.IWorkbook workbook = NPOI.SS.UserModel.WorkbookFactory.Create(fs);//IWorkbook workbook = new HSSFWorkbook(fs);//如果有指定工作表名称if (!string.IsNullOrEmpty(sheetName))
            {
                sheet = workbook.GetSheet(sheetName);//如果没有找到指定的sheetName对应的sheet，则尝试获取第一个sheetif (sheet == null)
                {
                    sheet = workbook.GetSheetAt(0);
                }
            }else{//如果没有指定的sheetName，则尝试获取第一个sheetsheet = workbook.GetSheetAt(0);
            }if (sheet != null)
            {
                NPOI.SS.UserModel.IRow firstRow = sheet.GetRow(0);//一行最后一个cell的编号 即总的列数int cellCount = firstRow.LastCellNum;//如果第一行是标题列名for (int i = firstRow.FirstCellNum; i < cellCount; ++i)
                {
                    NPOI.SS.UserModel.ICell cell = firstRow.GetCell(i);if (cell != null)             //遍历Excel表                    {//     string cellValue = cell.StringCellValue;if (cell != null)
                        {
                            DataColumn column = new DataColumn(cell.ToString());
                            data.Columns.Add(column);
                        }
                    }
                }if (isFirstRowColumn)
                {
                    startRow = sheet.FirstRowNum + 1;      //有表头时不读取表头                }else{
                    startRow = sheet.FirstRowNum;
                }//最后一列的标号int rowCount = sheet.LastRowNum;for (int i = startRow; i <= rowCount; ++i)
                {
                    NPOI.SS.UserModel.IRow row = sheet.GetRow(i);if (row == null) continue; //没有数据的行默认是null　　　　　　　DataRow dataRow = data.NewRow();for (int j = row.FirstCellNum; j < cellCount; ++j)
                    {if (row.GetCell(j) != null) //同理，没有数据的单元格都默认是nulldataRow[j] = row.GetCell(j).ToString();
                    }
                    data.Rows.Add(dataRow);
                }
            }return data;

        }