tags:

views:

163

answers:

2

I want to export data from dataset to Excel using C# in Asp.Net

A: 

This examplecode is done with a gridview to excel but maybe you can go from there:

http://mattberseth.com/downloads/GridViewExportUtil.cs

Johan Leino
+1  A: 

If you can't live with creating a CSV you can do this programiticaly with SpreadsheetGear. Here are some SO questions related to your issue with SpreadsheetGear as a possible solution:

Upload data to datatable

.Net lib for parsing and generating Excel

Control multiple instances of Excel in .Net app

David Robbins