数据导出 WPS表格
<script language="javascript" type="text/javascript">
function ToExcelOfWPS()
{
var myExcel,myBook;
try {
myExcel = new ActiveXObject("ET.Application");
}catch(Exception ) {
alert("Open WPS Application exception");
return;
}
//window.clipboardData.setData("Text",document.getElementById("ExcTable").innerHTML);
//myExcel.Visible = true;
//myBook = myExcel.Workbooks.Add();
//myBook.sheets("Sheet1").Paste();
if(myExcel!=null){
var sel = document.body.createTextRange();
sel.moveToElementText(ExcTable);
sel.select();
sel.execCommand("Copy");
sel.execCommand("Unselect");
myExcel.Visible = true;
myBook = myExcel.Workbooks.Add();
myBook.sheets("Sheet1").Paste();
myBook.sheets("Sheet1").Columns.Font.Size = 9;
myBook.sheets("Sheet1").Columns.AutoFit();
}
}
</script>
