在 IE 中調用 javascript 打開 Excel 表

2019-11-21 02:25:20

字體：大中小

來源：轉載

供稿：網友

<!DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.0 Transitional//EN“>
<HTML>
<HEAD>
<META http-equiv=Content-Type content=“text/html; charset=utf-8“>
<TITLE>打開Excel表</TITLE>

</HEAD>
<BODY>

<input name=“shanghai“ type=“button“ class=“but“ id=“shanghai“ onClick=“StartExcel('上海')“ value=“上海店“>

<SCRIPT LANGUAGE=“Javascript“>
var idTmr = ““;

function StartExcel(strFileName)
{
var oExcel;
var oWorkbook;
var strAllName;
oExcel = new ActiveXObject(“Excel.Application“);
//if(strFileName=null || strFileName=““)
//{return;
//}
strAllName=“////ep-hgh//Top30銷控表//TOP30招商續約銷控表-“+strFileName+“.xls“;
oExcel.Workbooks.Open(strAllName);
//oExcel.Workbooks.Open(“file://ep-hgh/Top30銷控表/TOP30招商續約銷控表-上海.xls“);
oExcel.DisplayAlerts = false;
oExcel.Visible = true;
//oExcel.Quit();
//oExcel = null;
//防EExcel死進程的關鍵！！必須！！！downmoon嚴重聲明
idTmr = window.setInterval(“Cleanup();“,1000);
}

function Cleanup() {
window.clearInterval(idTmr);
CollectGarbage();
}

</SCRIPT>

</BODY>
</HTML>

上一篇：用JavaScript腳本實現Web頁面信息交互

下一篇：用js+xml自動生成表格的東西