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