别人解决不了,只好请版主tonnycncn帮忙!!!问题是如何在ASP中用JAVASCRIPT打开EXCEL的模板文件?附源代

源代码为(大虾提供的,在此表示感谢!!)
function AutomateExcel()
{

在IE中运行时,MS EXCEL能正常运行,但就是打不开YZQ.XLT模板文件,显示的错误是MS EXCEL找不到d:\yzq.xlt文件,但该文件确实存在。但如果是新增一个BOOK1.XLS文件,运行正常,源代码将oXL.Workbooks.open("d:\\yzq.xlt");改为oXL.Workbooks.add();即可。

---------------------------------------------------------------

不好意思,现在才看到。给你一段代码吧。你应该可以看出区别吧。

 1<script language="JavaScript">   
 2function startExcel(strFile)   
 3{   
 4var myApp = new ActiveXObject("Excel.Application");   
 5if (myApp != null)   
 6{   
 7myApp.Visible = true;   
 8myApp.Workbooks.Open(strFile);   
 9}   
10}   
11</script>

You can now start Excel with a hyperlink:

1<a href="javascript:startExcel('http://yoursite/test.xls')">Test.xls</a>

.
As Excel is running locally, mind to feed a full URL as a parameter if you want to open a web document.

Published At
Categories with Web编程
comments powered by Disqus