A win datagrid is populated by a dataset.
This dataset varies for each population. i.e sometimes 4 fields and sometimes more or less...

I would like to transfer this dataset and populate it into excel sheet.
How can a dataset or the data in a datagrid be transfered into excel sheet.

If I was using a DataReader I know how to loop through it and populate the excel sheet but with the Dataset I do not know

Thanks