VB.Net - Exporting to Excel Variable Number of Columns
Posted on 2013-05-13
Good Day Experts!
Usually, when I build a report from SQL to Excel in VB.Net, I know the column names and I set them in the code.
Now, I have a situation where I need to "Select *..." from a table with over 30 columns.
Aside from setting up an array of Excel column names(A,B,C...AA,AB,AC and so on), is there a way to programataically start with value "A" and keep "retrieving" the next value without getting it from a pre-populated array?