Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
2350
Excel - "Value cannot be null. Parameter name: key" error when saving
posted

Hello,

I'm receiving a "Value cannot be null. Parameter name: key" error when saving an Excel workbook. I've pretty much stripped everything out of the workbook and I've narrowed it down to the attached example file.

To duplicate this, just run the following code on the attached file:

Workbook workbook = Workbook.Load(@"C:\buggedspreadsheet.xlsx");

workbook.Worksheets[1].Rows.Remove(2);

workbook.Save(@"C:\Users\Paul\Downloads\new.xlsx");

This is a critical issue for us as we've built a process around the Infragistics Excel functionality that needs to run everyday. We have multiple worksheets that this started happening in, and I'm unable to track down the underlying problem. Please provide more information on this error.

Thanks,

Paul

buggedspreadsheet.zip