ǰҳ: ҳ Javascript ר 在IE中调用javascript打开Excel
在IE中调用javascript打开Excel
ժҪ: 在IE中调用javascript打开Excel
<textarea readonly style="border:none;font-family:Courier New;line-height:150%;width:760px;overflow-y:visible">
HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> pt´xcel(downmoonԭط)
<head>
HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<head>
Top30к¿ر뺯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к¿ر뮔OP30ʌѸԼк¿ر뮉Ϻ£.xls");
oExcel.DisplayAlerts = false;
oExcel.Visible = true;
//oExcel.Quit();
//oExcel = null;
//·�Excel̀½�¹ؼ�ِ룡£¡£¡downmoonҏטʹķ
idTmr = window.setInterval("Cleanup();",1000);
}
function Cleanup() {
window.clearInterval(idTmr);
CollectGarbage();
}
</script>
</body>
Top30销控表
</head> ight: 25px;">
<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>
</textarea>
Ŀ¼
ǰһƪ: JavaScriptѧϰ
һƪ: JavaScriptѧϰ