SaveToXLS problem in TAdvGrid with Excel 2010

Hi there,

I am saving contents of a TAdvStringGrid to an Excel file using TAdvExcelIO.
The files can be read by Excel versions between 97 and 2007.

But trying to open a generated file with Excel 2010 gives the following error:

'Excel found unreadable content in ...Do you want to recover the contents of this workbook? If you trust the source of this workbook, click yes'.


Do you have a clue why all excel version prior to 2010 could open the files and excel 2012 refuses to do so?
Is there a workaround?

If needed I can provide an excel sheet with shows the described error.

The project is compiled with D5. Due to this I have to use an old version of the XLSAdapter.
FlexcelVersion.inc shows the version number 3.0.5. Version of the TMSComponentPack is 5.2.3.0

Thanks for any hints!


Regards,

Robert

Hi,

You need XlsAdapter 3.2 or newer:

http://www.tmssoftware.com/site/blog.asp?post=154

I am not sure on how to workaround this, but you might try getting the latest xlsadapter and compilingit under D5, it might compile. I don't have D5 installed here anymore, so I can't test it.

Regards,
   Adrian.