How to inc a string? (A->B->C->etc.)

MrCul1

Hi.

What i need to do is a report for excel. Something like:

 REPEAT
    xlWorkSheet.RANGE( incStr +'1' ).VALUE := FORMAT(Table.Field); // yeah i need as much colums as are rows in the table
 UNTIL Table.NEXT=0;

My own idea is that I can use a array of strings (static will be ok, because there are never more than 50 rows in that table), but then is there a good way to fill that array. Writing 50 rows code for that does not seems right thing to do.?

Any idea?
Thanks.

fb

Look at the "Column No." OnValidate trigger in Table 370 - Excel Buffer.

There you will see a 'standard' method for computing an 'ExcelColumnID' from an integer...

MrCul1

Uhh my own solution:

  tmpStr := 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';

  FOR i :=1 TO 26 DO
  arrColumn[i] := FORMAT(tmpStr[i]);

  FOR i :=1 TO 26 DO
  arrColumn[26+i] := 'A'+FORMAT(tmpStr[i]);

But seems that fb's solution is lot better but more complex.

SteveO

Why not just use the excel buffer table?

You just need to validate a number into Column No. and then read the value out of Column ID.

No need for another function...