当前位置:编程学习 > C#/ASP.NET >>

在asp.net中用以下代码导出execl时,如何设置execl的边框?

 private void ExportExcelFromDataGrid( string filename , System.Web.UI.WebControls.DataGrid ToExcelGrid )
        {
            Response.Clear();
            Response.Buffer=   true;     
            Response.Charset="utf-8";           
            Response.AppendHeader("Content-Disposition","attachment;filename="+Server.UrlEncode ( filename ) );     
            Response.ContentEncoding=System.Text.Encoding.Default;//设置输出流为简体中文   
            Response.ContentType   =   "application/ms-excel";//设置输出文件类型为excel文件。     
            this.EnableViewState   =   false;           
            System.Globalization.CultureInfo   myCItrad   =   new   System.Globalization.CultureInfo("ZH-CN",true);   
            System.IO.StringWriter   oStringWriter   =   new   System.IO.StringWriter(myCItrad);     
            System.Web.UI.HtmlTextWriter   oHtmlTextWriter   =   new   System.Web.UI.HtmlTextWriter(oStringWriter);   
            ToExcelGrid.RenderControl(oHtmlTextWriter);     
            Response.Write(oStringWriter.ToString());
            Response.End();
} --------------------编程问答-------------------- 这个不行吧,这个实际导出的是html,不太好控制。

给你推荐个myxls。

http://blog.bossma.cn/csharp/myxls-export-excel-option-list/
补充:.NET技术 ,  ASP.NET
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,