Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Invalid Cell Range returns header row value #686

Open
1 task done
weirdyang opened this issue Oct 30, 2024 · 0 comments
Open
1 task done

Invalid Cell Range returns header row value #686

weirdyang opened this issue Oct 30, 2024 · 0 comments

Comments

@weirdyang
Copy link

weirdyang commented Oct 30, 2024

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();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant