I have a UltraGrid, populated with cca 22.000 rows and and 10 columns at most (It never breaks 65536 barrier). When I export the contents of the grid to excel file, everything goes well, but when I want to open file with excel, it gives me following notification:Excel found unreadable content in 'export.xls'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.
When I click Yes, it tries to repair the damage but is unable to do it. The only column whose value gets exported is the one that is of type boolean.
I am using NetAdvantage for .NET 2007 Vol. 3 CLR 2.0 with latest (1043) patch applied. What could possibly cause this error? Column types are mainly strings and integers with the exception of one Guid and abovementioned boolean. I use no intermediate features of grid (ie calculated columns, summaries, etc.). It is simply a ultragrid bound to datasource. In all other cases throughout my application everything works fine with the exception of this grid which contains quite a lot of rows.
Best regards.
Try free demo version of Excel File Repair tool to repair corrupt .xls and .xlsx Excel files with the actual data formatting. It provides a wide repair solution for all kind of Excel file errors. The tool can successfully repair Excel files from the following mention Excel file errors.
'Excel found unreadable content in filename.xls'
'Unable to read file'
'The document cannot be saved'
'Excel cannot open the file '(filename)'.xlsx'
'The file is corrupt and cannot be opened'
Go through this link http://www.datarepairtools.com/excel-recovery.html to download the evaluation version of Excel Repair Tool.
There are lots of errors occurs while handling a MS Excel file some of them can be easily resolved but all are not, to solve some serious corruption problems you need to apply a professional MS Excel repair tool, as it is very helpful tool I have ever used, it helped me when I have caught with such issue, I hope it will work for you also. This advance Kernel for Excel repair tool provide perfect repair of Excel database with all text, hyperlinks, objects, graphs, OLE objects, etc . For more information visit here : http://www.excelfilerepair.org
Don't worry, I would like to advices you use Stellar Phoenix Excel Repair Software which one-stop solution to repair files of MS Excel. With this software you can easily recover/repair all damaged XLS/XLSX files in their original format. It can easily recover all damaged Excel file like as,text, hyper links, objects, graphs, OLE objects, etc. Get more information,
& Visit here:- http://www.mannatsoftware.com/stellar-phoenix-excel-repair.html
Excel file recovery tool extract data from damaged XLS/XLSX files. It is integrated with powerful algorithm that ensures quick and complete recovery of damaged Excel files. To get more details visit here:- http://www.recoverydeletedfiles.com/sql-database-recovery-software.html
Hi everyone,
I've submitted the issue to the support group: http://es.infragistics.com/gethelp. They've provided me with hotfix which fixed an export bug. I suggest you contact them in case you encounter any problems with export capabilities.