如题!谢谢!
解决方案 »
- 多条件情况的存储过程怎么判定。请各位大侠指教一下,急。。。
- 请教各位大虾,看到一些网站里面的链接没有显示完全的URL,是怎么做的,比如 http://help.jiwai.de/MMS,后面的文件扩展名没有显示,麻烦知道的帮小弟解答一下,谢谢
- 如何循序执行button
- 关于ASP.NET中加密的问题
- 我在一个panel中有很多控件,分别绑定到各个字段,那我的数据源应该怎么设置啊??
- 请问如何判断一个字符串内是否包括除0-9外的其它任何字符
- 水晶报表数据刷新问题!!急啊!!!
- 一个关于页面打开的奇怪问题
- 关于VS05自带的treeview的问题
- 在执行update语句时提示无效的 SQL语句;期待 'DELETE'、'INSERT'、'PROCEDURE'、'SELECT'、或 'UPDATE'。
- IIS无法浏览aspx网页,在线等。
- 帮帮忙呀?急。。。
hyperlink链接文件或直接输出
Excel._Workbook book;
Excel._Worksheet sheet;
book = (Excel._Workbook)app.Workbooks.Open(strPath, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
using System;
using System.Collections;
namespace AppFrame
{
/// <summary>
/// 数据导出文件格式
/// </summary>
public class DataExport
{
private string szType = "";
private Hashtable conType = new Hashtable(); public DataExport()
{
conType["xls"] = "application/ms-excel";
conType["doc"] = "application/msword";
conType["pdf"] = "application/pdf";
conType["ppt"] = "application/ms-powerpoint";
conType["zip"] = "application/zip";
conType["rar"] = "application/rar";
conType["gif"] = "image/gif";
conType["jpg"] = "image/jpeg";
conType["png"] = "image/png";
conType["txt"] = "text/plain";
conType["htm"] = "text/html";
conType["xml"] = "text/xml";
} /// <summary>
/// Excel文件格式
/// </summary>
public string xls { get { return "xls"; } }
/// <summary>
/// Word文件格式
/// </summary>
public string doc { get { return "doc"; } }
/// <summary>
/// PDF文件格式
/// </summary>
public string pdf { get { return "pdf"; } }
/// <summary>
/// PowerPoint文件格式
/// </summary>
public string ppt { get { return "ppt"; } }
/// <summary>
/// ZIP压缩文件格式
/// </summary>
public string zip { get { return "zip"; } }
/// <summary>
/// RAR压缩文件格式
/// </summary>
public string rar { get { return "rar"; } }
/// <summary>
/// GIF图形文件格式
/// </summary>
public string gif { get { return "gif"; } }
/// <summary>
/// JPG图形文件格式
/// </summary>
public string jpg { get { return "jpg"; } }
/// <summary>
/// PNG图形文件格式
/// </summary>
public string png { get { return "png"; } }
/// <summary>
/// TEXT文件格式
/// </summary>
public string txt { get { return "txt"; } }
/// <summary>
/// HTM网页超文本格式
/// </summary>
public string htm { get { return "htm"; } }
/// <summary>
/// XML文件格式
/// </summary>
public string xml { get { return "xml"; } } /// <summary>
/// 数据导出文件类型
/// </summary>
public string FileType
{
set { szType = value; }
get { return szType; }
}
/// <summary>
/// 数据流字串索引
/// </summary>
/// <param name="TypeName">导出文件类型</param>
/// <returns>返回导出文件类型的数据流字串</returns>
public string this[string TypeName] { get { return conType[TypeName].ToString(); } } /// <summary>
/// DataGrid数据导出到指定文件 如:Excel、Word
/// </summary>
/// <param name="objPage">Page对象</param>
/// <param name="objGrid">DataGrid对象</param>
public void Export2File(System.Web.UI.Page objPage, System.Web.UI.WebControls.DataGrid objGrid, DataExport de)
{
objPage.Response.Clear();
objPage.Response.Buffer = false;
objPage.Response.Charset = "GB2312";
objPage.Response.AppendHeader("Content-Disposition", string.Format("\"attachment;filename=Export.{0}\"", de.FileType));
objPage.Response.ContentType = de[de.FileType];
objPage.EnableViewState = false;
System.IO.StringWriter objStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter objHtmlTextWriter = new System.Web.UI.HtmlTextWriter(objStringWriter);
objGrid.RenderControl(objHtmlTextWriter);
objPage.Response.Write(objStringWriter.ToString());
objPage.Response.End();
}
}
}在页面调用方式
protected void btnExport_Click(object sender, EventArgs e)
{
if (dgrid.Items.Count == 0) return; //没有数据 DataExport de = new DataExport();
de.FileType = de.xls;
de.Export2File(this, dgrid, de);
}