DataTable导出到excel word
来源:互联网 发布:oracle性能监控和优化 编辑:程序博客网 时间:2024/05/16 02:06
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
public partial class _Default : System.Web.UI.Page
...{
private DataTable dt;
protected void Page_Load(object sender, EventArgs e)
...{
if (!IsPostBack)
BindGrid();
}
private void InitDataTable()
...{
dt = new DataTable();
dt.Columns.Add(new DataColumn("id", Type.GetType("System.Int32")));
dt.Columns.Add(new DataColumn("name",Type.GetType("System.String")));
for (int i = 1; i <= 20; i++)
...{
DataRow dr = dt.NewRow();
dr[0] = i;
dr[1] = "姓名" + i.ToString();
dt.Rows.Add(dr);
}
}
private void BindGrid()
...{
InitDataTable();
GridView1.DataSource = dt;
GridView1.DataBind();
}
private void OutFile(FileName filename,FileType filetype)
...{
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile." + filename);
Response.ContentType = "application/ms-" + filetype;
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
BindGrid();
DataGrid g = new DataGrid();
g.DataSource = dt;
g.DataBind();
g.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
enum FileName ...{ xls, doc };
enum FileType ...{ excel, word };
protected void but_Command(object sender, CommandEventArgs e)
...{
if(e.CommandName=="excel")
OutFile(FileName.xls, FileType.excel);
else if(e.CommandName=="word")
OutFile(FileName.doc, FileType.word);
}
}
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
public partial class _Default : System.Web.UI.Page
...{
private DataTable dt;
protected void Page_Load(object sender, EventArgs e)
...{
if (!IsPostBack)
BindGrid();
}
private void InitDataTable()
...{
dt = new DataTable();
dt.Columns.Add(new DataColumn("id", Type.GetType("System.Int32")));
dt.Columns.Add(new DataColumn("name",Type.GetType("System.String")));
for (int i = 1; i <= 20; i++)
...{
DataRow dr = dt.NewRow();
dr[0] = i;
dr[1] = "姓名" + i.ToString();
dt.Rows.Add(dr);
}
}
private void BindGrid()
...{
InitDataTable();
GridView1.DataSource = dt;
GridView1.DataBind();
}
private void OutFile(FileName filename,FileType filetype)
...{
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile." + filename);
Response.ContentType = "application/ms-" + filetype;
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
BindGrid();
DataGrid g = new DataGrid();
g.DataSource = dt;
g.DataBind();
g.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
enum FileName ...{ xls, doc };
enum FileType ...{ excel, word };
protected void but_Command(object sender, CommandEventArgs e)
...{
if(e.CommandName=="excel")
OutFile(FileName.xls, FileType.excel);
else if(e.CommandName=="word")
OutFile(FileName.doc, FileType.word);
}
}
<%...@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" EnableEventValidation="false" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
Width="509px">
<Columns>
<asp:CommandField ShowSelectButton="True" />
</Columns>
</asp:GridView>
<asp:Button ID="btnExcel" runat="server" CommandName="excel"
Text="导出到Excel" OnCommand="but_Command" />
<asp:Button ID="btnWord" runat="server" CommandName="word" OnCommand="but_Command"
Text="导出到Word" />
</div>
</form>
</body>
</html>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
Width="509px">
<Columns>
<asp:CommandField ShowSelectButton="True" />
</Columns>
</asp:GridView>
<asp:Button ID="btnExcel" runat="server" CommandName="excel"
Text="导出到Excel" OnCommand="but_Command" />
<asp:Button ID="btnWord" runat="server" CommandName="word" OnCommand="but_Command"
Text="导出到Word" />
</div>
</form>
</body>
</html>
- DataTable导出到excel word
- DataTable导出到word或excel
- Datatable 导出到Excel
- DataTable导出到Excel
- DataTable导出到Excel
- datatable导出到excel文件
- 将DataTable导出到Excel
- datatable导出到excel文件
- GridView DataTable 导出到Excel
- DataTable导出到Excel数据
- 将DataTable 导出到Excel
- DataTable 导出到EXCEL代码
- DataTable数据导出到EXCEL
- 把DataTable导出到Excel
- NPOI导出DataTable到Excel
- winform 导出datatable 到excel
- wpf 导出Datatable 到excel
- DataTable导出到Excel、GSV
- HTML快速入门4——表格入门
- C# 泛型简介
- C#经典面试试题
- 如何使用 Visual C# 创建线程
- HTML快速入门5——不规则表格、表格背景、边框颜色
- DataTable导出到excel word
- C#.Net的常见面试试题
- eclipse3.21及中文包下载 安装中文包的方法
- C#.Net的常见面试试题
- Excel操作的总结
- HTML快速入门6——连接
- jdbc连接sybase时出错
- HTML快速入门7——URL详解、图片使用
- SOA--让业务能够快速地响应或领导变化,即业务敏捷性