c# - 通过 ExcelDataReader 导入 *.xlsx 数据，受影响的记录数为 0

Question

我使用 ExcelDataReader 和 ExcelDataReader.DataSet 库从 xlsx 文件中读取超过 1700 行。最终，没有读取记录。但是，如果我们将 dile 中的行数限制为 9 - 所有行数据都会被正确读取。这是代码：

 private IEnumerable<T> ParseImportSourceFile<T>(string fileName, byte[] file) where T : CsvClassMap
    {
        IEnumerable<T> records = null;

        var extensionEnd = Path.GetExtension(fileName).ToLower();
        switch (Path.GetExtension(fileName).ToLower())
        {
            case ".csv":                    
                break;
            case ".xls":
            case ".xlsx":
            case ".ods":
                records = new List<T>();

                var memoryStream = new MemoryStream(file);
                var streamReader = new StreamReader(memoryStream);
                var reader = ExcelReaderFactory.CreateReader(streamReader.BaseStream);
                if (extensionEnd == ".xlsx")
                {
                    reader = ExcelReaderFactory.CreateOpenXmlReader(streamReader.BaseStream);
                    //reader.
                }
                  //reader.AsDataSet().
                try
                {

                    var result = reader.AsDataSet(new ExcelDataSetConfiguration()
                    {
                        UseColumnDataType = true,
                        ConfigureDataTable = (tableReader) => new ExcelDataTableConfiguration()
                        {
                            EmptyColumnNamePrefix = "Column",
                            UseHeaderRow = true,
                        }
                    });

                    if (result.Tables.Count > 0)
                    {
                        var tbl = result.Tables[0];
                        //grab column names into array
                        var columns = new DataColumn[tbl.Columns.Count];
                        tbl.Columns.CopyTo(columns, 0);

                        //grab properties of T class
                        var tType = typeof(T);
                        var properties = tType.GetProperties(BindingFlags.Public | BindingFlags.Instance);

                        for (int i = 0; i < tbl.Rows.Count; i++)
                        {
                            //one row one record... create an instance for each row
                            var row = tbl.Rows[i];
                            var record = Activator.CreateInstance<T>();
                            //read all columns and try set valid property
                            foreach (var col in columns)
                            {
                                var prop = properties.FirstOrDefault(x => x.Name == col.ColumnName ||
                                                                        (x.GetCustomAttribute<DisplayAttribute>() != null && x.GetCustomAttribute<DisplayAttribute>().Name == col.ColumnName));

                                if (prop != null && prop.CanWrite)
                                {
                                    //
                                    var sourceValue = row[col.ColumnName];
                                    if(!(sourceValue is DBNull))
                                        prop.SetValue(record, Parse(prop.PropertyType, sourceValue.ToString()));
                                }
                            }

                            ((IList<T>)records).Add(record);
                        }
                    }
                }
                finally
                {
                    if (reader != null) reader.Dispose();
                    if (streamReader != null) streamReader.Dispose();
                    if (memoryStream != null) memoryStream.Dispose();
                }
                break;
            default:
                throw new ImportException("Template is not valid.");
        }

        return records;
    }

我对 xlsx 文件使用 CreateOpenXmlReader 方法，因为它在 stackoverflow 上被建议。tbl.Rows.Count 为零 - 来自 xlsx 文件中的 1700 多行。请帮忙

标签： c#exceldatareader