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
Parents
  • 20255
    Offline posted

    Hello Paul,

    Thank you for contacting us.

    I will need more information in order to reproduce the issue and to investigate it further for you. Could you please share a small sample or a code snippet, along with details like: exact product version and when this issue started to appear.

    Looking forward to hearing from you.

Reply Children