javascript导excel格式.docx

纯javascript导出Excel表 方法一：整个表格拷贝到excel中 function method1(tableid) var btn = document.getElementById(copy); btn.setAttribute(disabled, true); btn.setAttribute(value, 处理中.); var curTbl = document.getElementById(tableid); try var oXL = new ActiveXObject(Excel.Application); catch (e) /IE安全级别未设置将出现错误 （ Automation 服务器不能创建对象 ） /* 如果是Scripting.FileSystemObject (FSO 文本文件读写)被关闭了，开启FSO功能即可，在“运行”中执行regsvr32 scrrun.dll即可 */ alert(无法启动Excel!nn如果您确信您的电脑中已经安装了Excel， + 那么请调整IE的安全级别。nn具体操作：nn + 工具 Internet选项 安全 自定义级别 对没有标记为安全的ActiveX进行初始化和脚本运行 启用); return false;var oWB = oXL.Workbooks.Add();var oSheet = oWB.ActiveSheet;var sel = document.body.createTextRange();sel.moveToElementText(curTbl);sel.select();sel.execCommand(Copy);oSheet.Paste();oXL.Visible = true;var fname = oXL.Application.GetSaveAsFilename(将table导出到excel.xls, Excel Spreadsheets (*.xls), *.xls);oWB.SaveAs(fname);oWB.Close();oXL.Quit();/控制按钮btn.removeAttribute(disabled); btn.setAttribute(value, 导出结果到Excel); function method1(tableid) /整个表格拷贝到EXCEL中 var curTbl = document.getElementById(tableid); var oXL = new ActiveXObject(Excel.Application); /创建AX对象excel var oWB = oXL.Workbooks.Add(); /获取workbook对象 var oSheet = oWB.ActiveSheet; /激活当前sheet var sel = document.body.createTextRange(); sel.moveToElementText(curTbl); /把表格中的内容移到TextRange中 sel.select(); /全选TextRange中内容 sel.execCommand(Copy); /复制TextRange中内容 oSheet.Paste(); /粘贴到活动的EXCEL中 oXL.Visible = true; /设置excel可见属性 方法二：读取单元格到excel中 function method2(tableid) /读取表格中每个单元到EXCEL中 var curTbl = document.getElementById(tableid); var oXL = new ActiveXObject(Excel.Application); /创建AX对象excel var oWB = oXL.Workbooks.Add(); /获取workbook对象 var oSheet = oWB.ActiveSheet; /激活当前sheet var Lenr = curTbl.rows.length; /取得表格行数 for (i = 0; i Lenr; i+) var Lenc = curTbl.rows(i).cells.length; /取得每行的列数 for (j = 0; j + e.description + !); function getTblData(inTbl, inWindow) var rows = 0; /alert(getTblData is + inWindow); var tblDocument = document; if (!inWindow & inWindow != ) if (!document.all(inWindow) return null; else tblDocument = eval(inWindow).document; var curTbl = tblDocument.getElementById(inTbl); var outStr = ; if (curTbl != null) for (var j = 0; j curTbl.rows.length; j+) /alert(j is + j); for (var i = 0; i 0) outStr += t; rows -= 1; outStr += curTbl.rowsj.cellsi.innerText + t; if (curTbl.rowsj.cellsi.colSpan 1) for (var k = 0; k 1) rows = curTbl.rowsj.cellsi.rowSpan - 1; outStr += rn; else outStr = null; alert(inTbl + 不存在!); return outStr; function getExcelFileName() var d = new Date(); var curYear = d.getYear(); var curMonth = + (d.getMonth() + 1); var curDate = + d.getDate(); var curHour = + d.getHours(); var curMinute = + d.getMinutes(); var curSecond = + d.getSeconds(); if (curMonth.length = 1) curMonth = 0 + curMonth; if (curDate.length = 1) curDate = 0 + curDate; if (curHour.length = 1) curHour = 0 + curHour; if (curMinute.length = 1) curMinute = 0 + curMinute; if (curSecond.length = 1) curSecond = 0 + curSecond; var fileName = leo_zhang + _ + curYear + curMonth + curDate + _ + curHour + curMinute + curSecond + .csv; /alert(fileName); return fileName; function doFileExport(inName, inStr) var xlsWin = null; if (!document.all(glbHideFrm) xlsWin = glbHideFrm; else var width = 6; var height = 4; var openPara = left= + (window.screen.width / 2 - width / 2) + ,top= + (window.screen.height / 2 - height / 2) + ,scrollbars=no,width= + width + ,heigh