asp页面怎么弹出保存和打开Excel文件的对话框?
asp页面如何弹出保存和打开Excel文件的对话框???
我是想在asp页面中单击导出按钮的时候我就可以把Dataset中的数据导出来,然后就可以打开或者保存,求大哥们尽量给代码咯
------解决方案--------------------
参考:
------解决方案--------------------
以流的形式导出,并以附件的形式导出
如1楼代码
Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode(excelName));
------解决方案--------------------
我是想在asp页面中单击导出按钮的时候我就可以把Dataset中的数据导出来,然后就可以打开或者保存,求大哥们尽量给代码咯
------解决方案--------------------
参考:
public void ExportResult(DataTable dt, string excelName)
{
Response.Clear();
Response.Charset = "";
Response.ContentType = "applicationnd.ms-xls";
StringWriter sw = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter(sw);
DataGrid dg = new DataGrid();
dg.DataSource = dt;
dg.DataBind();
dg.RenderControl(htmlWrite);
Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode(excelName));
Response.Write(sw.ToString());
Response.End();
}
------解决方案--------------------
以流的形式导出,并以附件的形式导出
如1楼代码
Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode(excelName));
------解决方案--------------------
/// <summary>
/// 导出Excel
/// </summary>
protected void btn_exl_Click(object sender, EventArgs e)
{
ToExcel();
}
//必须有 不然会出错
public override void VerifyRenderingInServerForm(Control control)
{
}