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; }
@"<style> .textmode { } </style>";
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)