RT,代码如下:            StringWriter sw = new StringWriter();
            HtmlTextWriter hw = new HtmlTextWriter(sw);
            string regexstr = @"<[^>]*>";                string atachment = "attachment;filename=myRepeat.xls"+ HttpUtility.UrlEncode("myRepeater.xls", Encoding.UTF8).ToString();
            Response.Clear();
            Response.Buffer = true;
            Response.AddHeader("content-disposition", atachment);
            Response.ContentType = "application/vnd.ms-excel";
            Response.Charset = "UTF-8";
            Rept_Photo.Page.EnableViewState = true;
            this.Rept_Photo.RenderControl(hw);
            Response.ContentEncoding = Encoding.Default;
            Response.Write(Regex.Replace(sw.ToString(), regexstr, string.Empty, RegexOptions.IgnoreCase));//刚开始这里没有正则,导入后有HTML标签
            Response.Flush();
            Response.End();现在的问题就是导入到excel后里边的列很乱,没有那种一列一列的格式,求解!

解决方案 »

  1.   

    Repeater里面放table作为模板如果不想放,使用GridView超级简单
      

  2.   

    <table>
                <tbody>
                    <asp:Repeater ID="Rept_Photo" runat="server">
                    <HeaderTemplate>
                    <tr>
                        <td>
                            ID
                        </td>
                        <td>
                            名称
                        </td>
                        <td>
                            类别
                        </td>
                    </tr>
                    </HeaderTemplate>
                        <ItemTemplate>
                            <tr>
                                <td>
                                    <%#Eval("PhotoID")%>
                                </td>
                                <td>
                                    <%#Eval("PhotoName")%>
                                </td>
                                <td>
                                    <%#Eval("PhotoClass")%>
                                </td>
                            </tr>
                        </ItemTemplate>
                    </asp:Repeater>
                </tbody>
            </table>
    repeater里边放的是tr,这样子不行吗?
      

  3.   

    Regex.Replace
    你替换没了那
      

  4.   

    但是导入了excel后,没有格式呢,就是只有一列列的数据,但是单元格之间没有边框线、、、
      

  5.   

    弄好了,现在导出当前页没问题,下一步是将一个dataset导出了
      

  6.   

    设置table属性  border=1
    Repeater border=1