將控制項中的資料輸出儲存到本地excel或word中,同時儲存圖片到本地(c#)
來源:互聯網
上載者:User
excel|word|控制項|資料 //把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();
}
//以下是儲存圖片
public void SavePic()
{
string path = Server.MapPath(".") + @"\images\Chart.jpeg";
FileStream file = File.OpenRead(path);
byte[] content = new byte[file.Length];
file.Read(content,0,content.Length);
file.Close();
Response.Clear();
Response.AppendHeader("Content-Disposition","attachment;filename=Chart.jpeg");
Response.ContentType = "image/jpeg";//設定Http的頭資訊
Response.BinaryWrite(content);//輸出
Response.End();
}
不過圖片儲存完後,頁面上的DropDownList的Select事件不能促發,不曉得是什麼緣故,而頁面上的button事件卻可以激發事件,不知道大家有沒有出現過這種問題?可以討論一下,還是我儲存圖片的過程有問題?