Difference between revisions of "Documentation/DevGuide/Spreadsheets/Example: Adding a New Spreadsheet"

From Apache OpenOffice Wiki
Jump to: navigation, search
(correct code snippet)
 
Line 8: Line 8:
 
  {{DISPLAYTITLE:Example: Adding a New Spreadsheet}}
 
  {{DISPLAYTITLE:Example: Adding a New Spreadsheet}}
 
The following helper method opens a new spreadsheet document component. The method <code>getRemoteServiceManager()</code> retrieves a connection. Refer to chapter [[Documentation/DevGuide/FirstSteps/First Steps|First Steps]] for additional information.
 
The following helper method opens a new spreadsheet document component. The method <code>getRemoteServiceManager()</code> retrieves a connection. Refer to chapter [[Documentation/DevGuide/FirstSteps/First Steps|First Steps]] for additional information.
−
 
+
<syntaxhighlight lang="java">
 
   import com.sun.star.lang.XComponent;
 
   import com.sun.star.lang.XComponent;
 
   import com.sun.star.frame.XComponentLoader;
 
   import com.sun.star.frame.XComponentLoader;
Line 25: Line 25:
 
       return xComponentLoader.loadComponentFromURL(loadUrl, "_blank", 0, loadProps);  
 
       return xComponentLoader.loadComponentFromURL(loadUrl, "_blank", 0, loadProps);  
 
   }
 
   }
−
 
+
</syntaxhighlight>
 
Our helper returns a <idl>com.sun.star.lang.XComponent</idl> interface for the recently loaded document. Now the XComponent is passed to the following method <code>insertSpreadsheet()</code> to add a new spreadsheet to our document.  
 
Our helper returns a <idl>com.sun.star.lang.XComponent</idl> interface for the recently loaded document. Now the XComponent is passed to the following method <code>insertSpreadsheet()</code> to add a new spreadsheet to our document.  
 
<!--[SOURCE:Spreadsheet/SpreadsheetDocHelper.java]-->
 
<!--[SOURCE:Spreadsheet/SpreadsheetDocHelper.java]-->
−
 
+
<syntaxhighlight lang="java">
 
   import com.sun.star.sheet.XSpreadsheetDocument;
 
   import com.sun.star.sheet.XSpreadsheetDocument;
 
   import com.sun.star.sheet.XSpreadsheet;  
 
   import com.sun.star.sheet.XSpreadsheet;  
Line 57: Line 57:
 
       return xSheet;
 
       return xSheet;
 
   }
 
   }
−
 
+
</syntaxhighlight>
 
{{PDL1}}
 
{{PDL1}}
  
 
[[Category:Documentation/Developer's Guide/Spreadsheet Documents]]
 
[[Category:Documentation/Developer's Guide/Spreadsheet Documents]]

Latest revision as of 15:01, 3 January 2021



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).
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/DevGuide/Spreadsheets/Example:_Adding_a_New_Spreadsheet&oldid=246937"
Personal tools
In other languages