I am exporting data from a datagrid to excel.Thing is i need excel to automatically create a spreadsheet when i click button export.As in i don't have a ready made spreadsheet to export the data to,so i need the spreadsheet to have the same column headings as the table/grid.
if any1 has sample code to do this plz help