Export with Style sheet from Datatable to excel

[Biju Sam]

I have a dataview which when exported into excel shows in very small font. i want to apply style sheet before i export. How do i do it? Kindly help. Thanks & Regards Biju S

[Venkatesh Mookkan]

Just the include your style inside a <STYLE> tag and append it with HTML String which you use to import as excel.

Regards, Venkatesh Mookkan. Software Engineer, India My: Website | Yahoo Group | Blog Spot

[Biju Sam]

Thank you venkatesh. can you suggest me some sample code? i tried giving style but didnt work out

[Venkatesh Mookkan]

Post your code where you export it. I will update the code.

Regards, Venkatesh Mookkan. Software Engineer, India My: Website | Yahoo Group | Blog Spot

[Biju Sam]

here is my code. Response.Clear(); gvCycleRpt.Columns[8].Visible = false; string style = @" .text { mso-number-format:\@; } "; Response.AddHeader("content-disposition", "attachment;filename=CycleReport.xls"); Response.Charset = ""; Response.ContentType = "application/vnd.xls"; StringWriter StringWriter = new System.IO.StringWriter(); HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter); gvCycleRpt.RenderControl(HtmlTextWriter); // Style is added dynamically Response.Write(style); Response.Write(StringWriter.ToString()); Response.End(); gvCycleRpt.Columns[8].Visible = true; Thanks & regards Biju S

[Venkatesh Mookkan]

itsbijusamuel wrote:

Response.Clear(); gvCycleRpt.Columns[8].Visible = false; string style = @" .text { mso-number-format:\@; } "; Response.AddHeader("content-disposition", "attachment;filename=CycleReport.xls"); Response.Charset = ""; Response.ContentType = "application/vnd.xls"; StringWriter StringWriter = new System.IO.StringWriter(); HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter); gvCycleRpt.RenderControl(HtmlTextWriter); // Style is added dynamically Response.Write(style); Response.Write(StringWriter.ToString()); Response.End(); gvCycleRpt.Columns[8].Visible = true;

Response.Clear(); gvCycleRpt.Columns[8].Visible = false; string style = @" .text { mso-number-format:\@; } "; Response.AddHeader("content-disposition", "attachment;filename=CycleReport.xls"); Response.Charset = ""; Response.ContentType = "application/vnd.xls"; StringWriter StringWriter = new System.IO.StringWriter(); HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter); gvCycleRpt.RenderControl(HtmlTextWriter); // Style is added dynamically StringBuilder sb = new StringBuilder(); sb.Append(style); sb.Append(StringWriter.ToString()); Response.Write(sb.ToString()); Response.End(); gvCycleRpt.Columns[8].Visible = true;

Regards, Venkatesh Mookkan. Software Engineer, India My: Website | Yahoo Group | Blog Spot