Parameterize Excel Columns for 2-Dimensional Array

[defcon3]

Hi Guys

I'm trying copy data from a 2-dimensional array into an Excel sheet but the problem I'm having is how can I move to the next column of the Excel sheet using a For Loop to go through the array.

The excel sheet columns are labelled "A","B" etc, how can I move to the next column without having to write a statement for each column.
.
.
.

Code:

For i=0 to Some_value
  For j= 0 to Some_value
    objWorkSheet.cells(i+1, "A")=MyArray(i,j)
   Next
Next

.

The rows are fine because they're a parameter of the For Loop but how can I parameterize the columns so I can use j to keep track of the column.

[sshukla12]

Hi,
Instead of specifying the column label use column number to pass the values
for ex:

Code:

For i=0 to Some_value
  For j= 0 to Some_value
    objWorkSheet.cells(i+1, [color=#FF0000]j+1[/color])=MyArray(i,j)
   Next
Next

Let me know in case of any help required.

Regards,
Sankalp

[defcon3]

Thanks for your input, will using the column number work without me going into preferences to make Excel show column numbers instead of letters?