如何将gridview数据导出到Excel 2007和Excel 2003 [英] How to export gridview data to Excel 2007 and Excel 2003

问题描述

大家好......

我已经编写了将gridview数据导出为ex​​cel的代码..

但它在2003年只出口数据，因为我写了以下内容我的代码

Hi Everyone...
I have written the code for exporting gridview data to excel..
But its only exporting data on 2003 because i have written following in my code

Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Customers.xls"));

如果我想在2003年和2007年excel表中导出数据该怎么办..

提前感谢..

what should i do if i want to export data both in 2003 and 2007 excel sheet..
thanks in advance..

推荐答案

请查看此链接，这可能对您有所帮助



将gridview数据导出为ex​​cel 2007格式 [ ^ ]

http://forums.asp.net/t/1221467.aspx [ ^ ]

看下面的解决方案，它们都可以将gridview导出到excel 2007,2003甚至2010：

9将数据导出到Excel for ASP.NET的解决方案 [ ^ ]

通过DataGridView将DataTable导出到Excel [ ^ ]

通过DataGridView将数据导出到Excel，Word，PDF [ ^ ]

将Gridview数据导出到ASP.NET中的Excel [ ^ ]

Look at below solutions, it all can export gridview to excel 2007, 2003 even 2010:
9 Solutions to Export Data to Excel for ASP.NET[^]
Export DataTable to Excel through DataGridView[^]
Export Data to Excel, Word, PDF Through DataGridView[^]
Export Gridview Data to Excel in ASP.NET[^]

请点击链接



导出Gridview ASP.NET中的Excel数据 [ ^ ]

谢谢

Please follow the link

Export Gridview Data to Excel in ASP.NET[^]
Thanks

这篇关于如何将gridview数据导出到Excel 2007和Excel 2003的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！