//把table控件中的数据保存到excel或word
public void Save(System.Web.UI.Control source, DocumentType type) {
Response.Clear();
Response.Buffer= true; //设置Http的头信息,编码格式
if (type == DocumentType.Excel)
{
//Excel
Response.AppendHeader("Content-Disposition","attachment;filename=result.xls");
Response.ContentType = "application/ms-excel";
}
else if (type == DocumentType.Word)
{
//Word
Response.AppendHeader("Content-Disposition","attachment;filename=result.doc");
Response.ContentType = "application/ms-word";
} //设置编码
Response.Charset="GB2312";
Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312"); //关闭控件的视图状态
source.EnableViewState =false; //初始化HtmlWriter
System.IO.StringWriter writer = new System.IO.StringWriter() ;
System.Web.UI.HtmlTextWriter htmlWriter = new System.Web.UI.HtmlTextWriter(writer);
source.RenderControl(htmlWriter); //输出
Response.Write(writer.ToString()); Response.End();
}
这是网络上提供的一个程序,我只是想将数据库中的信息直接输出,不想经过表格等控件这一步,是演了一下直接Response.Write 信息
提示无法进行格式转换,郁闷阿
public void Save(System.Web.UI.Control source, DocumentType type) {
Response.Clear();
Response.Buffer= true; //设置Http的头信息,编码格式
if (type == DocumentType.Excel)
{
//Excel
Response.AppendHeader("Content-Disposition","attachment;filename=result.xls");
Response.ContentType = "application/ms-excel";
}
else if (type == DocumentType.Word)
{
//Word
Response.AppendHeader("Content-Disposition","attachment;filename=result.doc");
Response.ContentType = "application/ms-word";
} //设置编码
Response.Charset="GB2312";
Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312"); //关闭控件的视图状态
source.EnableViewState =false; //初始化HtmlWriter
System.IO.StringWriter writer = new System.IO.StringWriter() ;
System.Web.UI.HtmlTextWriter htmlWriter = new System.Web.UI.HtmlTextWriter(writer);
source.RenderControl(htmlWriter); //输出
Response.Write(writer.ToString()); Response.End();
}
这是网络上提供的一个程序,我只是想将数据库中的信息直接输出,不想经过表格等控件这一步,是演了一下直接Response.Write 信息
提示无法进行格式转换,郁闷阿
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货