1 private void ToExcel(string html)
2 {
3
4 Response.ContentType = "application/force-download";
5 Response.AddHeader("content-disposition",
6 "attachment; filename=" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls");
7 Response.Write("<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">");
8 Response.Write("<head>");
9 Response.Write("<META http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">");
10 string fileCss = Server.MapPath("~/UI/themes/DRP.UI.Ext.css");
11 string cssText = string.Empty;
12 StreamReader sr = new StreamReader(fileCss);
13 var line = string.Empty;
14 while ((line = sr.ReadLine()) != null)
15 {
16 cssText += line;
17 }
18 sr.Close();
19 Response.Write("<style>" + cssText + "</style>");
20 Response.Write("<!--[if gte mso 9]><xml>");
21 Response.Write("<x:ExcelWorkbook>");
22 Response.Write("<x:ExcelWorksheets>");
23 Response.Write("<x:ExcelWorksheet>");
24 Response.Write("<x:Name>Report Data</x:Name>");
25 Response.Write("<x:WorksheetOptions>");
26 Response.Write("<x:Print>");
27 Response.Write("<x:ValidPrinterInfo/>");
28 Response.Write("</x:Print>");
29 Response.Write("</x:WorksheetOptions>");
30 Response.Write("</x:ExcelWorksheet>");
31 Response.Write("</x:ExcelWorksheets>");
32 Response.Write("</x:ExcelWorkbook>");
33 Response.Write("</xml>");
34 Response.Write("<![endif]--> ");
35 Response.Write(html);//HTML
36 Response.Flush();
37 Response.End();
38 }
