vbs是打印excel文件,并执行打印操作。 使用cmd命令和直接运行vbs程序,都可进行打印。 而php调用vbs时,$returnvalue输出为0(代表执行成功),可就是不执行打印操作。 PHP:<?php
system("C:/print.vbs", $returnvalue);
echo $returnvalue;
?>=====================
vbs :
templatePath="C:\2.xls"
'create object
Set oExcel=CreateObject("Excel.Application")
oExcel.DisplayAlerts = False
Set tmpExcel=oExcel.Workbooks.Open(templatePath,3,False)
oExcel.ActiveSheet.PageSetup.PrintGridLines = False
oExcel.ActiveSheet.PrintOut
oExcel.ActiveWorkBook.Saved = False
oExcel.Quit
system("C:/print.vbs", $returnvalue);
echo $returnvalue;
?>=====================
vbs :
templatePath="C:\2.xls"
'create object
Set oExcel=CreateObject("Excel.Application")
oExcel.DisplayAlerts = False
Set tmpExcel=oExcel.Workbooks.Open(templatePath,3,False)
oExcel.ActiveSheet.PageSetup.PrintGridLines = False
oExcel.ActiveSheet.PrintOut
oExcel.ActiveWorkBook.Saved = False
oExcel.Quit
解决方案 »
- 怎样用PHP将数据库记录直接输出到word文件中
- PHP的preg_replace 正则替换。怎么用
- 求一个根据文件名不同显示二级菜单的功能?
- PHP调用dll的问题
- [百度分享]PHP函数的实现原理及性能分析(三)
- mysql中char型按范围输出的问题,在线等
- 帮忙看看哪里错了??急 php模拟POST
- mysql 中编码GB2312 DOC下读出正常,PHP页面编码也是,但是读出全是问号?跪求帮忙!
- php中把@加在语句的前面起到一个什么作用?
- 郁闷,现在越做网站感觉越来越不会作了,痛苦,大家介绍几个界面不错的网址吧
- 关于php在服务器上配置首页的问题
- 用Wscript.Shell压缩有问,谢谢
1. 点击开始->运行,输入日regedit.按确定。
2. 访问以下键值:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\COM3
3. 右击选择导出。完成后删除此键值。
4. 访问以下键值:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Ole
5. 右击选择导出。完成后删除以下键值
DefaultAccessPermissions
MachineAccessRestriction
MachineLaunchRestriction
6. 重启计算机。重启完成后执行一次添加/删除Windows组件。
二、注册表导入Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Ole]
"DefaultLaunchPermission"=hex:01,00,04,80,64,00,00,00,80,00,00,00,00,00,00,00,\
14,00,00,00,02,00,50,00,03,00,00,00,00,00,18,00,01,00,00,00,01,01,00,00,00,\
00,00,05,12,00,00,00,00,00,00,00,00,00,18,00,01,00,00,00,01,01,00,00,00,00,\
00,05,04,00,00,00,00,00,00,00,00,00,18,00,01,00,00,00,01,02,00,00,00,00,00,\
05,20,00,00,00,20,02,00,00,01,05,00,00,00,00,00,05,15,00,00,00,a0,5f,84,1f,\
5e,2e,6b,49,ce,12,03,03,f4,01,00,00,01,05,00,00,00,00,00,05,15,00,00,00,a0,\
5f,84,1f,5e,2e,6b,49,ce,12,03,03,f4,01,00,00
"MachineLaunchRestriction"=hex:01,00,04,80,60,00,00,00,70,00,00,00,00,00,00,00,\
14,00,00,00,02,00,4c,00,03,00,00,00,00,00,18,00,1f,00,00,00,01,02,00,00,00,\
00,00,05,20,00,00,00,20,02,00,00,00,00,18,00,1f,00,00,00,01,02,00,00,00,00,\
00,05,20,00,00,00,32,02,00,00,00,00,14,00,0b,00,00,00,01,01,00,00,00,00,00,\
01,00,00,00,00,01,02,00,00,00,00,00,05,20,00,00,00,20,02,00,00,01,02,00,00,\
00,00,00,05,20,00,00,00,20,02,00,00
"MachineAccessRestriction"=hex:01,00,04,80,5c,00,00,00,6c,00,00,00,00,00,00,00,\
14,00,00,00,02,00,48,00,03,00,00,00,00,00,14,00,07,00,00,00,01,01,00,00,00,\
00,00,05,07,00,00,00,00,00,18,00,07,00,00,00,01,02,00,00,00,00,00,05,20,00,\
00,00,32,02,00,00,00,00,14,00,07,00,00,00,01,01,00,00,00,00,00,01,00,00,00,\
00,01,02,00,00,00,00,00,05,20,00,00,00,20,02,00,00,01,02,00,00,00,00,00,05,\
20,00,00,00,20,02,00,00
"EnableDCOM"="Y"三、MSDTC 重新安装msdtc -uninstall
msdtc -install