Export gridview data to excel 2007 format

Posted by Radhikalingam under ASP.NET on 4/8/2011 | Points: 10 | Views : 7748 | Status : [Member] | Replies : 5
i am not able to to export the data from gridview to excel format 2007. i am getting the below error message.

"Excel cannot open the file .xlsx" because the file format or file extention is not valid."

Can you please provide a solution?




Responses

Posted by: Prabhakar on: 4/8/2011 [Member] [MVP] Starter | Points: 25

Up
0
Down
Hi Radhika . .


chek this link . . it's use full for u . .

http://www.dotnetfunda.com/articles/article1131-export-large-data-from-gridview-to-excel-file-using-csharp-.aspx

Best Regard's
Prabhakar

Radhikalingam, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Radhikalingam on: 4/8/2011 [Member] Starter | Points: 25

Up
0
Down
ThankX for your reply.

I want to export the gridview data to excel 2007 (.xlsx) format.

Radhikalingam, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Radhikalingam on: 4/9/2011 [Member] Starter | Points: 25

Up
0
Down
Can any one please provide solution for exporting data from gridview to excel 2007 (.xlsx) format?

Radhikalingam, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Karthikanbarasan on: 4/11/2011 [Member] [Moderator] [Microsoft_MVP] [MVP] Silver | Points: 25

Up
0
Down
Hi,

By default in which format is it exporting to the excel?

Thanks
Karthik
www.f5Debug.net

Radhikalingam, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Radhikalingam on: 4/12/2011 [Member] Starter | Points: 25

Up
0
Down
i am able to export (.xls) format but not in (.xlsx)

Radhikalingam, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response