Export a dataset to an Excel file
- Thread starter karmah
- Start date
There is a quite good article including source code on accessing Excel from .net using VB.net.
http://support.microsoft.com/default.aspx?scid=kb;en-us;301982
Simply move through your dataset and write each value into your sheet.
Nonperformant solution: use two For each-Loops (one for the rows, one for the columns).
Dont know if it would work like that: take column from Dataset put it into column from Excel-sheet. Just try.
Voca
http://support.microsoft.com/default.aspx?scid=kb;en-us;301982
Simply move through your dataset and write each value into your sheet.
Nonperformant solution: use two For each-Loops (one for the rows, one for the columns).
Dont know if it would work like that: take column from Dataset put it into column from Excel-sheet. Just try.
Voca