Javascript 实现table完全数据导出

导出带样式的Excel

最新推荐文章于 2023-07-10 17:26:58 发布

原创最新推荐文章于 2023-07-10 17:26:58 发布 · 1.2k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#javascript #table #border #string #excel #function

Web 同时被 3 个专栏收录

26 篇文章

订阅专栏

工作积累

26 篇文章

订阅专栏

技术交流

9 篇文章

订阅专栏

本文介绍了一种在网页上将包含样式的表格数据导出为Excel的方法，通过JavaScript和后端逻辑实现了完整样式的保留。

做报表的时候常常需要在表格中画不同的样式，但在做数据导出的时候往往很难把格式做在上面，所以我们有时候需要将页面上的table数据和table样式原封不动的导出。

给个例子说明：

数据页面：

Report.aspx

调用Javascript 函数：

function ExportExcelByID(ReportTableID,reportname) { if (!$("#cDiv")) { alert("请先确定导出内容!"); return false; } var exportvalue = $("#cDiv").html(); exportvalue = exportvalue.replace(// /g, ""); exportvalue = escape(exportvalue); var ExportForm = document.createElement("FORM"); document.body.appendChild(ExportForm); ExportForm.method = "POST"; //var newElement = document.createElement("<input name='exportvalue' type='hidden' id='exportvalue'>");//该方法不支持firefox var newElement = document.createElement("input"); newElement.setAttribute("name", "exportvalue"); newElement.setAttribute("type", "hidden"); ExportForm.appendChild(newElement); newElement.value = exportvalue; ExportForm.action = "/Report/ToExcel/"+reportname; ExportForm.target = "_blank"; ExportForm.submit(); }

导出数据的后台函数：

#region 导出Excel public ActionResult ToExcel(string id) { string exportvalue =Request["exportvalue"]; //xyq 2007.12.4 负数导出到excel后不能运算 // exportvalue = exportvalue.Replace("-", "—"); //去掉一些不要显示的字符串 //exportvalue = Remove(exportvalue, "DISPLAY: none"); /* exportvalue = Remove(exportvalue, "<SPAN style="/" mce_style="/""DISPLAY: none", "</SPAN>"); exportvalue = Remove(exportvalue, "<TD style="/" mce_style="/""DISPLAY: none", "</TD>"); exportvalue = Remove(exportvalue, "<TH style="/" mce_style="/""DISPLAY: none", "</TH>"); */ //解密页面传来的数据 exportvalue = Microsoft.JScript.GlobalObject.unescape(Server.HtmlDecode(exportvalue)); exportvalue = exportvalue.Replace("?", ""); exportvalue = exportvalue.Replace(" ", ""); exportvalue = exportvalue.Replace("<TABLE", "<TABLE border=/"1/" bordercolor=/"#000000/""); exportvalue = exportvalue.Replace("<table", "<table border=/"1/" "); exportvalue = exportvalue.Replace("border=0", "border=1 "); exportvalue = exportvalue.Replace("border='0'", "border=1 "); exportvalue = exportvalue.Replace("border=/"0/"", "border=1 "); exportvalue = exportvalue.Replace("STYLE", "stylefrom "); exportvalue = exportvalue.Replace("<TD><SPAN></SPAN></TD>", " "); exportvalue = exportvalue.Replace("<A ", "<SPAN "); exportvalue = exportvalue.Replace("</A>", "</SPAN>"); exportvalue = exportvalue.Replace("<IMG ", "<IMG1 "); exportvalue = exportvalue.Replace("type=image ", "type=image1 "); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; //this.EnableViewState = false; //xyq 2007.12.4 Response.ContentEncoding = System.Text.Encoding.UTF8; Response.AddHeader("Content-Disposition", "attachment;filename="+id+".xls"); StringWriter sw = new StringWriter(); //sw.WriteLine("javascript:unescape('" +exportvalue+"');"); sw.WriteLine(exportvalue); HtmlTextWriter htmlWriter = new HtmlTextWriter(sw); Control cr = new Control(); cr.RenderControl(htmlWriter); //强制输出bom 这样避免excel打开时乱码 Response.BinaryWrite(new byte[] { 0xEF, 0xBB, 0xBF }); Response.Write(sw.ToString()); Response.End(); //newWin.document.execCommand('Saveas',false,'c://test.xls') return View(); } /// <summary> /// 去掉一些不要显示的字符串，如“<... DISPLAY: none ...>....</...>” /// </summary> /// <param name="value"></param> /// <param name="removeKey"></param> /// <returns></returns> protected string Remove(string value, string removeKey) { string exportvalue = value; int iCurrent = 0; int iStart = exportvalue.IndexOf(removeKey, iCurrent); while (iStart >= 0) { iCurrent = iStart + removeKey.Length; string temp = exportvalue.Substring(0, iStart); int nodeStart = temp.LastIndexOf("<"); if (nodeStart >= 0) { int k = temp.IndexOf(" ", nodeStart); if (k > 0) { string nodeName = temp.Substring(nodeStart + 1, k - nodeStart - 1); string nodeEndName = string.Format("</{0}>", nodeName); int nodeEnd = exportvalue.IndexOf(nodeEndName, iStart + removeKey.Length); if (nodeEnd >= 0) { exportvalue = exportvalue.Remove(nodeStart, nodeEnd + nodeEndName.Length - nodeStart); iCurrent = nodeStart; } } } iStart = exportvalue.IndexOf(removeKey, iCurrent); } return exportvalue; } #endregion