以Zip格式导出，asp.net [英] Export in Zip format,asp.net

问题描述

我想以Zip格式从Excel的Gridview导出数据.我需要完整的代码.


出现错误:

只能在Render()期间调用RegisterForEventValidation；

grd.RenderControl(oHtmlTextWriter);

导出Excel:

ExportToExcel("Report.xls"，grd);

私有void ExportToExcel(字符串strFileName，GridView dg)
{
Response.Clear();
Response.Buffer = true;
Response.ContentType ="application/vnd.ms-excel";
Response.Charset =";
this.EnableViewState = false;
System.IO.StringWriter oStringWriter =新的System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter =新的System.Web.UI.HtmlTextWriter(oStringWriter);
grd.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}

公共重写void VerifyRenderingInServerForm(Control control)
{

}

Hi,
i want to export data from Gridview from Excel in Zip format.I need the complete code.


Getting error:

RegisterForEventValidation can only be called during Render();

grd.RenderControl(oHtmlTextWriter);

Export Excel:

ExportToExcel("Report.xls", grd);

private void ExportToExcel(string strFileName, GridView dg)
{
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
grd.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}

public override void VerifyRenderingInServerForm(Control control)
{

}

推荐答案

只需编写代码即可压缩Excel工作表，然后以与现在相同的方式将其发送给用户，只是使用以下内容类型:

Simply write code to zip the Excel sheet and send it to the user in the same way you do now except use the following content type:

Response.ContentType = "application/zip";

祝你好运！

Good luck!

这篇关于以Zip格式导出，asp.net的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！