从转发器导出excel [英] Exporting excel from repeater

问题描述

嗨

任何人都可以帮助我在Excel工作表中导出我的数据，我在显示数据中使用转发器控件..

以下代码使用..

Hi
Can anybody help to export my data in excel sheet, I m using repeater control in show data ..
below the code i m using ..

Response.Clear();
           Response.Buffer = true;
           Response.AddHeader("content-disposition", "attachment;filename=RepeaterExport.xls");
           Response.Charset = "";
           Response.ContentType = "application/vnd.ms-excel";
           System.IO.StringWriter stringWrite = new System.IO.StringWriter();
           System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
           Rep_code.RenderControl(htmlWrite);
            Response.Write("<table>");
           Response.Write(stringWrite.ToString());
           Response.Write("</table>");
           Response.End();

上面的代码是严格的报告，但这并没有提供所需的格式。

the above code is exacting report but this is not giving in desired format.

推荐答案

这篇关于从转发器导出excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！