I have a strange problem.
Using version 18.104.22.168 and version 22.214.171.124 of the excel component, I am not able to open the attached file. The error message is : “Index was outside the bounds of the array.”. Using version 126.96.36.199 I can open, modify and save the file.
The code I use (the arguments for the open-method leads to the actual file):
Excel xl = new Excel();
xl.Open(templatesPath + ConfigurationSettings.AppSettings[“TimeDistribution”] + “.xls”);
Seems to me there is some functionality that is lost along the way. Is this something you could look into?
In MS Excel, all drawing objects are related to each other. In these new versions, we tried to access images and charts in designer templates. This caused this bug. I fixed it. Please try the attached dll.
I have downloaded the latest version (v.188.8.131.52) from the download-pages. I still get the same error (and error-message).
I re-tested your file and didn't find your problem. The following is my test code:
Excel excel = new Excel();
excel.Open("c:\\Time distribution v2.xls");
I added some new features in this new attached dll. Please try it. And please verify that your project refers to this new dll. You can remove reference to Aspose.Excel and re-add this reference in your project.
Now it works. Thank you very much.