怎么把DataGrid数据导出到word

fhuibo 2008-05-26 08:48:46

怎么把DataGrid数据导出到word
Datagrid数据如下：
部门计划是否完成
人力资源部方法完成
人力资源部试试未完成
财务部中国完成
财务部历史完成
财务部事实上未完成

我要导出到WORD里如下：

...全文

216 15 打赏收藏转发到动态举报

写回复

用AI写文章

15 条回复

切换为时间正序

请发表友善的回复…

发表回复

yeweimp3 2011-03-17

打赏
举报

wrqwrqwrqwrq

live_7sky 2008-06-10

打赏
举报

后台代码：

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace managemis.ExcelTemplate
{

public class excel_col_acc : System.Web.UI.Page
{
public string retstr="";
private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
{
Bind();
}
}

#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion
private void Bind()
{
if(Session["Table"]!=null)
{
DataView dv=(DataView)Session["Table"];
for(int i=0;i<dv.Count;i++)
{
retstr+=" <tr height=\"37\" style='HEIGHT:27.75pt;mso-height-source:userset'>"+
"<td height=\"37\" class=\"xl24\" width=\"145\">"+dv[i][0].ToString()+
"</td>"+
"<td class=\"xl24\" width=\"144\">"+dv[i][1].ToString()+
"</td>"+
"<td class=\"xl24\" width=\"144\">"+dv[i][2].ToString()+
"</td>"+
"<td class=\"xl24\" width=\"144\">"+dv[i][3].ToString()+
"</td>"+
"<td class=\"xl24\" width=\"144\">"+dv[i][4].ToString()+
"</td>"+
"</tr>";
}
}

}
}
}

live_7sky 2008-06-10

打赏
举报

HTML 代码：

<%@ Page language="c#" Codebehind="excel_col_acc.aspx.cs" AutoEventWireup="false" Inherits="managemis.ExcelTemplate.excel_col_acc" %>
<HTML xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel">
<HEAD>
<%Response.AddHeader("Content-Disposition", "attachment; filename="+HttpUtility.UrlEncode("设备档案.xls"));%>
<%Response.ContentType="application/vnd.ms-excel";%>
<%Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");%>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta content="Excel.Sheet" name="ProgId">
<meta content="Microsoft Excel 11" name="Generator">
<LINK href="Book2.files/filelist.xml" rel="File-List">
<LINK href="Book2.files/editdata.mso" rel="Edit-Time-Data">
<LINK href="Book2.files/oledata.mso" rel="OLE-Object-Data"> 
<style> </style>

</HEAD>
<body vLink="purple" link="blue">
<![if supportMisalignedColumns]>
<tr height="0" style='display:none'>
<td width="145" style='width:109pt'></td>
<td width="144" style='width:108pt'></td>
<td width="144" style='width:108pt'></td>
<td width="144" style='width:108pt'></td>
<td width="144" style='width:108pt'></td>
<td width="144" style='width:108pt'></td>
<td width="144" style='width:108pt'></td>
<td width="145" style='width:109pt'></td>
</tr>
<![endif]>
<table style="TABLE-LAYOUT: fixed; BORDER-COLLAPSE: collapse" height="74" cellSpacing="0"
cellPadding="0" width="784" border="0" x:str>
<COLGROUP>
<col style="WIDTH: 109pt; mso-width-source: userset; mso-width-alt: 4640" width="145">
<col style="WIDTH: 108pt; mso-width-source: userset; mso-width-alt: 4608" span="2" width="144">
<col style="WIDTH: 109pt; mso-width-source: userset; mso-width-alt: 4640" width="145">
<tr style="HEIGHT: 27.75pt; mso-height-source: userset" height="37">
<td class="xl25" width="1011" colSpan="5" height="37">设备档案
</td>
</tr>
<tr style="HEIGHT: 27.75pt; mso-height-source: userset" height="37">
<td class="xl28" width="144" height="36">设备名称</td>
<td class="xl28" width="144" height="36">规格型号</td>
<td class="xl28" width="144" height="36">性能特点</td>
<td class="xl28" width="144" height="36">设备类别</td>
<td class="xl28" width="144" height="36">所属系统</td>
</tr>
<%=retstr%>
</table>
</body>
</HTML>

live_7sky 2008-06-10

打赏
举报

1, 新建一个 word, 画好格式之后，保存为 HTML，然后复制 HTML 的源代码到你的网页里面去，在需要绑定的地方使用

<%=变量%> ,后台给前台的 HTML 传值。

下面是一个使用EXCEL 的例子：

w1122333 2008-06-05

打赏
举报

顶下

czk598478 2008-06-05

打赏
举报

帮你顶

live_7sky 2008-06-05

打赏
举报

[Quote=引用 7 楼 wuhaiwuya 的回复:]
你可以这样做用word建一个模板这个模板给你的程序(datagrid)有相同的表格然后你一行行的写入到你的模板就可以我之前实现过这样
[/Quote]

哈哈，我也这样实现过，

WORD 就是 HTML

deepinnet 2008-05-27

打赏
举报

fhuibo 2008-05-26

打赏
举报

各位大哥，我要的WORD是要带表格的！！！

优途科技 2008-05-26

打赏
举报



private void ExportToWord_Click(object sender, System.EventArgs e)

{

 Response.Clear();

 Response.AddHeader("content-disposition", "attachment;filename=FileName.doc");

 Response.Charset = "";

 Response.Cache.SetCacheability(HttpCacheability.NoCache);

 Response.ContentType = "application/vnd.word";

 System.IO.StringWriter stringWrite = new System.IO.StringWriter();

 System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

 dgDevice.RenderControl(htmlWrite);

 Response.Write(stringWrite.ToString());

 Response.End();

}

试一下吧，也许可以实现你的功能。

yagebu1983 2008-05-26

打赏
举报

网上例子很多的！！
去搜搜！！

lfywy 2008-05-26

打赏
举报



private void ExportToWord_Click(object sender, System.EventArgs e)

{

 Response.Clear();

 Response.AddHeader("content-disposition", "attachment;filename=FileName.doc");

 Response.Charset = "";

 Response.Cache.SetCacheability(HttpCacheability.NoCache);

 Response.ContentType = "application/vnd.word";

 System.IO.StringWriter stringWrite = new System.IO.StringWriter();

 System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

 dgDevice.RenderControl(htmlWrite);

 Response.Write(stringWrite.ToString());

 Response.End();

}

net0003 2008-05-26

打赏
举报

ding

顶

czhy 2008-05-26

打赏
举报

/// <summary>
/// 导出Excel文件
/// </summary>
/// <param name="ControlId">要导出控件的Id</param>
/// <param name="Response">Page页的Response对象</param>
/// <param name="FileName">要导出的文件名</param>
public static void ResponseExcel(Control ControlId, HttpResponse Response, string FileName)
{
Response.Clear();
Response.ContentType = "application/vnd.ms-excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
Response.AddHeader("Content-Disposition", "inline;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8) + ".xls");
System.Text.StringBuilder sb = new System.Text.StringBuilder();
System.IO.StringWriter sw = new System.IO.StringWriter(sb);
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
sb.Append("<html><head>");
sb.Append("<meta http-equiv=Content-Type content=text/html;charset=UTF-8>");
sb.Append("</head><body>");
ControlId.RenderControl(hw);
sb.Append("</body></html>");
Response.Write(sb.ToString());
Response.End();
}
/// <summary>
/// 导出Word文件
/// </summary>
/// <param name="ControlId">要导出控件的Id</param>
/// <param name="Response">Page页的Response对象</param>
/// <param name="FileName">要导出的文件名</param>
public static void ResponseWord(Control ControlId, HttpResponse Response, string FileName)
{
Response.Clear();
Response.ContentType = "application/ms-word";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
Response.AddHeader("Content-Disposition", "inline;filename=" + HttpUtility.UrlEncode(FileName+".doc", Encoding.UTF8));
System.Text.StringBuilder sb = new System.Text.StringBuilder();
System.IO.StringWriter sw = new System.IO.StringWriter(sb);
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
sb.Append("<html><head>");
sb.Append("<meta http-equiv=Content-Type content=text/html;charset=UTF-8>");
sb.Append("</head><body>");
ControlId.RenderControl(hw);
sb.Append("</body></html>");
Response.Write(sb.ToString());
Response.End();
}

wuhaiwuya 2008-05-26