Asp.net 2.0 GridView数据导出Excel文件(示例代码下载)-白红宇的个人博客

Asp.net 2.0 GridView数据导出Excel文件(示例代码下载)

发布日期：2022-02-19 23:50:21 浏览次数：47 分类：技术文章

本文共 4326 字，大约阅读时间需要 14 分钟。

(一) . 运行示例图

1. 待导出数据的GridView图:

2. 生成的Excel文件

(二). 代码

1. 前台页面 GridViewToExcelFile.aspx 代码:

1<%@ Page Language="C#" AutoEventWireup="true" EnableEventValidation="false" CodeFile="GridViewToExcelFile.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Untitled Page</title>

</head>

<body>

<div>

<asp:GridView ID="gvFoods" runat="server" BackColor="LightGoldenrodYellow" BorderColor="Tan" BorderWidth="1px" CellPadding="2" ForeColor="Black" GridLines="None" EnableViewState="true">

</asp:GridView>

<br />

<asp:Button ID="Button1" runat="server" BackColor="#C0C0FF" OnClick="Button1_Click"

Text="Create Excel" Width="137px" />

</div>

</form>

</body>

</html>

2. 页面后台文件 GridViewToExcelFile.aspx.cs 代码:

1 using System;

2 using System.Data;

3 using System.Configuration;

4 using System.Web;

5 using System.Web.Security;

6 using System.Web.UI;

7 using System.Web.UI.WebControls;

8 using System.Web.UI.WebControls.WebParts;

9 using System.Web.UI.HtmlControls;

10 using System.IO;

11 using System.Text;

12 using System.Collections;

14 public partial class _Default : System.Web.UI.Page

15 {

16 protected void Page_Load(object sender, EventArgs e)

17 {

18 if(!Page.IsPostBack)

19 {

20 CreateStructure();

21 this.gvFoods.DataSource = this.CreateData();

22 this.gvFoods.DataBind();

23 }

24 }

25 private DataTable CreateStructure()

26 {

27 DataTable dt = new DataTable();

28 dt.Columns.Add(new DataColumn("CategoryID", typeof(int)));

29 dt.Columns.Add(new DataColumn("CategoryName", typeof(string)));

30 dt.Columns.Add(new DataColumn("Price", typeof(int)));

31 return dt;

32 }

33 public DataSet CreateData()

34 {

35 DataSet ds = new DataSet();

36 DataTable dt = this.CreateStructure();

38 DataRow drNew = dt.NewRow();

39 drNew = dt.NewRow();

40 drNew["CategoryID"] = 1;

41 drNew["CategoryName"] = "Apple";

42 drNew["Price"] = 2;

43 dt.Rows.Add(drNew);

45 drNew = dt.NewRow();

46 drNew["CategoryID"] = 2;

47 drNew["CategoryName"] = "Banana";

48 drNew["Price"] = 3;

49 dt.Rows.Add(drNew);

51 drNew = dt.NewRow();

52 drNew["CategoryID"] = 3;

53 drNew["CategoryName"] = "Orange";

54 drNew["Price"] = 1;

55 dt.Rows.Add(drNew);

57 drNew = dt.NewRow();

58 drNew["CategoryID"] = 4;

59 drNew["CategoryName"] = "Radish";

60 drNew["Price"] = 2;

61 dt.Rows.Add(drNew);

63 drNew = dt.NewRow();

64 drNew["CategoryID"] = 5;

65 drNew["CategoryName"] = "Pen";

66 drNew["Price"] = 3;

67 dt.Rows.Add(drNew);

69 drNew = dt.NewRow();

70 drNew["CategoryID"] = 6;

71 drNew["CategoryName"] = "Pencil";

72 drNew["Price"] = 7;

73 dt.Rows.Add(drNew);

75 drNew = dt.NewRow();

76 drNew["CategoryID"] = 7;

77 drNew["CategoryName"] = "Ruler";

78 drNew["Price"] = 3;

79 dt.Rows.Add(drNew);

81 drNew = dt.NewRow();

82 drNew["CategoryID"] = 8;

83 drNew["CategoryName"] = "Eraser";

84 drNew["Price"] = 5;

85 dt.Rows.Add(drNew);

87 ds.Tables.Add( dt );

88 return ds;

89 }

90 protected void Button1_Click(object sender, EventArgs e)

91 {

92 StringWriter sw = new StringWriter();

93 HtmlTextWriter htw = new HtmlTextWriter(sw);

94 this.gvFoods.RenderControl(htw);

95 string strHtml = sw.ToString().Trim();

97 string ExcelFileName = "FoodList.xls";

98 string FilePhysicialPathName = Request.PhysicalApplicationPath;

100 //生成的Excel文件名

101 string objectExcelFileName = Path.Combine(FilePhysicialPathName, ExcelFileName);

102

103 if( File.Exists( objectExcelFileName ))

104 {

105 File.Delete(objectExcelFileName);

106 }

107 FileStream fs = new FileStream(objectExcelFileName, FileMode.Create);

108 BinaryWriter bw = new BinaryWriter(fs, Encoding.GetEncoding("GB18030"));

109 bw.Write(strHtml);

110 bw.Close();

111 fs.Close();

112

113 }

114 public override void VerifyRenderingInServerForm(Control control)

115 {

116 //base.VerifyRenderingInServerForm(control);

117 }

118 }

119

(三). 示例代码下载

转载地址：https://blog.csdn.net/lerrywang008/article/details/1830671 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！

上一篇：什么是mes系统？

下一篇：Asp.net 2.0 用C# 创建 PDF文件[引用] (示例代码下载)

发表评论

关于作者

喝酒易醉，品茶养心，人生如梦，品茶悟道，何以解忧？唯有杜康！

-- 愿君每日到此一游！

发表评论

最新留言

关于作者

推荐文章