public class ExcelHelper
    {
        /// <summary>
        /// 读取所有Sheet
        /// </summary>
        /// <param name="fileName"></param>
        /// <returns></returns>
        public static List<DataTable> Read(string fileName)
        {
            List<DataTable> tables = new List<DataTable>();
            if (!File.Exists(fileName))
                return tables;
            var fs = new FileStream(fileName, FileMode.Open, FileAccess.Read);
            IWorkbook workbook = null;
            if (fileName.Contains(".xlsx"))
            {
                // 2007以上版本
                workbook = new XSSFWorkbook(fs);
            }
            else if (fileName.Contains(".xls"))
            {
                // 2003版本
                workbook = new HSSFWorkbook(fs);
            }

            var workbooks = workbook.GetEnumerator();
            while (workbooks.MoveNext())
            {
                ISheet sheet = workbooks.Current as ISheet;
                DataTable dt = new DataTable(sheet.SheetName);
                var rows = sheet.GetRowEnumerator();
                while (rows.MoveNext())
                {
                    IRow row = rows.Current as IRow;
                    if (row.RowNum == 0)
                    {
                        row.Cells.ForEach(cell =>
                        {
                            dt.Columns.Add(cell.StringCellValue);
                        });
                    }
                    else
                    {
                        var dr = dt.NewRow();
                        for (int i = 0; i < row.Cells.Count; i++)
                        {
                            dr[i] = row.Cells[i].ToString();
                        }
                        dt.Rows.Add(dr);
                    }
                }
                tables.Add(dt);
            }
            return tables;
        }

        /// <summary>
        /// 读取指定SheetName的Sheet
        /// </summary>
        /// <param name="fileName"></param>
        /// <param name="sheetName"></param>
        /// <returns></returns>
        public static DataTable ReadExcel(string fileName, string sheetName)
        {
            if (!File.Exists(fileName))
                return null;
            var fs = new FileStream(fileName, FileMode.Open, FileAccess.Read);
            IWorkbook workbook = null;
            if (fileName.Contains(".xlsx"))
            {
                // 2007版本
                workbook = new XSSFWorkbook(fs);
            }
            else if (fileName.Contains(".xls"))
            {
                // 2003版本
                workbook = new HSSFWorkbook(fs);
            }
            ISheet sheet = workbook.GetSheet(sheetName);
            DataTable dt = new DataTable();
            var rows = sheet.GetRowEnumerator();
            while (rows.MoveNext())
            {
                IRow row = rows.Current as IRow;
                if (row.RowNum == 0)
                {
                    row.Cells.ForEach(cell =>
                    {
                        dt.Columns.Add(cell.StringCellValue);
                    });
                }
                else
                {
                    var dr = dt.NewRow();
                    for (int i = 0; i < row.Cells.Count; i++)
                    {
                        dr[i] = row.Cells[i].ToString();
                    }
                    dt.Rows.Add(dr);
                }
            }
            return dt;
        }
    }