xls.js 1.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354
  1. /**
  2. * 创建:信呼开发团队(雨中磐石)
  3. * 主页;http://www.rockoa.com/
  4. * xls文件转pdf程序
  5. * 使用:cscript //nologo xls.js //T:500 D:\a.doc
  6. * var fso = new ActiveXObject("Scripting.FileSystemObject");
  7. */
  8. WScript.Echo("start...");
  9. function getarr(caa){
  10. var s='';
  11. for(var a in caa)s+=' @@ '+a+'=>'+caa[a]+'';
  12. return s;
  13. }
  14. function gotourl(url){
  15. var xml = new ActiveXObject("MSXML2.XMLHTTP");
  16. xml.open("GET",url,false);
  17. xml.send();
  18. WScript.Echo("goto:"+url+"");
  19. }
  20. var files = WScript.Arguments;
  21. var docfile = files(0);
  22. WScript.Echo(docfile);
  23. var path = docfile.substr(0, docfile.lastIndexOf('.'));
  24. var isok = 2;
  25. var Obj = false;
  26. try{
  27. Obj = new ActiveXObject("Excel.Application");
  28. Obj.DisplayAlerts = false;
  29. var doc = Obj.Workbooks.Open(docfile);
  30. }catch(e){
  31. Obj = false;
  32. }
  33. if(Obj){
  34. var pdfpath = ""+path+".pdf";
  35. var fso = new ActiveXObject("Scripting.FileSystemObject");
  36. if(fso.FileExists(pdfpath))fso.DeleteFile(pdfpath);
  37. fso = false;
  38. try{
  39. doc.ExportAsFixedFormat(0, pdfpath);
  40. //doc.SaveAs(pdfpath,44, false); //转html
  41. WScript.Echo("isuccess");
  42. isok = 1;
  43. }catch(e){
  44. WScript.Echo("Error:"+getarr(e)+"");
  45. }
  46. doc.Close();
  47. Obj.Quit();
  48. }
  49. var yurl = files(1);
  50. if(isok>0 && yurl)gotourl(yurl+'&status='+isok+'');
  51. WScript.Quit(0);