Questions and answers on how to use XLSReadWriteII 5.
polfi
Posts: 2 Joined: Mon Mar 18, 2013 3:01 pm
Post
by polfi » Mon Mar 18, 2013 3:17 pm
Hi,
1. There is a missing unit (Xc12Graphics.pas) source code in the downloaded install executable.
2. In Excel97 TXLSWorksheet.FreezePanes(0, 1); is not working.
3. This code causes Access Violation (Delphi XE):
Code: Select all
XLS.Clear;
XLS.Filename := 'D:\teszt.xlsx';
XLS.Version := xvExcel2007;
XLS[0].AsString[0,0] := 'abc';
XLS.Add;
XLS[1].AsString[0,0] := 'abc';
XLS.Write;
This code worked me on 5.10.05.
Best Regards,
Polfi
larsa
Site Admin
Posts: 926 Joined: Mon Jun 27, 2005 9:30 pm
Post
by larsa » Thu Mar 21, 2013 9:31 am
Hello
1,2: FIxed in update 5.10.07
3: Can't reproduce that.
Lars Arvidsson, Axolot Data
polfi
Posts: 2 Joined: Mon Mar 18, 2013 3:01 pm
Post
by polfi » Thu Mar 21, 2013 10:09 am
Thank you for your reply!
3. You can reproduce the problem if you change the unit order from "XLSReadWriteII5, XLSSheetData5" to "XLSSheetData5, XLSReadWriteII5". After I have changed the order to "XLSReadWriteII5, XLSSheetData5" the component works well.
Best regards,
Polfi
larsa
Site Admin
Posts: 926 Joined: Mon Jun 27, 2005 9:30 pm
Post
by larsa » Mon Mar 25, 2013 6:51 am
Hello
The problem is fixed in update 5.10.08.
Lars Arvidsson, Axolot Data