gridview数据导出到excel打印
来源:互联网 发布:adobe cc mac 破解 编辑:程序博客网 时间:2024/05/18 03:02
//打印gridview中的数据时需要override掉这个方法,实现部分为空
public override void VerifyRenderingInServerForm(Control control)
{
//注释掉下面的代码,否则在asp.net2.0下会报错(注:GridView是asp.net 2.0下的控件,1.1下一些控件也可以导出成Excel或者Word)
//base.VerifyRenderingInServerForm(control);
}
/// <summary>
/// 打印功能
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnPrint_Click(object sender, EventArgs e)
{
if (gvResult.Rows.Count > 0)//有数据时才导出到Excel
{
#region GridView中的内容导出到Excel里,需要判断是否已安装office
try
{
Response.Clear();
Response.BufferOutput = true;
//设定输出的字符集
Response.Charset = "GB2312";
//假定导出的文件名为excel.xls
Response.AppendHeader("Content-Disposition", "attachment;filename=excel.xls");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
//设置导出文件的格式
Response.ContentType = "application/ms-excel";
//关闭ViewState
EnableViewState = false;
System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo("ZH-CN", true);
System.IO.StringWriter stringWriter = new System.IO.StringWriter(cultureInfo);
System.Web.UI.HtmlTextWriter textWriter = new System.Web.UI.HtmlTextWriter(stringWriter);
gvResult.RenderControl(textWriter);
//把HTML写回浏览器
Response.Write(stringWriter.ToString());
Response.End();
}
catch (Exception ex)
{
JScript.ShowMessage(ex.Message);
}
#endregion
}
else
{
JScript.ShowMessage("无数据可以打印.");
}
}
public override void VerifyRenderingInServerForm(Control control)
{
//注释掉下面的代码,否则在asp.net2.0下会报错(注:GridView是asp.net 2.0下的控件,1.1下一些控件也可以导出成Excel或者Word)
//base.VerifyRenderingInServerForm(control);
}
/// <summary>
/// 打印功能
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnPrint_Click(object sender, EventArgs e)
{
if (gvResult.Rows.Count > 0)//有数据时才导出到Excel
{
#region GridView中的内容导出到Excel里,需要判断是否已安装office
try
{
Response.Clear();
Response.BufferOutput = true;
//设定输出的字符集
Response.Charset = "GB2312";
//假定导出的文件名为excel.xls
Response.AppendHeader("Content-Disposition", "attachment;filename=excel.xls");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
//设置导出文件的格式
Response.ContentType = "application/ms-excel";
//关闭ViewState
EnableViewState = false;
System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo("ZH-CN", true);
System.IO.StringWriter stringWriter = new System.IO.StringWriter(cultureInfo);
System.Web.UI.HtmlTextWriter textWriter = new System.Web.UI.HtmlTextWriter(stringWriter);
gvResult.RenderControl(textWriter);
//把HTML写回浏览器
Response.Write(stringWriter.ToString());
Response.End();
}
catch (Exception ex)
{
JScript.ShowMessage(ex.Message);
}
#endregion
}
else
{
JScript.ShowMessage("无数据可以打印.");
}
}
- gridview数据导出到excel打印
- 实现GridView中的数据的打印和导出到Excel
- 实现GridView中的数据的打印和导出到Excel
- GridView导出数据到Excel
- GridView导出数据到Excel
- GridView导出数据到Excel
- GridView导出数据到Excel
- Gridview导出数据到Excel
- 导出gridview数据到Excel
- gridview导出数据到excel
- 导出GridView数据到Excel
- GridView导出数据到Excel
- GridView导出数据到Excel
- Gridview导出数据到Excel
- GridView导出数据到Excel
- gridView导出数据到Excel...Excel导入数据到GridView
- GridView 导出数据到excel数据乱码
- GridView 导出数据到 EXCEL 失败
- 编译器错误信息: CS0016:未能写入输出文件
- OCCI开发的程序发布
- 曾国藩家书之劝学篇 摘录4
- Net下在线编辑器FCKeditor安装方法
- 切尔诺贝利事故
- gridview数据导出到excel打印
- java String
- 谈VC++对象模型
- 创意图片
- 原创joke又来了
- 初探struts中的(Converter)
- Vista机会尚未破灭 或重走XP发展旧路
- Joomla!国内站点巡礼
- 字符编码笔记:ASCII,Unicode和UTF-8