Asp.net Examples: Export to Excel Using Styles

public void ExportDataGridToExcel(System.Web.UI.Control ctrl, System.Web.HttpResponse response) 
 
{ 
 
response.Clear(); 
response.Buffer= true; 
 
response.Cache.SetCacheability(HttpCacheability.NoCache); 
response.ContentType = "application/vnd.ms-excel"; 
 
response.AddHeader("content-disposition", "attachment;filename=Projects.xls"); 
response.Charset = ""; 
 
this.EnableViewState = false; 
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); 
 
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); 
this.ClearControls(ctrl); 
 
ctrl.RenderControl(oHtmlTextWriter); 
 
// set content type and character set to cope with european chars like the umlaut. 
response.Write("<meta http-equiv=Content-Type content=\"text/html; charset=utf-8\">\n"); 
 
// add the style props to get the page orientation 
 
response.Write(AddExcelStyling()); 
 
response.Write(oStringWriter.ToString()); 
response.Write("</body>");response.Write("</html>"); 
 
response.End(); 
 
} 
private string AddExcelStyling() 
 
{ 
StringBuilder sb = new StringBuilder(); 
 
sb.Append("<html xmlns:o='urn:schemas-microsoft-com:office:office'\n" +
"xmlns:x='urn:schemas-microsoft-com:office:excel'\n" +

"xmlns='http://www.w3.org/TR/REC-html40'>\n" + 
"<head>\n"); 
 
sb.Append("<style>\n");
sb.Append("@page");

sb.Append("{margin:.5in .75in .5in .75in;\n");
sb.Append("mso-header-margin:.5in;\n");

sb.Append("mso-footer-margin:.5in;\n");
sb.Append("mso-page-orientation:landscape;}\n");

sb.Append("</style>\n"); 
sb.Append("<!--[if gte mso 9]><xml>\n"); 
 
sb.Append("<x:ExcelWorkbook>\n"); 
sb.Append("<x:ExcelWorksheets>\n"); 
 
sb.Append("<x:ExcelWorksheet>\n"); 
sb.Append("<x:Name>Projects 3 </x:Name>\n"); 
 
sb.Append("<x:WorksheetOptions>\n"); 
sb.Append("<x:Print>\n"); 
 
sb.Append("<x:ValidPrinterInfo/>\n"); 
sb.Append("<x:PaperSizeIndex>9</x:PaperSizeIndex>\n"); 
 
sb.Append("<x:HorizontalResolution>600</x:HorizontalResolution\n");
sb.Append("<x:VerticalResolution>600</x:VerticalResolution\n");

sb.Append("</x:Print>\n"); 
sb.Append("<x:Selected/>\n"); 
 
sb.Append("<x:DoNotDisplayGridlines/>\n"); 
sb.Append("<x:ProtectContents>False</x:ProtectContents>\n"); 
 
sb.Append("<x:ProtectObjects>False</x:ProtectObjects>\n"); 
sb.Append("<x:ProtectScenarios>False</x:ProtectScenarios>\n"); 
 
sb.Append("</x:WorksheetOptions>\n"); 
sb.Append("</x:ExcelWorksheet>\n"); 
 
sb.Append("</x:ExcelWorksheets>\n"); 
sb.Append("<x:WindowHeight>12780</x:WindowHeight>\n"); 
 
sb.Append("<x:WindowWidth>19035</x:WindowWidth>\n"); 
sb.Append("<x:WindowTopX>0</x:WindowTopX>\n"); 
 
sb.Append("<x:WindowTopY>15</x:WindowTopY>\n"); 
sb.Append("<x:ProtectStructure>False</x:ProtectStructure>\n"); 
 
sb.Append("<x:ProtectWindows>False</x:ProtectWindows>\n"); 
sb.Append("</x:ExcelWorkbook>\n"); 
 
sb.Append("</xml><![endif]-->\n"); 
sb.Append("</head>\n"); 
 
sb.Append("<body>\n"); 
return sb.ToString(); 
 
}

Asp.net Examples

Monday, July 28, 2008

Export to Excel Using Styles

No comments:

Categories

Blog Archive

More

Ads