利用ASP输出excel文件一例（2）

正好我们部门内部网上有相关成功的例子,挖出来看,原来是在客户端建立excel.application的.这样,服务器端不会再冲突.对于客户端,因为是在局域网内运行,客户IE安全级别可以设低,并允许运行相关activeX(就是在IE工具选项中把各类涉及安全的东西都设为允许,具体的哪一项没有去追究),即使没有设置,IE也会弹出警告窗口:"是否允许运行activeX?"

实现的代码和上篇日志差不多,简单的如下:

程序代码:

<script language="vbscript"> 

set objExcelApp=CreateObject("Excel.Application") 
objExcelApp.DisplayAlerts=true 

objExcelApp.WorkBooks.Open("https://www.aspxhome.com/XXX.xls") 
'完整网路地址的xls文件,这个文件已经设置好格式及打印样式,保存在服务器上 
set objExcelBook=objExcelApp.ActiveWorkBook 
set objExcelSheets=objExcelBook.Worksheets 
set objExcelSheet=objExcelBook.Sheets(1) 
'====此处为对excel单元格进行填写数据的语句,如果是从数据库提取数据,可由后台程序生成这些语句,ASP中的示列: 
'如:response.write "objExcelSheet.Range(""B2"").Value="""&rs("XXX")&"""" 
'或 objExcelSheet.Range("B2").Value="<％=rs("XXX")％>" 

objExcelSheet.Range("B2:k2").Value=Array("Week1","Week2","Week3","Week4","Week5","Week6","Week7") 
objExcelSheet.Range("B3:k3").Value=Array("67","87","5","9","7","45","45","54","54","10") 
objExcelSheet.Range("B4:k4").Value=Array("10","10","8","27","33","37","50","54","10","10") 
objExcelSheet.Range("B5:k5").Value=Array("23","3","86","64","60","18","5","1","36","80") 
objExcelSheet.Cells(3,1).Value="InternetExplorer" 
objExcelSheet.Cells(4,1).Value="Netscape" 
objExcelSheet.Cells(5,1).Value="Other" 
'================== 

'objExcelApp.Quit 
'set objExcelApp=Nothing 

</script> 

上述代码中

'objExcelApp.Quit 
'set objExcelApp=Nothing 

作为取消执行,因为此处不要关闭excel.applicaition,不然数据填完后,excel会关闭掉.这时在客户端打开的excel文件需要由客户进行修改或打印等操作.

同时objexcelapp对象还有打印设置及进入打印预览界面等方法,可参考相关excel相关资料.