(一) . 运行示例图
1. 待导出数据的GridView图:
2. 生成的Excel文件
(二). 代码
1. 前台页面 GridViewToExcelFile.aspx 代码:
1
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
<%@ Page Language="C#" AutoEventWireup="true"
EnableEventValidation="false" CodeFile="GridViewToExcelFile.aspx.cs" Inherits="_Default" %>
2
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
3
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
5
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
<html xmlns="http://www.w3.org/1999/xhtml" >
6
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
<head runat="server">
7
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
<title>Untitled Page</title>
8
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
</head>
9
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
<body>
10
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
<form id="form1" runat="server">
11
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
<div>
12
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
<asp:GridView ID="gvFoods" runat="server" BackColor="LightGoldenrodYellow" BorderColor="Tan" BorderWidth="1px" CellPadding="2" ForeColor="Black" GridLines="None" EnableViewState="true">
13
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
<FooterStyle BackColor="Tan" />
14
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
<SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
15
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
<PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" HorizontalAlign="Center" />
16
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
<HeaderStyle BackColor="Tan" Font-Bold="True" />
17
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
<AlternatingRowStyle BackColor="PaleGoldenrod" />
18
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
</asp:GridView>
19
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
<br />
20
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
<asp:Button ID="Button1" runat="server" BackColor="#C0C0FF" OnClick="Button1_Click"
21
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
Text="Create Excel" Width="137px" />
22
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
</div>
23
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
</form>
24
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
</body>
25
![](http://www.pushad.com/PicFile/2006-8/28/200682811925264.gif)
</html>
2. 页面后台文件 GridViewToExcelFile.aspx.cs 代码:
(三). 示例代码下载