xlColId+something

Jaydk

IF i have xlColId = H from the excelBuffer, and a number e.g. 2, how can i get xlColdId+2 = J

kine

Try to use something like this:

t := 'A';
t[1] := t[1]+2;
Message('%1',t);

t is of type Text. You can "increase" character type by integer to get new character (of course only in values 0..255).

Jaydk

Nice.. That worked.. thanks alot

Jaydk

An extra question.. What happens when the excel sheet get so wide that the xlcolId is two letters like AA or AB?

kine

You need to handle it. If the Caracter is Z, you need to continue with AA. If you have AZ, you need to increment to BA etc...