Page 1 of 1

Adding multiple sheets to a xls file does not work.

Posted: Wed Mar 13, 2013 12:37 pm
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.

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

Posted: Wed Mar 13, 2013 2:55 pm
by larsa
Hello

This is fixed in update 5.10.05

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

Posted: Fri Jun 28, 2013 8:58 am
by d3nton
Hi.

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

best regards.

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

Posted: Fri Jun 28, 2013 10:13 am
by larsa
Hello

This is fixed in update 5.10.28

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

Posted: Fri Jun 28, 2013 11:02 am
by d3nton
Wow, that was really quick :)
Thank you. Works fine.