Asp.Net Web Form Click option ExportToExcel

Hi,

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

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

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.

So, what your question?

It would be difficult for us to guess, what exact thing you want to resolve.