ClosedXML: Getting Exception of System.ArgumentOutOfRangeException type
Do you want to request a feature or report a bug?
- Bug
- Feature
Version of ClosedXML 0.93.0
What is the current behaviour? System.ArgumentOutOfRangeException: ‘Specified argument was out of the range of valid values. Parameter name: AZA is not recognized as a column letter’
What is the expected behaviour or new feature? It is expected to open this file just like other files.
Did this work in previous versions of our tool? Which versions? No
Reproducibility
Code to reproduce problem:
var path = "gu.xlsx";
var wb = new XLWorkbook(path);
System.ArgumentOutOfRangeException: ‘Specified argument was out of the range of valid values. Parameter name: AZA is not recognized as a column letter’
That this the error I get when I try to open an excel file (attached here)
- I attached a sample spreadsheet. (You can drag files on to this issue)
About this issue
- Original URL
- State: closed
- Created 6 years ago
- Reactions: 1
- Comments: 16 (7 by maintainers)
There is a bug in ClosedXML, but you can easily work around this by deleting columns
App!F:XFD. It will decrease the file size too. If you pressCtrl+Endon theAppworksheet, you should be reachingE617, notXFD617.