Hi Planoie,

What i generally do to export data to excel
1. populate a dataset
2. bind it to datagrid/Repeater/Gridview/Datatable
3. Export it to Excel

Is there any other way to export directly from a dataset so that i can rearrange the columns to display.

Thanks in advance

Given that you are exporting from a web app you aren't going to be able to do very much after you export. (If you were in a desktop app then you could potentially interact with Excel directly.)

However, you can rearrange the dataset columns as you like before you export. I would think that would be the easiest way.

-Peter