1*cdf0e10cSrcweir /*************************************************************************
2*cdf0e10cSrcweir  *
3*cdf0e10cSrcweir  *  The Contents of this file are made available subject to the terms of
4*cdf0e10cSrcweir  *  the BSD license.
5*cdf0e10cSrcweir  *
6*cdf0e10cSrcweir  *  Copyright 2000, 2010 Oracle and/or its affiliates.
7*cdf0e10cSrcweir  *  All rights reserved.
8*cdf0e10cSrcweir  *
9*cdf0e10cSrcweir  *  Redistribution and use in source and binary forms, with or without
10*cdf0e10cSrcweir  *  modification, are permitted provided that the following conditions
11*cdf0e10cSrcweir  *  are met:
12*cdf0e10cSrcweir  *  1. Redistributions of source code must retain the above copyright
13*cdf0e10cSrcweir  *     notice, this list of conditions and the following disclaimer.
14*cdf0e10cSrcweir  *  2. Redistributions in binary form must reproduce the above copyright
15*cdf0e10cSrcweir  *     notice, this list of conditions and the following disclaimer in the
16*cdf0e10cSrcweir  *     documentation and/or other materials provided with the distribution.
17*cdf0e10cSrcweir  *  3. Neither the name of Sun Microsystems, Inc. nor the names of its
18*cdf0e10cSrcweir  *     contributors may be used to endorse or promote products derived
19*cdf0e10cSrcweir  *     from this software without specific prior written permission.
20*cdf0e10cSrcweir  *
21*cdf0e10cSrcweir  *  THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
22*cdf0e10cSrcweir  *  "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
23*cdf0e10cSrcweir  *  LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
24*cdf0e10cSrcweir  *  FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
25*cdf0e10cSrcweir  *  COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
26*cdf0e10cSrcweir  *  INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
27*cdf0e10cSrcweir  *  BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS
28*cdf0e10cSrcweir  *  OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
29*cdf0e10cSrcweir  *  ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR
30*cdf0e10cSrcweir  *  TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE
31*cdf0e10cSrcweir  *  USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
32*cdf0e10cSrcweir  *
33*cdf0e10cSrcweir  *************************************************************************/
34*cdf0e10cSrcweir 
35*cdf0e10cSrcweir // __________ Imports __________
36*cdf0e10cSrcweir 
37*cdf0e10cSrcweir import java.util.Random;
38*cdf0e10cSrcweir 
39*cdf0e10cSrcweir // base classes
40*cdf0e10cSrcweir import com.sun.star.uno.XInterface;
41*cdf0e10cSrcweir import com.sun.star.uno.UnoRuntime;
42*cdf0e10cSrcweir import com.sun.star.uno.XComponentContext;
43*cdf0e10cSrcweir import com.sun.star.lang.*;
44*cdf0e10cSrcweir 
45*cdf0e10cSrcweir // factory for creating components
46*cdf0e10cSrcweir import com.sun.star.comp.servicemanager.ServiceManager;
47*cdf0e10cSrcweir import com.sun.star.lang.XMultiServiceFactory;
48*cdf0e10cSrcweir import com.sun.star.bridge.XUnoUrlResolver;
49*cdf0e10cSrcweir import com.sun.star.uno.XNamingService;
50*cdf0e10cSrcweir import com.sun.star.frame.XDesktop;
51*cdf0e10cSrcweir import com.sun.star.frame.XComponentLoader;
52*cdf0e10cSrcweir 
53*cdf0e10cSrcweir // property access
54*cdf0e10cSrcweir import com.sun.star.beans.*;
55*cdf0e10cSrcweir 
56*cdf0e10cSrcweir // container access
57*cdf0e10cSrcweir import com.sun.star.container.*;
58*cdf0e10cSrcweir 
59*cdf0e10cSrcweir // application specific classes
60*cdf0e10cSrcweir import com.sun.star.sheet.XSpreadsheetDocument;
61*cdf0e10cSrcweir import com.sun.star.text.XTextDocument;
62*cdf0e10cSrcweir 
63*cdf0e10cSrcweir import com.sun.star.document.XEmbeddedObjectSupplier;
64*cdf0e10cSrcweir import com.sun.star.frame.XModel;
65*cdf0e10cSrcweir import com.sun.star.frame.XController;
66*cdf0e10cSrcweir 
67*cdf0e10cSrcweir // Exceptions
68*cdf0e10cSrcweir import com.sun.star.uno.RuntimeException;
69*cdf0e10cSrcweir import com.sun.star.container.NoSuchElementException;
70*cdf0e10cSrcweir import com.sun.star.beans.UnknownPropertyException;
71*cdf0e10cSrcweir import com.sun.star.lang.IndexOutOfBoundsException;
72*cdf0e10cSrcweir 
73*cdf0e10cSrcweir // __________ Implementation __________
74*cdf0e10cSrcweir 
75*cdf0e10cSrcweir /** Helper for creating a calc document adding cell values and charts
76*cdf0e10cSrcweir     @author Björn Milcke
77*cdf0e10cSrcweir  */
78*cdf0e10cSrcweir public class Helper
79*cdf0e10cSrcweir {
80*cdf0e10cSrcweir     public Helper( String[] args )
81*cdf0e10cSrcweir     {
82*cdf0e10cSrcweir         // connect to a running office and get the ServiceManager
83*cdf0e10cSrcweir         try {
84*cdf0e10cSrcweir             // get the remote office component context
85*cdf0e10cSrcweir             maContext = com.sun.star.comp.helper.Bootstrap.bootstrap();
86*cdf0e10cSrcweir             System.out.println("Connected to a running office ...");
87*cdf0e10cSrcweir 
88*cdf0e10cSrcweir             // get the remote office service manager
89*cdf0e10cSrcweir             maMCFactory = maContext.getServiceManager();
90*cdf0e10cSrcweir         }
91*cdf0e10cSrcweir         catch( Exception e) {
92*cdf0e10cSrcweir             System.out.println( "Couldn't get ServiceManager: " + e );
93*cdf0e10cSrcweir             e.printStackTrace();
94*cdf0e10cSrcweir             System.exit(1);
95*cdf0e10cSrcweir         }
96*cdf0e10cSrcweir     }
97*cdf0e10cSrcweir 
98*cdf0e10cSrcweir     // ____________________
99*cdf0e10cSrcweir 
100*cdf0e10cSrcweir     public XSpreadsheetDocument createSpreadsheetDocument()
101*cdf0e10cSrcweir     {
102*cdf0e10cSrcweir         return (XSpreadsheetDocument) UnoRuntime.queryInterface(
103*cdf0e10cSrcweir             XSpreadsheetDocument.class, createDocument( "scalc" ));
104*cdf0e10cSrcweir     }
105*cdf0e10cSrcweir 
106*cdf0e10cSrcweir     // ____________________
107*cdf0e10cSrcweir 
108*cdf0e10cSrcweir     public XModel createPresentationDocument()
109*cdf0e10cSrcweir     {
110*cdf0e10cSrcweir         return createDocument( "simpress" );
111*cdf0e10cSrcweir     }
112*cdf0e10cSrcweir 
113*cdf0e10cSrcweir     // ____________________
114*cdf0e10cSrcweir 
115*cdf0e10cSrcweir     public XModel createDrawingDocument()
116*cdf0e10cSrcweir     {
117*cdf0e10cSrcweir         return createDocument( "sdraw" );
118*cdf0e10cSrcweir     }
119*cdf0e10cSrcweir 
120*cdf0e10cSrcweir     // ____________________
121*cdf0e10cSrcweir 
122*cdf0e10cSrcweir     public XModel createTextDocument()
123*cdf0e10cSrcweir     {
124*cdf0e10cSrcweir         return createDocument( "swriter" );
125*cdf0e10cSrcweir     }
126*cdf0e10cSrcweir 
127*cdf0e10cSrcweir     // ____________________
128*cdf0e10cSrcweir 
129*cdf0e10cSrcweir     public XModel createDocument( String sDocType )
130*cdf0e10cSrcweir     {
131*cdf0e10cSrcweir         XModel aResult = null;
132*cdf0e10cSrcweir         try
133*cdf0e10cSrcweir         {
134*cdf0e10cSrcweir             XComponentLoader aLoader = (XComponentLoader)
135*cdf0e10cSrcweir                 UnoRuntime.queryInterface(XComponentLoader.class,
136*cdf0e10cSrcweir                 maMCFactory.createInstanceWithContext("com.sun.star.frame.Desktop",
137*cdf0e10cSrcweir                                                       maContext) );
138*cdf0e10cSrcweir 
139*cdf0e10cSrcweir             aResult = (XModel) UnoRuntime.queryInterface(
140*cdf0e10cSrcweir                 XModel.class,
141*cdf0e10cSrcweir                 aLoader.loadComponentFromURL( "private:factory/" + sDocType,
142*cdf0e10cSrcweir                                               "_blank",
143*cdf0e10cSrcweir                                               0,
144*cdf0e10cSrcweir                                               new PropertyValue[ 0 ] ) );
145*cdf0e10cSrcweir         }
146*cdf0e10cSrcweir         catch( Exception e )
147*cdf0e10cSrcweir         {
148*cdf0e10cSrcweir             System.err.println("Couldn't create Document of type "+ sDocType +": "+e);
149*cdf0e10cSrcweir             e.printStackTrace();
150*cdf0e10cSrcweir             System.exit( 0 );
151*cdf0e10cSrcweir         }
152*cdf0e10cSrcweir 
153*cdf0e10cSrcweir         return aResult;
154*cdf0e10cSrcweir     }
155*cdf0e10cSrcweir 
156*cdf0e10cSrcweir     public XComponentContext getComponentContext(){
157*cdf0e10cSrcweir         return maContext;
158*cdf0e10cSrcweir 
159*cdf0e10cSrcweir     }
160*cdf0e10cSrcweir 
161*cdf0e10cSrcweir     // __________ private members and methods __________
162*cdf0e10cSrcweir 
163*cdf0e10cSrcweir     private final String  msDataSheetName  = "Data";
164*cdf0e10cSrcweir     private final String  msChartSheetName = "Chart";
165*cdf0e10cSrcweir     private final String  msChartName      = "SampleChart";
166*cdf0e10cSrcweir 
167*cdf0e10cSrcweir     private XComponentContext      maContext;
168*cdf0e10cSrcweir     private XMultiComponentFactory maMCFactory;
169*cdf0e10cSrcweir     private XSpreadsheetDocument   maSpreadSheetDoc;
170*cdf0e10cSrcweir }
171