Page 1 of 1

XLSReadWriteII 5 - Help

Posted: Thu Dec 06, 2012 1:02 pm
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!

Re: XLSReadWriteII 5 - Help

Posted: Thu Dec 06, 2012 3:39 pm
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

Re: XLSReadWriteII 5 - Help

Posted: Fri Dec 07, 2012 3:18 pm
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.

Re: XLSReadWriteII 5 - Help

Posted: Mon Dec 10, 2012 8:39 am
by d3nton
Hello.

Okay, thanks.
I got the most of my code to work.
Nevertheless a help file would be nice.

Re: XLSReadWriteII 5 - Help

Posted: Mon Dec 10, 2012 9:01 am
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

Re: XLSReadWriteII 5 - Help

Posted: Mon Dec 10, 2012 2:21 pm
by omegadog
How to do this:

Cell[Col, Row].AssignFormat(FormatIndex)

Re: XLSReadWriteII 5 - Help

Posted: Thu Dec 13, 2012 9:11 am
by larsa
Hello

FormatIndex is not used anymore. Please see the FormatCell sample form more details.

Re: XLSReadWriteII 5 - Help

Posted: Thu Dec 13, 2012 1:13 pm
by omegadog
FormatCell example folder is empty.