repeater 导出Excel

lanbingyu1028 2011-08-13 03:03:46

repeater 导出Excel ,导出的Excel文件没有边框线怎么办

...全文

125 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

暖枫无敌 2011-08-13

打赏
举报

[Quote=引用 4 楼 lanbingyu1028 的回复:]

引用 3 楼 taomanman 的回复:
C# code

protected void Excel_Click(object sender, EventArgs e)
{
Response.Clear();
//获取或设置一个值，该值指示是否缓冲输出，并在完成处理整个响应之后将其发送
Response.Buffer = true;
……

我就是这么写的,导出的Exc……
[/Quote]
那就对导出过的Excel文件重新加线吧，或是使用下面的这种方法。



<script type="text/javascript">

        //导出Excel   

        function AllAreaExcel(objtableid) {

            var oXL = new ActiveXObject("Excel.Application");

            var oWB = oXL.Workbooks.Add();

            var oSheet = oWB.ActiveSheet;

            var sel = document.body.createTextRange();

            sel.moveToElementText(document.getElementById(objtableid));

            sel.select();

            sel.execCommand("Copy");

            oSheet.Paste();

            oXL.Visible = true;

        }   

</script>



<div>

        <table  id="table">

            <tr>

                  <td>

                       <asp:Repeater ID="rpt" runat="server"></asp:Repeater>

                  </td>

            </tr>

       </table>

</div>

<div style="text-align: left">

            <img src="images/dcexcel.gif" onclick='AllAreaExcel("table");' alt="导出到Execl" style="cursor: hand;" />

</div>

lanbingyu1028 2011-08-13

打赏
举报

[Quote=引用 3 楼 taomanman 的回复:]
C# code

protected void Excel_Click(object sender, EventArgs e)
{
Response.Clear();
//获取或设置一个值，该值指示是否缓冲输出，并在完成处理整个响应之后将其发送
Response.Buffer = true;
……
[/Quote]
我就是这么写的,导出的Excel文件没有边框线......

暖枫无敌 2011-08-13

打赏
举报



protected void Excel_Click(object sender, EventArgs e)

{

            Response.Clear();

            //获取或设置一个值，该值指示是否缓冲输出，并在完成处理整个响应之后将其发送

            Response.Buffer = true;

            //获取或设置输出流的HTTP字符集

            Response.Charset = "GB2312";

            //将HTTP头添加到输出流

            Response.AppendHeader("Content-Disposition", "attachment;filename=PriceManage" + DateTime.Now.Date.ToString("yyyyMMdd") + ".xls");

            //获取或设置输出流的HTTP字符集

            Response.ContentEncoding = System.Text.Encoding.UTF7;

            //获取或设置输出流的HTTP MIME类型

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

            System.IO.StringWriter onstringwriter = new System.IO.StringWriter();

            System.Web.UI.HtmlTextWriter onhtmltextwriter = new System.Web.UI.HtmlTextWriter(onstringwriter);

            StringWriter sw = new StringWriter();

            HtmlTextWriter htw = new HtmlTextWriter(sw);           

            this.Repeater1.RenderControl(htw);

            string html = sw.ToString().Trim();

            Response.Output.Write(html);

            Response.Flush();

            Response.End();      

   }

public override void VerifyRenderingInServerForm(Control control)

 {

            //base.VerifyRenderingInServerForm(control);

}