Query faild on specific xlsx file, throws ExcelColumnNotFoundException

[AZhrZho]

Excel Type

• XLSX
• XLSM
• CSV
• OTHER

Upload Excel File

Issue.xlsx

MiniExcel Version

623ecc8

Description

public class IssueVO
{
    public string Col1 { get; set; }
    public string Col2 { get; set; }
    public string Col3 { get; set; }
}
       
var items = MiniExcel.Query<IssueVO>("issue.xlsx").ToList();

MiniExcelLibs.Exceptions.ExcelColumnNotFoundException : ColumnName : Col2, CellRow : 2, value of String type not found.

ExcelOpenXmlSheetReader.ThrowExcelColumnNotFoundException(ExcelColumnInfo pInfo, Int32 rowIndex, String startCell, IDictionary`2 headers, IDictionary`2 row) 行 518
ExcelOpenXmlSheetReader.QueryImpl[T](IEnumerable`1 values, String startCell, Configuration configuration)+MoveNext() 行 499
MiniExcel.Query[T](Stream stream, String sheetName, ExcelType excelType, String startCell, IConfiguration configuration)+MoveNext() 行 73
MiniExcel.Query[T](String path, String sheetName, ExcelType excelType, String startCell, IConfiguration configuration)+MoveNext() 行 66
Enumerable.Count[TSource](IEnumerable`1 source)
MiniExcelIssueTests.Issue20240424() 行 3493