Page 1 of 1

XLSGrid - Changing tab at run time

Posted: Thu Sep 09, 2021 10:21 am
by jwan
Hi, I am testing the XLSReadWriteII and upon testing XLSGridSample, I am interested to know if there is a way to programatically change/select tab if there are several tabs in the xLS file?

Re: XLSGrid - Changing tab at run time

Posted: Fri Sep 10, 2021 10:32 am
by larsa
Hello

Here is an example example:

Code: Select all

XLSGrid.XLS.SelectedTab := SheetIndex;
XLSGrid.XLSChanged;

Re: XLSGrid - Changing tab at run time

Posted: Tue Sep 14, 2021 9:19 am
by jwan
Thank you for that, been trying so many things and didn't know need to do the XLSChnaged.
Maybe Im asking some dumb questions, but I have been trying several test as well and all failed.. anyhow, here are my question:

1. is there a way to select whole row or whole column or selected area or 2 or more non-adjacent cells at runtime?

2. is there a way to color the whole row/column or whatever is selected under #1 above at runtime?

3. I cant find in the samples, how to determine if a cell is a "date" or "time" or "date-time"? it seems all date/time are considered as string.

Thanks.