1 /**************************************************************
2  *
3  * Licensed to the Apache Software Foundation (ASF) under one
4  * or more contributor license agreements.  See the NOTICE file
5  * distributed with this work for additional information
6  * regarding copyright ownership.  The ASF licenses this file
7  * to you under the Apache License, Version 2.0 (the
8  * "License"); you may not use this file except in compliance
9  * with the License.  You may obtain a copy of the License at
10  *
11  *   http://www.apache.org/licenses/LICENSE-2.0
12  *
13  * Unless required by applicable law or agreed to in writing,
14  * software distributed under the License is distributed on an
15  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16  * KIND, either express or implied.  See the License for the
17  * specific language governing permissions and limitations
18  * under the License.
19  *
20  *************************************************************/
21 
22 
23 
24 package org.openoffice.test.tools;
25 
26 import com.sun.star.lang.XMultiServiceFactory;
27 import com.sun.star.lang.XComponent;
28 import com.sun.star.table.XCellRange;
29 import com.sun.star.container.XIndexAccess;
30 import com.sun.star.sheet.XSpreadsheetDocument;
31 import com.sun.star.sheet.XSpreadsheets;
32 import com.sun.star.uno.UnoRuntime;
33 
34 /**
35  * @author  frank.schoenheit@oracle.com
36  */
37 public class SpreadsheetDocument extends OfficeDocument
38 {
39     /** Creates a new blank spreadsheet document */
40     /* ------------------------------------------------------------------ */
SpreadsheetDocument( XMultiServiceFactory orb )41     public SpreadsheetDocument( XMultiServiceFactory orb ) throws com.sun.star.uno.Exception
42     {
43         super( orb, implLoadAsComponent( orb, "private:factory/scalc" ) );
44     }
45 
46     /* ------------------------------------------------------------------ */
SpreadsheetDocument( XMultiServiceFactory orb, XComponent document )47     public SpreadsheetDocument( XMultiServiceFactory orb, XComponent document ) throws com.sun.star.uno.Exception
48     {
49         super( orb, document );
50     }
51 
52     /* ------------------------------------------------------------------ */
53     /** returns the sheets collection
54     */
getSheets()55     public XSpreadsheets getSheets() throws com.sun.star.uno.Exception
56     {
57         XSpreadsheetDocument spreadsheetDoc = UnoRuntime.queryInterface( XSpreadsheetDocument.class, getDocument() );
58         return spreadsheetDoc.getSheets();
59     }
60 
61     /* ------------------------------------------------------------------ */
62     /** returns the sheet with the given index
63     */
getSheet( int index )64     public XCellRange getSheet( int index ) throws com.sun.star.uno.Exception
65     {
66         XIndexAccess sheets = UnoRuntime.queryInterface( XIndexAccess.class, getSheets() );
67         return UnoRuntime.queryInterface( XCellRange.class, sheets.getByIndex( index ) );
68     }
69 }
70