如何把一页面导出成一个文件(doc,excel,pdf的都可以)

[sportdog]

我现在根据数据库里的数据显示出一页面(a.aspx),这页面有些文字描述及图片之类的东西,现在想在页面上加一导出按钮,把页面上显示的东西存成一文件(到时就把这文件发给用户就可以了).


有谁能帮帮我?

[wanggang668]

我也想知道

[sunnystar365]

我这段代码是把DataGrid里的数据导成Excel，希望对你的页面导出也有帮助
Response.Clear();
Response.Buffer= true;
Response.Charset="GB2312";
Response.AppendHeader("Content-Disposition","attachment;filename=FileName.xls");
Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");
//设置输出流为简体中文
Response.ContentType = "application/ms-excel";
//设置输出文件类型为excel文件。
this.EnableViewState = false;
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN",true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
this.dgData.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();

[hchxxzx]

看看这段代码,参考

string _strfile;

System.IO.StringWriter uread = null;
System.Web.HttpResponse uresp = null;
System.Web.UI.HtmlTextWriter usend = null;

_strfile = "excel.XLS";

uresp = this.Page.Response;
uresp.Clear();
uresp.Buffer = true;
uresp.AppendHeader("Content-Disposition", "attachment;");
uresp.ContentType = "application/vnd.ms-excel";
this.Page.EnableViewState = false;
uresp.Charset = "";
uresp.ContentEncoding = System.Text.Encoding.UTF8;

uread = new System.IO.StringWriter();
usend = new System.Web.UI.HtmlTextWriter(uread);
this.DataGrid1.RenderControl(usend);

uresp.Write(uread.ToString());
uresp.End();

uread.Close();
usend.Close();
uread = null;
usend = null;
uresp = null;

[aioria]

可以使用Excel的iqy导出功能，如下：

string strFileName,strURL;

strURL = "http://www.testsite.com";
strFileName = "export.iqy";

//打开一个文件进行写入内容
StreamWriter sw;
sw=File.CreateText(Server.MapPath(strFileName));
sw.WriteLine("WEB");
sw.WriteLine("1");
sw.WriteLine(strURL);
sw.WriteLine("Selection=AllTables");
sw.WriteLine("Formatting=All");
sw.WriteLine("PreFormattedTextToColumns=True");
sw.WriteLine("ConsecutiveDelimitersAsOne=True");
sw.WriteLine("SingleBlockTextImport=False");
sw.WriteLine("DisableDateRecognition=False");
sw.WriteLine("DisableRedirections=False");
sw.Close();

Response.Redirect(strFileName);

[goody9807]

你可以dataset 导入 excel参考
http://community.csdn.net/Expert/topic/3077/3077526.xml?temp=.8746912
http://www.dev-club.com/club/bbs/showEssence.asp?id=26350

http://dev.csdn.net/Develop/article/18/18623.shtm
http://community.csdn.net/Expert/topic/3112/3112296.xml?temp=.926861
http://dotnet.aspx.cc/ShowDetail.aspx?id=BF0A54F9-C7C7-4200-BD9A-802AC1F5DE50


http://expert.csdn.net/Expert/TopicView1.asp?id=2928057

www.foxhis.com/powermjtest/
原文代码：




private void Button1_Click(object sender, System.EventArgs e)
{
//写入Excel的方法：
//定义需要参数。
string SourceFile="Data.XLS"; //源文件名称。
string TemplatePath=Server.MapPath("ExcelTemplate"); //存放源文件的文件夹路径。
string DownloadPath=Server.MapPath("ExcelDownload"); //副本的文件夹路径。
//副本的文件名。
string TempFileName = DateTime.Now.ToString("yyyyMMdd") + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + ".XLS";
object missing = System.Reflection.Missing.Value;
Excel.Application myExcel=new Excel.Application();
//打开新文件
myExcel.Application.Workbooks.Open(TemplatePath+"\\"+SourceFile,missing,missing,missing,missing,
missing,missing,missing,missing,missing,missing, missing,missing);
Excel.Workbook myBook=myExcel.Workbooks[1];
Excel.Worksheet curSheet = (Excel.Worksheet)myBook.Sheets[2];

string DownloadFilePath=DownloadPath+"\\"+TempFileName;

int i=0;
while (i<=10)
{
myExcel.Cells[4+i,2]=i.ToString();
myExcel.Cells[4+i,3]=i.ToString();
myExcel.Cells[4+i,4]=i.ToString();
myExcel.Cells[4+i,5]=i.ToString();
myExcel.Cells[4+i,6]=i.ToString();
i++;
}

myBook.Saved=true;
//myBook.SaveAs(DownloadFilePath,missing,"","",false,false,Excel.XlSaveAsAccessMode.xlNoChange,1,false,missing,missing);

myBook.PrintPreview(0);
//myBook.PrintOut(missing,missing,missing,missing,missing,missing,missing,missing);
myBook.Close(false, null,null);
myExcel.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(myBook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(myExcel);
myBook = null;
myExcel = null;
GC.Collect();
//Response.Redirect("ExcelDownload//"+TempFileName); //下载文件
}

[leonkim]

可不可以用Javascript调用IE的菜单->另存为

[leonkim]

<a href="#" onclick=document.execCommand("saveAs")>另存为</a>

[weddingin2008]

踩一脚，我参与的问题。

[sportdog]

<input onclick=document.all.WebBrowser.ExecWB(4,1) type=button value=另存为 name=Button2 ID="Button2">

各位老大，
document.all.WebBrowser.ExecWB(4,1)就和ie的另存一样，如何让用户保存的是单一文件呢?
也就是你点击另存时叫你选的保存类型一定要为.mht的,我该传啥如何写呢?

[owenbeckham]

Response.Clear();
Response.Buffer= true;
Response.Charset="GB2312";
Response.AppendHeader("Content-Disposition","attachment;filename=FileName.xls");
Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");
//设置输出流为简体中文
Response.ContentType = "application/ms-excel";
//设置输出文件类型为excel文件。
this.EnableViewState = false;
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN",true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
this.dgData.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();

[sportdog]

大家别把问题搞复杂了，我只是想把当前页面另存为**.mht的文件就可以了,ie自带的WebBrowser不知能解决该问题吗?

[hchxxzx]

大家别把问题搞复杂了，我只是想把当前页面另存为**.mht的文件就可以了,ie自带的WebBrowser不知能解决该问题吗?
---------------------
IE里面,"文件"-"另存为"-选择"mht",保存即可.

[zyq2099]

学习