Array of Data exported to Excel

[JSMITH242B]

Hi Group,
I have an array of data which I need to export to an Excel Template which I've created.

I cribbed the following routine. On inspecting the values for the parameters they are correct. Data is posted to the excel spreadshett but a record per column and not a record per row. I need to transpose this I think.

I've tried swapping the irow, icol variables around but to no avail.
Does anyone know how I can get an array of data into an Excel template? The columns are fixed but there could be many records.

public sub insertArray(arrData, istartrow, istartcol, irow, icol)
ExcelSheet.Cells(istartrow, istartcol).Resize(irow, (icol + 1)).Value = arrData
end sub

Any pointers?

TIA
Jackie

 

[shaddow]

You have data in array, and you want to add to Excel?

________
George, M

 

[mwolf00]

Jackie -

If you write an HTML table and use XML to write it to an excel spreadsheet, it works very well. The spreadsheet is very easy to format using HTML style. Let me know if you're interested in that path...

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[ggriffit]

check out

http://www.greggriffiths.org/webdev/both/excel/

which covers this.