XLSReadWriteII 5 - Help

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

XLSReadWriteII 5 - Help

Post by d3nton »

Hi!

I am trying to update to XLSReadWriteII Version 5.
But it is hard to get the old code working with the new version.
It seems that a lot of methods, types and units have changed but I found
only a few changes in the changes.txt and also the examples in the 'Samples' folder are very minimalistic.
Is there a help file or s.th. similar available which documents the complete changes in Version 5?
This would be very helpful.

Thanks in advance!
PStadler
Posts: 44
Joined: Sat Feb 18, 2006 8:19 am

Re: XLSReadWriteII 5 - Help

Post by PStadler »

Hello,

This is really a problem.

It seems to me that it is possible to have installed TXLSReadWriteII5 and the old TXLSReadWriteII4 in the same project. Is this true?

Sincerely Peter
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: XLSReadWriteII 5 - Help

Post by larsa »

Hello

We are working on the documentation. If you have any specific questions, please let me know.
You can have any combination of the component versions installed at the same time. This is intentional.
Lars Arvidsson, Axolot Data
d3nton
Posts: 137
Joined: Thu Oct 25, 2012 9:48 am

Re: XLSReadWriteII 5 - Help

Post by d3nton »

Hello.

Okay, thanks.
I got the most of my code to work.
Nevertheless a help file would be nice.
PStadler
Posts: 44
Joined: Sat Feb 18, 2006 8:19 am

Re: XLSReadWriteII 5 - Help

Post by PStadler »

Hello,

I also could compile my projects with XLSReadWriteII 5.
The global Changes were

XLSReadWriteII4 --> XLSReadWriteII5
.Sheets[ --> [
.Sheets.Count --> .Count

More than that, if you want to use
XLSReadWriteII51[0].LastRow;

then after the Read statement must follow CalcDimensions,
otherwise the integer value returns -1 instad of LastRow or LastColumn.

e.g.

XLSReadWriteII51.Read;
XLSReadWriteII51.CalcDimensions;
maxMessageNumber := XLSReadWriteII51[0].LastRow;

Sincerely

Peter
omegadog
Posts: 10
Joined: Mon Jun 18, 2012 12:52 pm

Re: XLSReadWriteII 5 - Help

Post by omegadog »

How to do this:

Cell[Col, Row].AssignFormat(FormatIndex)
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: XLSReadWriteII 5 - Help

Post by larsa »

Hello

FormatIndex is not used anymore. Please see the FormatCell sample form more details.
Lars Arvidsson, Axolot Data
omegadog
Posts: 10
Joined: Mon Jun 18, 2012 12:52 pm

Re: XLSReadWriteII 5 - Help

Post by omegadog »

FormatCell example folder is empty.
Post Reply