导出到Excel对齐不正确，不显示颜色 [英] Export to excel alignment is not proper and color is not displayed

问题描述

 this is the code that i m using , can anyone explain why the table is not aligned properly when viewed in excel and some colors are also not displayed

protected void Page_Load(object sender, EventArgs e)
        {
            //check if session is valid
           // WebUtility.WebUtility.CheckValidSession(Context, Response, Session);

            tdOnTime2.BackColor = Color.FromName(Valuelist.FirstOrDefault().Color == "Amber" ? "Orange" : Valuelist.FirstOrDefault().Color);
            tdAceeptableDelay2.BackColor = Color.FromName(Valuelist.Skip(1).FirstOrDefault().Color == "Amber" ? "Orange" : Valuelist.Skip(1).FirstOrDefault().Color);
            tdDelayed2.BackColor = Color.FromName(Valuelist.LastOrDefault().Color == "Amber" ? "Orange" : Valuelist.LastOrDefault().Color);

            tdOnTime.BackColor = Color.FromName(Valuelist.FirstOrDefault().Color == "Amber" ? "Orange" : Valuelist.FirstOrDefault().Color);
            tdAceeptableDelay.BackColor = Color.FromName(Valuelist.Skip(1).FirstOrDefault().Color == "Amber" ? "Orange" : Valuelist.Skip(1).FirstOrDefault().Color);
            tdDelayed.BackColor = Color.FromName(Valuelist.LastOrDefault().Color == "Amber" ? "Orange" : Valuelist.LastOrDefault().Color);
            //get CP from querystring
            int CPID ;
            int.TryParse(Request.QueryString.Get("CPID"), out CPID);
            this.ucComplianceReportForCP.CPID = CPID;
            this.ucComplianceReportForCP.DisplayComplianceForCP();
        }
        protected void btnExportToExcel_Click(object sender, EventArgs e)
        {
            Response.Clear();
            Response.Buffer = true;
            Response.AddHeader("content-disposition", "attachment;filename=ComplianceReport.xls");
            Response.Charset = "";
            Response.ContentType = "application/vnd.ms-excel";
            StringWriter sw = new StringWriter();
            HtmlTextWriter hw = new HtmlTextWriter(sw);
          //  rptCustomers.RenderControl(hw);
            
           // this.ltExcelCPtitle.Visible = true;
            pnlComplianceData.RenderControl(hw);
            Response.Output.Write(sw.ToString());
            Response.Flush();
            Response.End();
           // ltExcelCPtitle.Visible = false;
        }

我尝试了什么：



i不是没有导致此问题的原因..

What I have tried:

i don't no what is causing this issue..

推荐答案

当您将gridview导出为ex​​cel时，您将其写为'HtmlTextWriter'并且它只写纯文本而不是富文本文本，如果要将gridview导出为具有所有样式和格式的excel，则需要使用样式标签

When you are export your gridview to excel then you are writing it as 'HtmlTextWriter' and it write only plain text not with rich text, if you want to export your gridview to excel with all style and formatting then you need to use style tags

@"<style> .textmode { } </style>";

见以下链接获取更多帮助

使用C＃和VB.Net格式化将ASPView中的GridView导出到Excel中[ ^ ]

这篇关于导出到Excel对齐不正确，不显示颜色的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！