/* -*- Mode: Java; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ /************************************************************************* * * The Contents of this file are made available subject to the terms of * the BSD license. * * Copyright 2000, 2010 Oracle and/or its affiliates. * All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions * are met: * 1. Redistributions of source code must retain the above copyright * notice, this list of conditions and the following disclaimer. * 2. Redistributions in binary form must reproduce the above copyright * notice, this list of conditions and the following disclaimer in the * documentation and/or other materials provided with the distribution. * 3. Neither the name of Sun Microsystems, Inc. nor the names of its * contributors may be used to endorse or promote products derived * from this software without specific prior written permission. * * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS * FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE * COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, * INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, * BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS * OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR * TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE * USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. *
*************************************************************************/
// comment: Step 1: get the remote component context from the office // Step 2: open an empty calc document // Step 3: create cell styles // Step 4: get the sheet an insert some data // Step 5: apply the created cell styles // Step 6: insert a 3D Chart
//oooooooooooooooooooooooooooStep 1oooooooooooooooooooooooooooooooooooooooooo // call UNO bootstrap method and get the remote component context form // the a running office (office will be started if necessary)
XComponentContext xContext = null;
// get the remote office component context try {
xContext = com.sun.star.comp.helper.Bootstrap.bootstrap();
System.out.println("Connected to a running office ...");
} catch( Exception e) {
e.printStackTrace(System.err);
System.exit(1);
}
//oooooooooooooooooooooooooooStep 2oooooooooooooooooooooooooooooooooooooooooo // open an empty document. In this case it's a calc document. // For this purpose an instance of com.sun.star.frame.Desktop // is created. The desktop provides the XComponentLoader interface, // which is used to open the document via loadComponentFromURL
System.out.println("Opening an empty Calc document");
myDoc = openCalc(xContext);
//oooooooooooooooooooooooooooStep 3oooooooooooooooooooooooooooooooooooooooooo // create cell styles. // For this purpose get the StyleFamiliesSupplier and the family // CellStyle. Create an instance of com.sun.star.style.CellStyle and // add it to the family. Now change some properties
//oooooooooooooooooooooooooooStep 4oooooooooooooooooooooooooooooooooooooooooo // get the sheet an insert some data. // Get the sheets from the document and then the first from this container. // Now some data can be inserted. For this purpose get a Cell via // getCellByPosition and insert into this cell via setValue() (for floats) // or setFormula() for formulas and Strings
//oooooooooooooooooooooooooooStep 5oooooooooooooooooooooooooooooooooooooooooo // apply the created cell style. // For this purpose get the PropertySet of the Cell and change the // property CellStyle to the appropriate value.
//oooooooooooooooooooooooooooStep 6oooooooooooooooooooooooooooooooooooooooooo // insert a 3D chart. // get the CellRange which holds the data for the chart and its RangeAddress // get the TableChartSupplier from the sheet and then the TableCharts from it. // add a new chart based on the data to the TableCharts. // get the ChartDocument, which provide the Diagram. Change the properties // Dim3D (3 dimension) and String (the title) of the diagram.
Die Informationen auf dieser Webseite wurden
nach bestem Wissen sorgfältig zusammengestellt. Es wird jedoch weder Vollständigkeit, noch Richtigkeit,
noch Qualität der bereit gestellten Informationen zugesichert.
Bemerkung:
Die farbliche Syntaxdarstellung ist noch experimentell.
