下面是对NPOI的数据引用


using NPOI;
using NPOI.XSSF;
using NPOI.XSSF.UserModel;
using NPOI.HPSF;
using NPOI.HSSF;
using NPOI.HSSF.Record;//NPOI.HSSF.Record.Formula.Eval改为了NPOI.SS.Formula.Eval;
using NPOI.SS.Formula.Eval;//同上
using NPOI.HSSF.UserModel;
using NPOI.HSSF.Util;
using NPOI.POIFS;
using NPOI.SS.UserModel;
using NPOI.Util;
using NPOI.SS;
using NPOI.DDF;
using NPOI.SS.Util;

      public static DataTable ExcelToTableForXLSX(string file)
        {
            DataTable dt = new DataTable();
            using (FileStream fs = new FileStream(file, FileMode.Open, FileAccess.Read))
            {
                XSSFWorkbook xssfworkbook = new XSSFWorkbook(fs);
                ISheet sheet = xssfworkbook.GetSheetAt(0);

                //表头
                IRow header = sheet.GetRow(sheet.FirstRowNum);
                List<int> columns = new List<int>();
                for (int i = 0; i < header.LastCellNum; i++)
                {
                    object obj = GetValueTypeForXLSX(header.GetCell(i) as XSSFCell);
                    if ((obj == null || obj.ToString() == string.Empty) && obj.ToString()!="Effective Date")
                    {
                        dt.Columns.Add(new DataColumn("Columns" + i.ToString()));
                        //continue;
                    }
                    else if (obj.ToString() == "Effective Date")
                    {dt.Columns.Add(new DataColumn(obj.ToString(),typeof(DateTime)));}
                    else
                    {dt.Columns.Add(new DataColumn(obj.ToString()));}
                    columns.Add(i);
                }
                //数据
                for (int i = sheet.FirstRowNum + 1; i <= sheet.LastRowNum; i++)
                {
                    DataRow dr = dt.NewRow();
                    bool hasValue = false;
                    foreach (int j in columns)
                    {

                        dr[j] = GetValueTypeForXLSX(sheet.GetRow(i).GetCell(j) as XSSFCell);
                        if (dr[j] != null && dr[j].ToString() != string.Empty)
                        {
                            hasValue = true;
                        }
                    }
                    if (hasValue)
                    {
                        dt.Rows.Add(dr);
                    }
                }
            }
            return dt;
        }

 /// <summary>
        /// 获取单元格类型(xlsx)
        /// </summary>
        /// <param name="cell"></param>
        /// <returns></returns>
        private static object GetValueTypeForXLSX(XSSFCell cell)
        {
            if (cell == null)
                return null;
            switch (cell.CellType)
            {
                case CellType.Blank: //BLANK:
                    return null;
                case CellType.Boolean: //BOOLEAN:
                    return cell.BooleanCellValue;
                case CellType.Numeric: //NUMERIC:
                    return cell.NumericCellValue;
                case CellType.String: //STRING:
                    return cell.StringCellValue;
                case CellType.Error: //ERROR:
                    return cell.ErrorCellValue;
                case CellType.Formula: //FORMULA:
                default:
                    return "=" + cell.CellFormula;
            }
        }

#region 程序集 NPOI.OOXML.dll, v2.1.3.1
// F:\20150528\WebApp\WebApp\bin\NPOI.OOXML.dll
#endregion

using NPOI.OpenXmlFormats.Spreadsheet;
using NPOI.SS.UserModel;
using NPOI.SS.Util;
using NPOI.XSSF.Model;
using System;

namespace NPOI.XSSF.UserModel
{
    public class XSSFCell : ICell
    {
        public XSSFCell(XSSFRow row, CT_Cell cell);

        public CellRangeAddress ArrayFormulaRange { get; }
        //
        public bool BooleanCellValue { get; }
        //
        // 摘要: 
        //     Only valid for formula cells
        public CellType CachedFormulaResultType { get; }
        //
        // 摘要: 
        //     Returns cell comment associated with this cell
        public IComment CellComment { get; set; }
        //
        // 摘要: 
        //     Return a formula for the cell, for example, SUM(C4:E4)
        public string CellFormula { get; set; }
        //
        // 摘要: 
        //     Return the cell's style.
        public ICellStyle CellStyle { get; set; }
        //
        // 摘要: 
        //     Return the cell type.
        public CellType CellType { get; }
        //
        // 摘要: 
        //     Returns zero-based column index of this cell
        public int ColumnIndex { get; }
        //
        // 摘要: 
        //     Get the value of the cell as a date.
        public DateTime DateCellValue { get; }
        //
        // 摘要: 
        //     Returns the error message, such as #VALUE!
        public string ErrorCellString { get; }
        //
        // 摘要: 
        //     Get the value of the cell as an error code.  For strings, numbers, and bools,
        //     we throw an exception.  For blank cells we return a 0.
        public byte ErrorCellValue { get; }
        //
        // 摘要: 
        //     Returns hyperlink associated with this cell
        public IHyperlink Hyperlink { get; set; }
        public bool IsMergedCell { get; }
        public bool IsPartOfArrayFormulaGroup { get; }
        //
        public double NumericCellValue { get; }
        //
        public IRichTextString RichStringCellValue { get; }
        //
        public IRow Row { get; }
        //
        // 摘要: 
        //     Returns zero-based row index of a row in the sheet that contains this cell
        public int RowIndex { get; }
        //
        public ISheet Sheet { get; }
        //
        public string StringCellValue { get; }

        public ICell CopyCellTo(int targetIndex);
        //
        public string GetRawValue();
        //
        // 摘要: 
        //     Returns an A1 style reference to the location of this cell
        //
        // 返回结果: 
        //     A1 style reference to the location of this cell
        public string GetReference();
        //
        protected SharedStringsTable GetSharedStringSource();
        //
        protected StylesTable GetStylesSource();
        //
        // 摘要: 
        //     Removes the comment for this cell, if there is one.
        public void RemoveCellComment();
        //
        // 摘要: 
        //     Sets this cell as the active cell for the worksheet.
        public void SetAsActiveCell();
        public void SetCellErrorValue(byte errorCode);
        //
        // 摘要: 
        //     Set a error value for the cell
        //
        // 参数: 
        //   error:
        //     the error value to Set this cell to. For formulas we'll Set the precalculated
        //     value , for errors we'll set its value. For other types we will change the
        //     cell to an error cell and Set its value.
        public void SetCellErrorValue(FormulaError error);
        //
        public void SetCellFormula(string formula);
        //
        // 摘要: 
        //     Set the cells type (numeric, formula or string)
        //
        // 参数: 
        //   cellType:
        public void SetCellType(CellType cellType);
        //
        public void SetCellValue(bool value);
        //
        // 摘要: 
        //     Set a date value for the cell. Excel treats dates as numeric so you will
        //     need to format the cell as a date.
        //
        // 参数: 
        //   value:
        //     the date value to Set this cell to. For formulas we'll set the precalculated
        //     value, for numerics we'll Set its value. For other types we will change the
        //     cell to a numeric cell and Set its value.
        public void SetCellValue(DateTime value);
        //
        public void SetCellValue(double value);
        //
        public void SetCellValue(IRichTextString str);
        //
        public void SetCellValue(string str);
        //
        // 摘要: 
        //     Returns a string representation of the cell
        //
        // 返回结果: 
        //     Formula cells return the formula string, rather than the formula result.
        //      Dates are displayed in dd-MMM-yyyy format Errors are displayed as #ERR<errIdx>
        public override string ToString();
    }
}

 /// <summary>
        /// 获取单元格类型(xlsx)
        /// </summary>
        /// <param name="cell"></param>
        /// <returns></returns>
        private static object GetValueTypeForXLSX(XSSFCell cell)
        {
            if (cell == null)
                return null;
            switch (cell.CellType)
            {
                case CellType.Blank: //BLANK:
                    return null;
                case CellType.Boolean: //BOOLEAN:
                    return cell.BooleanCellValue;
                case CellType.Numeric: //NUMERIC:
                    return cell.NumericCellValue;
                case CellType.String: //STRING:
                    return cell.StringCellValue;
                case CellType.Error: //ERROR:
                    return cell.ErrorCellValue;
                case CellType.Formula: //FORMULA:
                default:
                    return "=" + cell.CellFormula;
            }
        }