Adding multiple sheets to a xls file does not work.

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
d3nton
Posts: 137
Joined: Thu Oct 25, 2012 9:48 am

Adding multiple sheets to a xls file does not work.

Post by d3nton »

Hi!

It seems that adding multiple sheets to a xls file does not work properly.

Sample code:
var
ExcelFile : TXLSReadWriteII5;
begin
ExcelFile := TXLSReadWriteII5.Create(nil);
ExcelFile.Filename := 'D:\output.xls';
ExcelFile.Version := Xc12Utils5.xvExcel97;
ExcelFile.Add;
ExcelFile.Add;
ExcelFile.Add;

ExcelFile.Write;
end.

The code works for xlsx files.

It is also not possible to rename a sheet:
ExcelFile.sheets[0].Name := 'test'; <- does not change the sheetname in xls files.

Any help would be apopreciated.
Thank you.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Adding multiple sheets to a xls file does not work.

Post by larsa »

Hello

This is fixed in update 5.10.05
Lars Arvidsson, Axolot Data
d3nton
Posts: 137
Joined: Thu Oct 25, 2012 9:48 am

Re: Adding multiple sheets to a xls file does not work.

Post by d3nton »

Hi.

This error occurs again in V5.10.26. Could you please fix it.
Thank you.

best regards.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Adding multiple sheets to a xls file does not work.

Post by larsa »

Hello

This is fixed in update 5.10.28
Lars Arvidsson, Axolot Data
d3nton
Posts: 137
Joined: Thu Oct 25, 2012 9:48 am

Re: Adding multiple sheets to a xls file does not work.

Post by d3nton »

Wow, that was really quick :)
Thank you. Works fine.
Post Reply