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)

gu.xlsx

  • 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)

Most upvoted comments

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 press Ctrl+End on the App worksheet, you should be reaching E617, not XFD617.