Free Support Forum - aspose.com

Unable to open the excel file after it was modified by Aspose.Cells

Hi there,



thanks for helping me out last time and I’m very satisfied with Aspose.Cells.



However I received a template from a costumer that causes problems after I saved it with Aspose.Cells. It contains several controls like drop down menus and radio buttons that might be the reason for it. I’m only interested in writing some integer values into the empty cells tho.



I hope you can see what’s wrong there.



Cheers,

Dirk



Ah, forgot to mention that I’m using the latest Aspose.Cells version.

Hi Dirk,

Thanks for considering Aspose.

Well I did open it using Aspose.Cells, modified and inserted some values into first two sheets of your template file and all is fine. I can open the file and see the results using MS Excel. I use the following sample code with Aspose.Cells 4.1:

Workbook workbook = new Workbook();

workbook.Open(@"d:\Tiefbaukalkulation.xls");

workbook.Worksheets[0].Cells["D1"].PutValue("testing");

workbook.Worksheets[0].Cells["D5"].PutValue(123);

workbook.Worksheets[1].Cells["I10"].PutValue(100);

workbook.Worksheets[1].Cells["I11"].PutValue(21.75);

workbook.Save("d:\\outputfile.xls");

Note: Please see the attached file with this post.

And by the way are you using Aspose.Cells for .Net and which version?

Regards

Amjad Sahi

Aspose Nanjing Team.

Hi,

If you are using Aspose.Cells for Java ,please try this fix.

Oh yeah, it was the Java release, sorry for not mentioning it.



It works! I appreciate it, thank you very much!



Cheers,

Dirk