OOobbs2/152

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
-
-
|
|
|
|
|
|
|
|
|
|
|
|
|
!
-
|
|
!
-
|
|
!
!
 
 
 
 
 
 

import com.sun.star.frame.XDesktop;
import com.sun.star.script.provider.XScriptContext;
import com.sun.star.container.XIndexAccess;
import com.sun.star.lang.IndexOutOfBoundsException;
import com.sun.star.lang.WrappedTargetException;
import com.sun.star.lang.XMultiComponentFactory;
import com.sun.star.sheet.XSheetLinkable;
import com.sun.star.sheet.XSpreadsheet;
import com.sun.star.sheet.XSpreadsheetDocument;
import com.sun.star.sheet.XSpreadsheets;
import com.sun.star.uno.UnoRuntime;
import com.sun.star.uno.XComponentContext;
import com.sun.star.uno.XInterface;
 
//XComponentContext xContext = com.sun.star.comp.helper.Bootstrap.bootstrap();
//XMultiComponentFactory xServiceManager = xContext.getServiceManager();
 
public void snippet(XInterface oInitialTarget)
{
    try{
        XSpreadsheetDocument xSpreadsheetDocument = (XSpreadsheetDocument) UnoRuntime.queryInterface(
            XSpreadsheetDocument.class, oInitialTarget );
        XSpreadsheets xSpreadsheets = xSpreadsheetDocument.getSheets();
        
        XIndexAccess xIndexAccess = (XIndexAccess) UnoRuntime.queryInterface(
            XIndexAccess.class, xSpreadsheets );
        XSpreadsheet xSpreadsheet = (XSpreadsheet) UnoRuntime.queryInterface(
            XSpreadsheet.class, xIndexAccess.getByIndex( 0 ));
        
        XSheetLinkable xSheetLinkable = (XSheetLinkable) UnoRuntime.queryInterface(
            XSheetLinkable.class, xSpreadsheet );
        xSheetLinkable.link( "file:///E:/usr/test.ods", "Sheet1", "", "", com.sun.star.sheet.SheetLinkMode.NORMAL );
        
    }
    catch(WrappedTargetException e1){
        // getByIndex
        e1.printStackTrace(System.err);
    }
    catch(IndexOutOfBoundsException e2){
        // getByIndex
        e2.printStackTrace(System.err);
    }
}
 
 
oDoc = XSCRIPTCONTEXT.getDocument();
 
snippet(oDoc);
return 0;

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52

import com.sun.star.beans.PropertyValue;
import com.sun.star.frame.XComponentLoader;
import com.sun.star.frame.XController;
import com.sun.star.frame.XDesktop;
import com.sun.star.frame.XDispatchHelper;
import com.sun.star.frame.XDispatchProvider;
import com.sun.star.frame.XModel;
import com.sun.star.lang.XMultiComponentFactory;
import com.sun.star.uno.UnoRuntime;
import com.sun.star.uno.XComponentContext;
 
 
XComponentContext xCtx = XSCRIPTCONTEXT.getComponentContext();
XMultiComponentFactory xMCF = xCtx.getServiceManager();
 
// create desktop and loader
Object oDesktop = xMCF.createInstanceWithContext("com.sun.star.frame.Desktop", xCtx);
XComponentLoader xComponentLoader = (XComponentLoader) UnoRuntime.queryInterface(
    XComponentLoader.class, oDesktop);
 
// create dispatch helper
Object dispatchHelper = xMCF.createInstanceWithContext("com.sun.star.frame.DispatchHelper", xCtx);
XDispatchHelper xDispatchHelper = (XDispatchHelper) UnoRuntime.queryInterface(
    XDispatchHelper.class, dispatchHelper);
 
// loading test document
Object oDoc = xComponentLoader.loadComponentFromURL("file:///E:/usr/test.ods", "_blank", 0, new PropertyValue[0]);
XModel xDocModel = (XModel) UnoRuntime.queryInterface(XModel.class, oDoc);
 
XController  xDocController = (XController) UnoRuntime.queryInterface(
XController.class, xDocModel.getCurrentController());
 
XDispatchProvider xDocDispatchProvider = (XDispatchProvider) UnoRuntime.queryInterface(
    XDispatchProvider.class, xDocController);
 
// select all and copy it
xDispatchHelper.executeDispatch(xDocDispatchProvider, ".uno:SelectAll", "", 0, new PropertyValue[0]);
xDispatchHelper.executeDispatch(xDocDispatchProvider, ".uno:Copy", "", 0, new PropertyValue[0]);
 
// new doc to paste
Object oNewDoc = xComponentLoader.loadComponentFromURL("private:factory/scalc", "_blank", 0, new PropertyValue[0]);
XModel xNewDocModel = (XModel) UnoRuntime.queryInterface(XModel.class, oNewDoc);
 
XController  xNewDocController = (XController) UnoRuntime.queryInterface(
XController.class, xNewDocModel.getCurrentController());
XDispatchProvider xNewDocDispatchProvider = (XDispatchProvider) UnoRuntime.queryInterface(
    XDispatchProvider.class, xNewDocController);
 
 
xDispatchHelper.executeDispatch(xNewDocDispatchProvider, ".uno:Paste", "", 0, new PropertyValue[0]);
 
return 0;