My process reads in invoices, but I found one of them throws an error as soon as I load it.
System.NullReferenceException was caught Message=Object reference not set to an instance of an object. Source=ClosedXML
at ClosedXML.Excel.XLWorkbook.LoadHyperlinks(Hyperlinks hyperlinks, WorksheetPart worksheetPart, XLWorksheet ws)
at ClosedXML.Excel.XLWorkbook.LoadSpreadsheetDocument(SpreadsheetDocument dSpreadsheet)
at ClosedXML.Excel.XLWorkbook.LoadSheets(String fileName)
at ClosedXML.Excel.XLWorkbook.Load(String file)
at ClosedXML.Excel.XLWorkbook..ctor(String file, XLEventTracking eventTracking)
at ClosedXML.Excel.XLWorkbook..ctor(String file)
It opens without issue in excel and the links are visible but it doesn't look like there is anything listed for the actual link (I believe excel is doing some defaulting when I open the links for editing). If I remove or tinker with all 3 links I can get
it through the load. The spreadsheet that works does seem to have more filled out for 2 of the 3 links on the sheet.
In either case I don't need the links and I was wondering if there is a less strict option for loading.
Great job on this project so much easier then OpenSDK and interop.