Skip to content

Invalid Cell Range returns header row value  #686

@weirdyang

Description

@weirdyang

Excel Type

  • XLSX

Upload Excel File

Please attach your issue file by dragging or droppng, selecting or pasting them.
test.xlsx

MiniExcel Version

1.34.2

Description

image

When I use QueryRange with an invalid cell address, I expect MiniExcel to throw an System.IO.InvalidDataException

Using cell address "ZZDD11" throws System.IO.InvalidDataException : ColumnIndex 474659 over excel vaild max index.

However when I use a cell address like "ZZFF@@10", it returns the header row values.

Sample code:

             var row2 = MiniExcel
                .QueryRange(
                "test.xlsx",
                useHeaderRow: false,
                startCell: "ZZFF@@10",
                endCell: "ZZFF@@10")
                .Cast<IDictionary<string, object>>().First();

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions