Hi,
I'm using Aspoce.Cells 4.8.1 to generate an Excel file.
I'm trying to extract about 850 lines from my DB, but i receive a corrupted file message while trying to open it with excel. The maximum number of line that i can extract is 505. Starting at 506 i receive the error message. The data is in the workbook, but Macros and text formatting are deleted.
I use the range copy property to copy the first line from my workbook range over all the extracted data.
Thanks for you help.
Samuel
Hi Samuel,
Please post the corrupted file which is generated by Aspose.Cells for .NET.
The attached file has been saved by MS Excel. We could not find the issue, so we need the corrupted file here.
And, we tried the following code, it works fine.
Workbook workbook = new Workbook();
workbook.Open(@“F:\FileTemp\file_WITHOUT_problem.xls”);
Cells cells = workbook.Worksheets[0].Cells;
cells[“A513”].PutValue(“19904aca-a931-4b85-8aa0-d9eb2ca670e7”);
cells[“B513”].PutValue(“3bc7aa44-249a-432b-8403-8ff874c5d0ad”);
cells[“C513”].PutValue(43);
cells[“D513”].PutValue(40118);
cells[“E513”].PutValue(“non confirmer”);
cells[“F513”].PutValue(79.2);
cells[“G513”].PutValue(40120);
cells[“H513”].PutValue(237.6);
workbook.Save(@“F:\FileTemp\dest.xls”);
I have also attached the latest fix, if you could try it first.
Thank you.
Here are the files ; take two.
Hi,
Thank you for sharing the corrupt file. We will look into it and get back to you soon.
Thank You & Best Regards,
Hi,
Well, we find there are too many CellAreas in a validation.
Could you create a sample project to show how to import data? We will check it soon.
We really appreciate your help in this regard.
Thank you.
Hi,
Thank you for considering Aspose.
Please try the attached latest version of Aspose.Cells. We have enhanced copying validations in copying rows. If you still face any problem, please post your sample project here and we will check it soon.
Thank You & Best Regards,
Everything works fine with this new version !
Thanks a lot for your help !!