读书人

求EXCEL导出,该如何解决

发布时间: 2012-04-09 13:41:25 作者: rapoo

求EXCEL导出
Excel导出,如何让导出的文件自动压缩? 我是用的gridview导出,不存服务器端。

[解决办法]
以Gridview为例,其他类似

C# code
        Response.Clear();        Response.Buffer = true;        Response.Charset = "GB2312";        Response.AppendHeader("Content-Disposition", "attachment;filename=out.xls");        Response.ContentType = "application/ms-excel";        this.EnableViewState = false;        System.IO.StringWriter swOut = new System.IO.StringWriter();        HtmlTextWriter hTw = new HtmlTextWriter(swOut);        GridView1.RenderControl(hTw);        Response.Write(swOut.ToString());        Response.End();
[解决办法]
打开excel赋值给单元格,再使用winrar等压缩输出
string style = @"<style> .text { mso-number-format:\@; } </script> ";
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gv.RenderControl(htw);
Response.Write(style);
Response.Write(sw.ToString());
Response.End();
public override void VerifyRenderingInServerForm(Control control)
{
}

[解决办法]
http://www.csharp360.com/bbs/viewthread.php?tid=142&extra=page%3D1
上面有

读书人网 >asp.net

热点推荐