I am trying to save information stored in database to an Excel file. I am not sure how to solve my problem because what I need is to be able to set cell values by looping through columns and rows. I dont want to reference a cell by using the usual A1, B2,
C3 and so forth. I want to be able to loop through columns and rows and set values as they are read from database. Se pseudocode below
For Each column in database
For Each post
Write value to cell in Excel file
I can not do the above procedure since I need to reference cells by letter and digit for column and row and the only way to do that smoothly is to do a switch and case by case (Case: A1...) perform write to cell.
To put it short, is there a function or any way I can somehow generate the A1, B2 etc. column/row names because I really need to loop through the rows and columns and I dont see how this is solved with the usual
SetCellValue('A1', 'Hello') code.
Any help or tips regarding this is appreciated.