I have a dataset filling a datagrid and want to export that to Excel Spreadsheet when I push the Expoprt to Excel Button. When I do click the button I do not get the spreadsheet.
Here is my code, what am I doing wrong???
Excel query = new Excel();
Worksheet sheet = query.Worksheets;
DataTable dt = sheet.Cells.ExportDataTable(1,1,35000, 20);
this.dataGrid1.DataSource = dt;