Untitled
By: a guest | Feb 9th, 2010 | Syntax:
VB.NET | Size: 0.39 KB | Hits: 37 | Expires: Never
For Each dc In worksheet1.Columns
colIndex = colIndex + 1
wSheet.Cells(1, colIndex) = dc.ColumnName
Next
For y =0 to worksheet1.Rows.count -1
For x 0 to In worksheet1.Columns-1
wSheet.Cells(rowIndex + 1, colIndex) = dr(x)
Next
Next