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

MrCul1
MrCul1 Member Posts: 8
edited 2004-12-23 in Navision Attain
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.

Comments

  • fb
    fb Member Posts: 246
    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
    MrCul1 Member Posts: 8
    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
    SteveO Member Posts: 164
    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...
    This isn't a signature, I type this at the bottom of every message

Categories