XLSGrid - Changing tab at run time

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
jwan
Posts: 2
Joined: Thu Sep 09, 2021 10:18 am

XLSGrid - Changing tab at run time

Post 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?
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: XLSGrid - Changing tab at run time

Post by larsa »

Hello

Here is an example example:

Code: Select all

XLSGrid.XLS.SelectedTab := SheetIndex;
XLSGrid.XLSChanged;
Lars Arvidsson, Axolot Data
jwan
Posts: 2
Joined: Thu Sep 09, 2021 10:18 am

Re: XLSGrid - Changing tab at run time

Post 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.
Post Reply