Page 1 of 1

code porting from v4

Posted: Mon Mar 04, 2013 11:03 am
by andrea.m86
Hi
i've just updated my components from the previous version.
I've got some already written code that i have to make work with the new version but i have some problems with these statements:
xls.sheets.clear;
xls.sheets.add;
xls.sheets[0].rows.count;
These generate errors at compile-time (even if with the previous version everything worked fine)
how can i do these operation now?
Thanks.
Andrea

Re: code porting from v4

Posted: Mon Mar 04, 2013 5:22 pm
by larsa
Hello

Use XLS.Clear and XLS.Add instead. As there is no real Rows object, use XLS[0].LastRow to get the row count.

Re: code porting from v4

Posted: Wed Mar 06, 2013 11:14 am
by andrea.m86
Thanks!
"XLS.Clear" also replace the old "XLS.sheets.clearworksheet"?

Re: code porting from v4

Posted: Wed Mar 06, 2013 2:51 pm
by larsa
Hello

No, use XLS.ClearWorkshhet