Hi Aspose Support Team,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
I am currently using Aspose.Cell.dll version 22.214.171.124 to format excel files. One of the formatting requires deletion of a specific column (example Column M). However I am unable to achieve this and while opening the formatted file it is giving the error: Error found unreadable content in 'Book1_formatted_126.96.36.199.xls'. Do you want to recover the contents of this workbook? if you trust the source of workbook, click Yes
Clicking Yes, opens the file but again following message is displayed: Excel was unable to open the file by repairing or removing the unreadable content (please refer the screen shot DeleteColumn_Issue.jpg attached herewith).
I downloaded the latest version 188.8.131.52 of the Aspose.Cells.dll. however it does not solve the issue.
Earlier I was using the version 184.108.40.206 of Aspose.Cells.dll, I tried with it and seems that formatting is happening properly with version 220.127.116.11 and there are no errors encountered.
foreach (Worksheet ws in WorkBook.Worksheets)
ws.Cells.DeleteColumn(12); //Delete Column M
Also the formatted files for each version are attached herewith. Requesting you to please provide you feedback on the above mentioned issue.
Thanks & Regards,