Axolot Data

Posted: **Tue May 31, 2016 7:27 am**

Hi Support,
I try to create runtime and save an XLS file in version 97 but when I write it the file is XLSX type.

   xls := TXLSReadWriteII5.Create( nil );
   try
        xls.Version := xvExcel97;
        xls.Filename := 'C:\Test.xls';
        xls.Add;
        xls.Sheets[ 0 ].AsString[ 0, 0 ] := 'D_TRANSAZIONE';
        xls.write
   finally
      FreeAndNil( xls );
   end;

Can you help me ?

thanks

Alberto

Posted: **Tue May 31, 2016 12:01 pm**

Hello

Your code works correct. It creates an XLS file.

Posted: **Wed Oct 05, 2016 3:18 pm**

Hello,

we have the same problem with the version 5.20.79, I have set version to 97 before I call the write function.
When Excel opens the file, it signalises that the file has a wrong extension. This warning is correct, it's xlsx!

What is the problem / solution?

Best regards,
JP

Posted: **Wed Oct 05, 2016 7:46 pm**

Hello

Don't know. I get an XLS file if I uses the code above.

Axolot Data

Create and Save .XLS file ( not XLSX ) at runtime

Create and Save .XLS file ( not XLSX ) at runtime

Re: Create and Save .XLS file ( not XLSX ) at runtime

Re: Create and Save .XLS file ( not XLSX ) at runtime

Re: Create and Save .XLS file ( not XLSX ) at runtime