Example: Adding a New Spreadsheet

OpenOffice.org Developer's Guide

Spreadsheet Documents

< Previous Section

Next Section >

• Example: Adding a New Spreadsheet
• Example: Editing Spreadsheet Cells

• Handling Spreadsheet Documents Files

• Saving Spreadsheet Documents

• Filter Options

• Printing Spreadsheet Documents

• Working With Spreadsheet Documents

• Spreadsheet Services - Overview

• Capabilities of Spreadsheet
• Capabilities of SheetCellRange
• Capabilities of SheetCell
• Capabilities of SheetCellRanges Container
• Capabilities of Columns and Rows

• Spreadsheet
• Cell Ranges

• Properties of Cell Ranges
• Cell and Cell Range Access
• Merging Cell Ranges into a Single Cell
• Column and Row Access
• Data Array
• Absolute Address
• Fill Series
• Operations
• Multiple Operations
• Handling Array Formulas

• Cells

• Properties of SheetCell
• Access to Formulas, Values and Errors
• Access to Text Content
• Absolute Address
• Cell Annotations

• Cell Ranges and Cells Container
• Columns and Rows

• Formatting

• Character and Paragraph Format
• Indentation
• Equally Formatted Cell Ranges
• Table Auto Formats
• Conditional Formats

• Navigating

• Cell Cursor
• Referencing Ranges by Name
• Named Ranges
• Label Ranges
• Querying for Cells with Specific Properties
• Search and Replace

• Sorting
• Database Operations

• Filtering
• Subtotals
• Database Import
• Database Ranges

• Linking External Data

• Sheet Links
• Cell Area Links
• DDE Links

• DataPilot Tables

• Creating a New DataPilot Table
• Modifying a DataPilot Table
• Removing a DataPilot Table

• DataPilot Sources

• Source Object
• Dimensions
• Hierarchies
• Levels
• Members

• Protecting Spreadsheets
• Sheet Outline
• Detective
• Other Table Operations

• Overall Document Features

• Function Handling
• Settings

• Spreadsheet Document Controller

• View Panes
• View Settings
• Range Selection

• Spreadsheet Add-Ins

• Function Descriptions
• Service Names
• Compatibility Names
• Custom Functions
• Variable Results

< Previous Page

Next Page >

The following helper method opens a new spreadsheet document component. The method getRemoteServiceManager() retrieves a connection. Refer to chapter First Steps for additional information.

  import com.sun.star.lang.XComponent;
  import com.sun.star.frame.XComponentLoader;
  import com.sun.star.beans.PropertyValue;
 
  ...
 
  protected XComponent newSpreadsheetComponent() throws java.lang.Exception {
      String loadUrl = "private:factory/scalc";
      xRemoteServiceManager = this.getRemoteServiceManager(unoUrl);
      Object desktop = xRemoteServiceManager.createInstanceWithContext(
          "com.sun.star.frame.Desktop", xRemoteContext);
      XComponentLoader xComponentLoader = (XComponentLoader)UnoRuntime.queryInterface(
          XComponentLoader.class, desktop);
      PropertyValue[] loadProps = new PropertyValue[0];
      return xComponentLoader.loadComponentFromURL(loadUrl, "_blank", 0, loadProps); 
  }

Our helper returns a com.sun.star.lang.XComponent interface for the recently loaded document. Now the XComponent is passed to the following method insertSpreadsheet() to add a new spreadsheet to our document.

  import com.sun.star.sheet.XSpreadsheetDocument;
  import com.sun.star.sheet.XSpreadsheet; 
 
  ...
 
  /** Inserts a new empty spreadsheet with the specified name.
      @param xSheetComponent The XComponent interface of a loaded document object
      @param aName The name of the new sheet.
      @param nIndex The insertion index.
      @return The XSpreadsheet interface of the new sheet.
   */
  public XSpreadsheet insertSpreadsheet(XComponent xSheetComponent, String aName, short nIndex) {
      XSpreadsheetDocument xDocument = (XSpreadsheetDocument)UnoRuntime.queryInterface(
          XSpreadsheetDocument.class, xSheetComponent);
 
      // Collection of sheets
      com.sun.star.sheet.XSpreadsheets xSheets = xDocument.getSheets();
      com.sun.star.sheet.XSpreadsheet xSheet = null;
 
      try {
          xSheets.insertNewByName(aName, nIndex);
          xSheet = (com.sun.star.sheet.XSpreadsheet) UnoRuntime.queryInterface(
              com.sun.star.sheet.XSpreadsheet.class, xSheets.getByName(aName));
      } catch (Exception ex) {
      }
 
      return xSheet;
  }

Content on this page is licensed under the Public Documentation License (PDL).