Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Parameterize Excel Columns for 2-Dimensional Array
#2
Solved: 10 Years, 9 Months, 3 Weeks ago
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
Reply


Messages In This Thread
RE: Parameterize Excel Columns for 2-Dimensional Array - by sshukla12 - 06-20-2012, 10:31 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Identify and Count the columns in the datatable Bhuvana 0 833 12-20-2019, 11:15 PM
Last Post: Bhuvana
  How To Capture Array Value into Excel Worksheet? Studymode 0 1,317 01-09-2018, 08:37 AM
Last Post: Studymode
  parameterize Excel Sheet Name in SQL bjitsidhu 0 2,743 07-20-2014, 08:34 AM
Last Post: bjitsidhu
  Comparing two excel Sheets whose columns names vary Divya Roopa 2 8,310 03-26-2014, 07:20 PM
Last Post: Parke
  sort two dimensional array. venkatesh9032 0 1,751 03-06-2014, 02:47 PM
Last Post: venkatesh9032

Forum Jump:


Users browsing this thread: 1 Guest(s)