在js中有以字符串例如:
var str= "<table border='1' id='tbResult' width='98%' cellspacing='0' cellpadding='0' class='statisticresult'><tr class='headtr'><td>序号</td><td width='50%'>单位名称</td><td width='25%'>参团团组数</td><td width='25%'>派出人次数</td></tr><tr>><td>序号</td><td width='50%'>单位名称</td><td width='25%'>参团团组数</td><td width='25%'>派出人次数</td></tr></table>" 如何用js方法把这个用字符串拼成的表格导出Excel
var str= "<table border='1' id='tbResult' width='98%' cellspacing='0' cellpadding='0' class='statisticresult'><tr class='headtr'><td>序号</td><td width='50%'>单位名称</td><td width='25%'>参团团组数</td><td width='25%'>派出人次数</td></tr><tr>><td>序号</td><td width='50%'>单位名称</td><td width='25%'>参团团组数</td><td width='25%'>派出人次数</td></tr></table>" 如何用js方法把这个用字符串拼成的表格导出Excel
function AllAreaExcel() {
try{
var oXL = new ActiveXObject("Excel.Application");
}catch(e){
alert("请先安装Excel再进行导出");
return false;
}
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
oSheet.Columns.ColumnWidth =10;
var sel = document.body.createTextRange(); sel.moveToElementText(PrintA); sel.select();
sel.execCommand("Copy");
oSheet.Paste();
oXL.Visible = true;
} function AllAreaWord() {
try{
var oWD = new ActiveXObject("Word.Application");
}catch(e){
alert("请先安装Word再进行导出");
return false;
}
var oDC = oWD.Documents.Add("", 0, 1);
var oRange = oDC.Range(0, 1);
var sel = document.body.createTextRange();
sel.moveToElementText(PrintA);
sel.select();
sel.execCommand("Copy");
oRange.Paste();
oWD.Application.Visible = true;
//window.close();
}
</script>
var winname = window.open('', '_blank', 'top=10000');
var strHTML = document.all.tableExcel.innerHTML;
winname.document.open('text/html', 'replace');
winname.document.writeln(strHTML);
winname.document.execCommand('saveas','','excel.xls');
winname.close();
}
activex 涉及安全性设置