Repeater To Excel (asp.net C#)

Merhaba

Bu yazımızda asp.net nesnesi olan repeater dan excel' e aktarım kodunu paylaşacağım.

Response.Clear();

string filename = "";

filename = "Liste_" + DateTime.Now.ToString() + ".xls";

Response.Buffer = true;

Response.ContentEncoding = System.Text.Encoding.GetEncoding("windows-1254");

Response.Charset = "windows-1254";

Response.AppendHeader("Content-Disposition", "attachment; filename=" + filename + "");

Response.ContentType = "application/vnd.ms-excel";

StringWriter sw = new StringWriter();

HtmlTextWriter hw = new HtmlTextWriter(sw);

rptMusteriler.RenderControl(hw);

Response.Write("<table>"); // Burası çok önemli aksi takdirde TABLE şeklinde aktarım yapar.

Response.Output.Write(sw.ToString());

Response.Write("</table>");

Response.Flush();

Response.End();