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
In the initial post there was one xlsx file with empty rows and just one value in cell A10 (number 1) and 3 rows of code. In order to create a sample I will need more code and information. The thread is under "ASP.NET MVC Helpers" section and I am wondering if it is related to them.
Is it possible for you to provide a small sample that is showing the issue, this would be highly appreciated.
Thanks for the quick response.
The version I am using is 2015.1.2112.
I provided a code snippet and example file in my initial post. Did you not get those? Just run the code using the attached xlsx file and the issue should reproduce on the "workbook.Save(@"C:\Users\Paul\Downloads\new.xlsx");" call.
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.