package com.qxueyou.scc.base.util;

import com.jacob.activeX.ActiveXComponent;
import com.jacob.com.ComThread;
import com.jacob.com.Dispatch;
import com.jacob.com.Variant;

public class JacobUtil {  
    
    public static final String DOC = "doc";  
    public static final String DOCX = "docx";  
    public static final String PDF = "pdf";  
    public static final String XLS = "xls";  
    public static final String XLSX = "xlsx";  
    public static final String MP4 = "mp4";  
    public static final String PPT = "ppt";  
    public static final String PPTX = "pptx";  
   
     // 8 代表word保存成html    
     public static final int WORD2HTML = 8;    
     // 17代表word保存成pdf  
     public static final int WD2PDF = 17;  
     public static final int PPT2PDF = 32;  
     public static final int XLS2PDF = 0;  
   
 public static void main(String[] args) {     
     String pptfile = "D:/upload/新员工入职向导及信息201605.xlsx";    
     //String pdffile = "D:/upload/b.pdf";    
     String htmlfile="D:/upload/excel.pdf";
     //ppt2pdf(pptfile,pdffile);    
     excel2pdf(pptfile,htmlfile);
 }    
     
/** 
  * @param resourceType 资源类型 
  * @param path 资源路径 
  * @return 
  * TODO 文件转换 
  */  
 public static Integer formatConvert(String resourceType, String resourcePath) {  
     Integer pages = 0;  
     String resource = resourcePath.substring(0, resourcePath.lastIndexOf("."));  
     if(resourceType.equalsIgnoreCase(DOC)||resourceType.equalsIgnoreCase(DOCX)){  
         //word转成pdf和图??  
         word2pdf(resourcePath, resource+".pdf");  
     }else if(resourceType.equalsIgnoreCase(XLS)||resourceType.equalsIgnoreCase(XLSX)){  
         //excel文件转成图片  
         excel2pdf(resourcePath, resource+".pdf");  
     }else if(resourceType.equalsIgnoreCase(PPT)||resourceType.equalsIgnoreCase(PPTX)){  
         ppt2pdf(resourcePath, resource+".pdf");  
     }else if(resourceType.equalsIgnoreCase(MP4)){  
         //视频文件不转??  
         pages = 0;  
     }  
     return pages;  
 }  
     
   
 public static void word2pdf(String docfile, String pdffile)       
 {       
     // 启动word应用程序(Microsoft Office Word 2003)    
     ActiveXComponent app = null;    
     try{  
         ComThread.InitSTA();  
         app = new ActiveXComponent("Word.Application");       
         app.setProperty("Visible", false);  
         System.out.println("*****正在转换...*****");    
         // 设置word应用程序不可??  
        // app.setProperty("Visible", new Variant(false));      
         // documents表示word程序的所有文档窗口，（word是多文档应用程序???   
         Dispatch docs = app.getProperty("Documents").toDispatch();      
         // 打开要转换的word文件    
        /* Dispatch doc = Dispatch.invoke(      
                 docs,      
                 "Open",      
                 Dispatch.Method,      
                 new Object[] { docfile, new Variant(false),    
                         new Variant(true) }, new int[1]).toDispatch(); */  
           
         Dispatch doc = Dispatch.call(  
                 docs,       
                 "Open",  
                 docfile,  
                 false,  
                 true).toDispatch();       
         // 调用Document对象的saveAs方法,将文档保存为pdf格式  
         /*Dispatch.invoke(doc, "ExportAsFixedFormat", Dispatch.Method, new Object[] {      
                 pdffile, new Variant(wdFormatPDF) }, new int[1]);*/    
           
         Dispatch.call(doc, "ExportAsFixedFormat", pdffile, WD2PDF);    
         // 关闭word文件    
         Dispatch.call(doc, "Close", false);   
     }       
     catch (Exception e)       
     {   ComThread.Release();    
         e.printStackTrace();      
     }       
     finally      
     {       
         //关闭word应用程序    
         app.invoke("Quit", 0);     
         ComThread.Release();  
     }     
     System.out.println("*****转换完毕********");    
 }  
      
   
   
 public static void ppt2pdf(String pptfile,String pdffile){  
     ActiveXComponent app = null;  
     //app.setProperty("Visible", new Variant(false));  
     try {  
         ComThread.InitSTA();  
         app = new ActiveXComponent("PowerPoint.Application");  
         Dispatch files = app.getProperty("Presentations").toDispatch();  
         Dispatch file = Dispatch.call(files, "open", pptfile, false, true).toDispatch();  
         Dispatch.call(file, "SaveAs", pdffile, PPT2PDF);  
         Dispatch.call(file,"Close");  
     } catch (Exception e) {  
         ComThread.Release();  
         e.printStackTrace();  
         //throw e;  
     }finally{  
         app.invoke("Quit");  
         ComThread.Release();  
     }  
 }  
   
 public static void excel2pdf(String excelfile,String pdffile){  
     ActiveXComponent app = null;  
     try{  
         ComThread.InitSTA(true);  
         app = new ActiveXComponent("Excel.Application");  
         app.setProperty("Visible", false);  
         app.setProperty("AutomationSecurity", new Variant(3));//禁用??  
         Dispatch excels = app.getProperty("Workbooks").toDispatch();  
         /*Dispatch excel = Dispatch.invoke(excels, "Open", Dispatch.Method, new Object[]{ 
                 excelfile, 
                 new Variant(false), 
                 new Variant(false), 
         },new int[9]).toDispatch();*/  
         Dispatch excel = Dispatch.call(excels, "Open",   
                 excelfile,false,true).toDispatch();  
         //转换格式ExportAsFixedFormat  
         /*Dispatch.invoke(excel, "ExportAsFixedFormat", Dispatch.Method, new Object[]{ 
                 new Variant(0),//pdf格式=0 
                 pdffile, 
                 new Variant(0)//0=标准(生成的pdf图片不会变模??) 1=??小文??(生成的pdf图片模糊的一塌糊??) 
         }, new int[1]);*/  
         Dispatch.call(excel, "ExportAsFixedFormat",XLS2PDF,  
                 pdffile);  
         Dispatch.call(excel, "Close", false);  
         if(app!=null){  
             app.invoke("Quit");  
             app=null;  
         }  
     }catch(Exception e){  
         ComThread.Release();  
         e.printStackTrace();  
     }finally{  
         ComThread.Release();  
     }  
 }  

}