Java-COM中間件:JACOB
JACOB是一個JAVA-COM橋,允許你從Java中調用COM自動化組件。它使用JNI調用本機的COM庫。 JACOB運行在x86和x64環境中支持32位和64位JVM。示例代碼:
import com.ms.com.*; import com.ms.activeX.*; public class DispatchTest { public static void main(String[] args) { ActiveXComponent xl = new ActiveXComponent("Excel.Application"); Object xlo = xl.getObject(); try { System.out.println("version="+xl.getProperty("Version")); System.out.println("version="+Dispatch.get(xlo, "Version")); xl.setProperty("Visible", new Variant(true)); Object workbooks = xl.getProperty("Workbooks").toDispatch(); Object workbook = Dispatch.get(workbooks,"Add").toDispatch(); Object sheet = Dispatch.get(workbook,"ActiveSheet").toDispatch(); Object a1 = Dispatch.invoke(sheet, "Range", Dispatch.Get, new Object[] {"A1"}, new int[1]).toDispatch(); Object a2 = Dispatch.invoke(sheet, "Range", Dispatch.Get, new Object[] {"A2"}, new int[1]).toDispatch(); Dispatch.put(a1, "Value", "123.456"); Dispatch.put(a2, "Formula", "=A1*2"); System.out.println("a1 from excel:"+Dispatch.get(a1, "Value")); System.out.println("a2 from excel:"+Dispatch.get(a2, "Value")); Variant f = new Variant(false); Dispatch.call(workbook, "Close", f); } catch (Exception e) { e.printStackTrace(); } finally { xl.invoke("Quit", new Variant[] {}); } } }
本文由用戶 jopen 自行上傳分享,僅供網友學習交流。所有權歸原作者,若您的權利被侵害,請聯系管理員。
轉載本站原創文章,請注明出處,并保留原始鏈接、圖片水印。
本站是一個以用戶分享為主的開源技術平臺,歡迎各類分享!