使用ClosedXML在C#中打开xlsx文件时出现ArgumentOutOfRangeException异常
使用ClosedXML v0.102.3打开Excel文件时抛出ArgumentOutOfRangeException异常
我用NuGet上的最新版ClosedXML(v0.102.3)可以打开部分电子表格,但多数文件都打不开。不管是从网络驱动器还是本地路径加载,都会抛出以下异常:
System.ArgumentOutOfRangeException HResult=0x80131502 Message=Specified argument was out of the range of valid values. Parameter name: A: is not recognized as a column letter Source=ClosedXML StackTrace: at ClosedXML.Excel.XLHelper.GetColumnNumberFromLetter(String columnLetter) at ClosedXML.Excel.XLAddress.Create(XLWorksheet worksheet, String cellAddressString) at ClosedXML.Excel.XLWorkbook.LoadCells(SharedStringItem[] sharedStrings, Stylesheet s, NumberingFormats numberingFormats, Fills fills, Borders borders, Fonts fonts, Dictionary`2 sharedFormulasR1C1, XLWorksheet ws, Dictionary`2 styleList, Cell cell, Int32 rowIndex) at ClosedXML.Excel.XLWorkbook.LoadRows(Stylesheet s, NumberingFormats numberingFormats, Fills fills, Borders borders, Fonts fonts, XLWorksheet ws, SharedStringItem[] sharedStrings, Dictionary`2 sharedFormulasR1C1, Dictionary`2 styleList, Row row) at ClosedXML.Excel.XLWorkbook.LoadSpreadsheetDocument(SpreadsheetDocument dSpreadsheet) at ClosedXML.Excel.XLWorkbook.LoadSheets(String fileName) at ClosedXML.Excel.XLWorkbook..ctor(String file, LoadOptions loadOptions) at ClosedXML.Excel.XLWorkbook..ctor(String file) at ClosedXML.Test.ClosedXML.Open() in C:\Data\Visual Studio\ClosedXML\ClosedXML.Test\ClosedXML.cs:line 16
补充说明:我获取了ClosedXML官方的develop分支版本后,这个异常不再出现,但又遇到了其他问题。我会直接和开发者沟通,此问题可关闭。
有人遇到过这个问题吗?
内容的提问来源于stack exchange,提问作者Joe Moore
相关产品推荐
相关产品推荐

