You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

使用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

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.06.20 08:40:04