Guest User

Untitled

a guest
May 25th, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.14 KB | None | 0 0
  1. Runtime.getRuntime().exec("C:/Program Files/OpenOffice.org 3/program/soffice.exe -accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager"); // oooUrlW - the url of soffice.exe
  2. Thread.sleep(5000);
  3.  
  4. XComponentContext xLocalContext = com.sun.star.comp.helper.Bootstrap.createInitialComponentContext(null);
  5. XMultiComponentFactory xLocalServiceManager = xLocalContext.getServiceManager();
  6. Object urlResolver = xLocalServiceManager.createInstanceWithContext("com.sun.star.bridge.UnoUrlResolver",xLocalContext);
  7. XUnoUrlResolver xUnoUrlResolver = (XUnoUrlResolver) UnoRuntime.queryInterface(XUnoUrlResolver.class,urlResolver);
  8.  
  9. Object initialObject = xUnoUrlResolver.resolve("uno:socket,host=localhost,port=8100;urp;StarOffice.ServiceManager");
  10. XPropertySet xPropertySet = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class,initialObject);
  11. XComponentContext remoteContext = (XComponentContext) UnoRuntime.queryInterface(XComponentContext.class, xPropertySet.getPropertyValue("DefaultContext"));
  12.  
  13. XMultiComponentFactory remoteServiceManager = remoteContext.getServiceManager();
  14. Object desktop = remoteServiceManager.createInstanceWithContext("com.sun.star.frame.Desktop", remoteContext);
  15.  
  16. xDesktop =(XDesktop) UnoRuntime.queryInterface( XDesktop.class, desktop);
  17. XComponent xCalcComponent =
  18. newDocComponent(xDesktop, "scalc");
  19. XSpreadsheetDocument xCalcDocument =
  20. (XSpreadsheetDocument)UnoRuntime.queryInterface(
  21. XSpreadsheetDocument.class, xCalcComponent);
  22. XSpreadsheets a=xCalcDocument.getSheets();
  23. Object o = a.getByName("Sheet1");
  24.  
  25. XSpreadsheet sheet = (XSpreadsheet)UnoRuntime.queryInterface(
  26. XSpreadsheet.class, o);
  27.  
  28.  
  29. XCell jjjj = sheet.getCellByPosition(0, 0);
  30. jjjj.setFormula("Some Text ");
  31.  
  32. Runtime.getRuntime().exec("C:/Program Files/OpenOffice.org 3/program/soffice.exe-accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager");
Add Comment
Please, Sign In to add comment