XLSGrid - Changing tab at run time

[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?

[larsa]

Hello

Here is an example example:

Code: Select all

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

[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.