C#导出生成excel文件的方法小结(xml,html方式)
/// <summary>
/// xml格式生成excel文件并存盘; /// </summary>
/// <param name=\生成报表的页面，没有传null</param>
/// <param name=\数据表</param> /// <param name=\报表标题，sheet1名</param>
/// <param name=\存盘文件名，全路径</param>
/// <param name=\生成文件后是否提示下载,只有web下才有效</param> public static void
CreateExcelByXml(System.Web.UI.Page page, DataTable dt, String TableTitle, string fileName, bool IsDown) {
StringBuilder strb = new StringBuilder(); strb.Append(\
xmlns:o=\\\
strb.Append(\el\\\
strb.Append(\
strb.Append(\http-equiv='Content-Type' content='text/html; charset=UTF-8'>\
strb.Append(\ strb.Append(\
strb.Append(\ strb.Append(\serif;\
strb.Append(\ strb.Append(\ strb.Append(\ //strb.Append(\{border-collapse:collapse;margin:1em
0;line-height:20px;font-size:12px;color:#222; margin:0px;}\ strb.Append(\{border-collapse:collapse;margin:1em 0;line-height:20px;color:#222; margin:0px;}\ strb.Append(\
strb.Append(\
{background-color:#e3e6ea;color:#6e6e6e;text-align:center;font-size:14px;}\
strb.Append(\
strb.Append(\ strb.Append(\ strb.Append(\
strb.Append(\ strb.Append(\ strb.Append(\ //设置工作表 sheet1的名称
strb.Append(\</x:Name>\
strb.Append(\ strb.Append(\</x:DefaultRowHeight>\
strb.Append(\ strb.Append(\ strb.Append(\ strb.Append(\</x:Number>\
strb.Append(\
</x:ActiveCol>\
strb.Append(\ strb.Append(\
strb.Append(\</x:ProtectContents>\
strb.Append(\</x:ProtectObjects>\
strb.Append(\</x:ProtectScenarios>\
strb.Append(\ strb.Append(\ strb.Append(\</x:WindowHeight>\
strb.Append(\</x:WindowWidth>\
strb.Append(\</x:WindowTopX>\
strb.Append(\</x:WindowTopY>\
strb.Append(\</x:ProtectStructure>\
strb.Append(\
</x:ProtectWindows>\
strb.Append(\ strb.Append(\ strb.Append(\
strb.Append(\ strb.Append(\solid #CCC;border-bottom: 1px solid
#CCC;text-align:center;\\\ //合格所有列并显示标题 strb.Append(\
style=\\\colspan=\\\ strb.Append(TableTitle);
strb.Append(\ strb.Append(\
strb.Append(\style=\\\ if (dt != null) {
//写列标题
int columncount = dt.Columns.Count; for (int columi = 0; columi <