123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354 |
- /**
- * 创建:信呼开发团队(雨中磐石)
- * 主页;http://www.rockoa.com/
- * xls文件转pdf程序
- * 使用:cscript //nologo xls.js //T:500 D:\a.doc
- * var fso = new ActiveXObject("Scripting.FileSystemObject");
- */
- WScript.Echo("start...");
- function getarr(caa){
- var s='';
- for(var a in caa)s+=' @@ '+a+'=>'+caa[a]+'';
- return s;
- }
- function gotourl(url){
- var xml = new ActiveXObject("MSXML2.XMLHTTP");
- xml.open("GET",url,false);
- xml.send();
- WScript.Echo("goto:"+url+"");
- }
- var files = WScript.Arguments;
- var docfile = files(0);
- WScript.Echo(docfile);
- var path = docfile.substr(0, docfile.lastIndexOf('.'));
- var isok = 2;
- var Obj = false;
- try{
- Obj = new ActiveXObject("Excel.Application");
- Obj.DisplayAlerts = false;
- var doc = Obj.Workbooks.Open(docfile);
- }catch(e){
- Obj = false;
- }
- if(Obj){
- var pdfpath = ""+path+".pdf";
- var fso = new ActiveXObject("Scripting.FileSystemObject");
- if(fso.FileExists(pdfpath))fso.DeleteFile(pdfpath);
- fso = false;
- try{
- doc.ExportAsFixedFormat(0, pdfpath);
- //doc.SaveAs(pdfpath,44, false); //转html
- WScript.Echo("isuccess");
- isok = 1;
- }catch(e){
- WScript.Echo("Error:"+getarr(e)+"");
- }
- doc.Close();
- Obj.Quit();
- }
- var yurl = files(1);
- if(isok>0 && yurl)gotourl(yurl+'&status='+isok+'');
- WScript.Quit(0);
|