This project has moved. For the latest updates, please go here.

Is there a way to turn off processing LoadHyperlinks on load (null Obj)?

Aug 14, 2012 at 3:32 PM

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 
StackTrace:
       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. 

Coordinator
Aug 15, 2012 at 7:56 PM

Create an issue and attach a file that throws the error when loading.