时间戳

首页 > 解决方案 > 如何解决序列在 CLOSEDXML 中包含多个匹配元素的问题？

vb.net - 如何解决序列在 CLOSEDXML 中包含多个匹配元素的问题？

问题描述

我正在做的只是保存一个excel模板而不插入任何数据......
这是我下面的代码。

Dim wb As XLWorkbook
wb = New XLWorkbook(rawfilelocation)
wb.SaveAs(filelocation, True) '---- I even tried false

我每次都会遇到这个错误。

System.InvalidOperationException: Sequence contains more than one matching element
   at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source, Func`2 predicate)
   at ClosedXML.Excel.XLDataValidations.ProcessRangeRemoved(IXLRange range)
   at ClosedXML.Excel.XLDataValidations.Delete(IXLDataValidation dataValidation)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at ClosedXML.Excel.XLDataValidations.Consolidate()
   at ClosedXML.Excel.XLWorkbook.GenerateWorksheetPartContent(WorksheetPart worksheetPart, XLWorksheet xlWorksheet, SaveOptions options, SaveContext context)
   at ClosedXML.Excel.XLWorkbook.CreateParts(SpreadsheetDocument document, SaveOptions options)
   at ClosedXML.Excel.XLWorkbook.CreatePackage(String filePath, SpreadsheetDocumentType spreadsheetDocumentType, SaveOptions options)
   at ClosedXML.Excel.XLWorkbook.SaveAs(String file, SaveOptions options)
   at ClosedXML.Excel.XLWorkbook.SaveAs(String file, Boolean validate, Boolean evaluateFormulae)
   at nproject.frmReportPreview.ExcelSave(String ExcelFile, String Excelext) in D:\MainProject\nproject\nproject\frmReportPreview.vb:line 1312

我什至在这里发布了一个 Excel 模板 Dropbox 链接

Excel 模板

标签： vb.netclosedxml

解决方案

推荐阅读