Asp.Net Web Form Click option ExportToExcel

Question

Thanks

Bikesh Srivastava · Answer

Hi Whatever you want open that is supportive so try particular format.xls

Midhun T P · Answer

Hi I think you may need to add below line on your Export to excel code - Response.ContentType = application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; Please check below links too - http://stackoverflow.com/questions/16144900/the-file-you-are-trying-to-open-is-in-a-different-format-than-specified-by-the-f http://www.aspsnippets.com/Articles/Solution-ASPNet-GridView-Export-to-Excel-The-file-you-are-trying-to-open-is-in-a-different-format-than-specified-by-the-file-extension.aspx

Venkatesh Lakshmanan · Answer

Hi Execute SQL server query to get data stored in Dataset  then export that dataset values to excel in this case above screen shot issuse acquried.

Nitin Sontakke · Answer

So what your question? It would be difficult for us to guess what exact thing you want to resolve.