用jacob将excle转为html

jacob实现了将excle转为html,下面是测试用例:

不明白Q我吧:1055513753

 

package testPackage;

import java.io.File;

import com.jacob.activeX.ActiveXComponent;
import com.jacob.com.ComThread;
import com.jacob.com.*;

public class ExcelToHtml {

  public static void exceltoHTML(String excelFilename, String htmlFilename)
     {
         ComThread.InitSTA();
         ActiveXComponent xl = new ActiveXComponent("Excel.Application");
        
         try
         {
             File fo = new File(htmlFilename);
             if (fo.exists()&&fo.canRead()){
                 fo.delete();
             }           
             xl.setProperty("Visible", new Variant(false));
             Dispatch workbooks = xl.getProperty("Workbooks").toDispatch();
             Dispatch workbook = Dispatch.invoke(workbooks, "Open", Dispatch.Method, new Object[]
             {excelFilename, new Variant(false), new Variant(true) },// 是否以只读方式打开
                     new int[1]).toDispatch();

             Dispatch.invoke(workbook, "SaveAs", Dispatch.Method, new Object[]
             {htmlFilename, new Variant(44) }, new int[1]); // 44,45

             Dispatch.call((Dispatch) workbook, "Close", new Variant(false));

         } catch (Exception e)
         {
             e.printStackTrace();
         } finally
         {
             xl.invoke("Quit", new Variant[]
             {});
             ComThread.Release();
         }
     }

 public static void main(String[] args) {
  
       ExcelToHtml.exceltoHTML("xxx.xls", "uuu.html");
    System.out.println("成功另存");
 }

}