Repeater绑定数据导出到EXCEL，不能是HTML格式
Repeater绑定数据导出到EXCEL，不能是HTML格式，导入到EXCEL中的内容能够编辑，有代码更好，谢谢
[解决办法]
导入代码

public static DataSet LoadDataFromExcel(string filePath)
    {
        try
        {
            string strConn;
            strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'";
            OleDbConnection OleConn = new OleDbConnection(strConn);
            OleConn.Open(); String sql = "SELECT * FROM    [Sheet1$]";//可是更改Sheet名称，比如sheet2，等等  
            OleDbDataAdapter OleDaExcel = new OleDbDataAdapter(sql, OleConn);
            DataSet OleDsExcle = new DataSet();
            OleDaExcel.Fill(OleDsExcle, "Sheet1");
            OleConn.Close();
            return OleDsExcle;
        }
        catch (Exception err)
        {
            return null;
        }
    }

导出代码


StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
string attachment = "attachment; filename=myReport.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/octet-stream";
repMessage.RenderControl(htw);
Response.Write(sw.ToString());
Response.Flush();
Response.End();