Question

asp.net怎样将Repeater数据导出到Excel表格里面

如题

Answer 1

首先打开一个excel文件然后将repeater生成的html标签直接写入这个文件

Answer 2

看一下你的指令是这吗?<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication1._Default" EnableEventValidation="false"%>
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
HttpContext.Current.Response.ContentType = "application/ms-excel";
HttpContext.Current.Response.Charset = "GB2312";
HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=Hello.xlsx");
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
Repeater1.RenderControl(htw); //ID的名称:Repeater
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();