127 lines
5.5 KiB
Java
127 lines
5.5 KiB
Java
/*
|
|
* This file is part of the LibreOffice project.
|
|
*
|
|
* This Source Code Form is subject to the terms of the Mozilla Public
|
|
* License, v. 2.0. If a copy of the MPL was not distributed with this
|
|
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
|
|
*
|
|
* This file incorporates work covered by the following license notice:
|
|
*
|
|
* Licensed to the Apache Software Foundation (ASF) under one or more
|
|
* contributor license agreements. See the NOTICE file distributed
|
|
* with this work for additional information regarding copyright
|
|
* ownership. The ASF licenses this file to you under the Apache
|
|
* License, Version 2.0 (the "License"); you may not use this file
|
|
* except in compliance with the License. You may obtain a copy of
|
|
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
|
|
*/
|
|
|
|
package util;
|
|
|
|
import com.sun.star.container.XIndexAccess;
|
|
import com.sun.star.lang.IllegalArgumentException;
|
|
import com.sun.star.lang.IndexOutOfBoundsException;
|
|
import com.sun.star.lang.WrappedTargetException;
|
|
import com.sun.star.lang.XComponent;
|
|
import com.sun.star.sheet.XCellRangeData;
|
|
import com.sun.star.sheet.XSpreadsheet;
|
|
import com.sun.star.sheet.XSpreadsheetDocument;
|
|
import com.sun.star.sheet.XSpreadsheets;
|
|
import com.sun.star.table.XCellRange;
|
|
import com.sun.star.uno.AnyConverter;
|
|
import com.sun.star.uno.Exception;
|
|
import com.sun.star.uno.Type;
|
|
import com.sun.star.uno.UnoRuntime;
|
|
|
|
/**
|
|
* This class contains some useful methods to handle Calc documents
|
|
* and its sheets.
|
|
*/
|
|
public class CalcTools {
|
|
|
|
/**
|
|
* fills a range of a calc sheet with computed data of type
|
|
* <CODE>Double</CODE>.
|
|
* @param xSheetDoc the Calc documents which should be filled
|
|
* @param sheetNumber the number of the sheet of <CODE>xSheetDoc</CODE>
|
|
* @param startCellX the cell number of the X start point (row) of the range to fill
|
|
* @param startCellY the cell number of the Y start point (column) of the range to fill
|
|
* @param rangeLengthX the size of the range expansion in X-direction
|
|
* @param rangeLengthY the size of the range expansion in Y-direction
|
|
* @throws java.lang.Exception on any error an <CODE>java.lang.Exception</CODE> was thrown
|
|
*/
|
|
public static void fillCalcSheetWithContent(XComponent xSheetDoc, int sheetNumber,
|
|
int startCellX, int startCellY, int rangeLengthX, int rangeLengthY)
|
|
throws java.lang.Exception {
|
|
XSpreadsheet xSheet = getSpreadSheetFromSheetDoc(xSheetDoc, sheetNumber);
|
|
|
|
fillCalcSheetWithContent(xSheet, startCellX, startCellY, rangeLengthX, rangeLengthY);
|
|
}
|
|
|
|
/**
|
|
* fills a range of a calc sheet with computed data of type
|
|
* <CODE>Double</CODE>.
|
|
* @param xSheet the sheet to fill with content
|
|
* @param startCellX the cell number of the X start point (row) of the range to fill
|
|
* @param startCellY the cell number of the Y start point (column) of the range to fill
|
|
* @param rangeLengthX the size of the range expansion in X-direction
|
|
* @param rangeLengthY the size of the range expansion in Y-direction
|
|
* @throws java.lang.Exception on any error an <CODE>java.lang.Exception</CODE> was thrown
|
|
*/
|
|
public static void fillCalcSheetWithContent(XSpreadsheet xSheet,
|
|
int startCellX, int startCellY, int rangeLengthX, int rangeLengthY)
|
|
throws java.lang.Exception {
|
|
// create a range with content
|
|
Object[][] newData = new Object[rangeLengthY][rangeLengthX];
|
|
for (int i=0; i<rangeLengthY; i++) {
|
|
for (int j=0; j<rangeLengthX; j++) {
|
|
newData[i][j] = Double.valueOf(10*i +j);
|
|
}
|
|
}
|
|
XCellRange xRange = null;
|
|
try {
|
|
xRange = xSheet.getCellRangeByPosition(startCellX, startCellY,
|
|
startCellX+rangeLengthX-1, startCellY+rangeLengthY-1);
|
|
} catch ( IndexOutOfBoundsException ex){
|
|
throw new Exception(ex, "Couldn't get CellRange from sheet");
|
|
}
|
|
|
|
XCellRangeData xRangeData = UnoRuntime.queryInterface(XCellRangeData.class, xRange);
|
|
|
|
xRangeData.setDataArray(newData);
|
|
}
|
|
|
|
/**
|
|
*
|
|
* returns an <CODE>XSpreadsheet</CODE> from a Calc document.
|
|
* @param xSheetDoc the Calc document which contains the sheet
|
|
* @param sheetNumber the number of the sheet to return
|
|
* @throws java.lang.Exception on any error an <CODE>java.lang.Exception</CODE> was thrown
|
|
* @return calc sheet
|
|
* @see com.sun.star.sheet.XSpreadsheet
|
|
*/
|
|
private static XSpreadsheet getSpreadSheetFromSheetDoc(XComponent xSheetDoc, int sheetNumber)
|
|
throws java.lang.Exception {
|
|
|
|
XSpreadsheet xSheet = null;
|
|
|
|
try{
|
|
XSpreadsheetDocument xSpreadsheetDoc = UnoRuntime.queryInterface(XSpreadsheetDocument.class, xSheetDoc);
|
|
|
|
XSpreadsheets xSpreadsheets = xSpreadsheetDoc.getSheets();
|
|
|
|
XIndexAccess xSheetsIndexArray = UnoRuntime.queryInterface(XIndexAccess.class, xSpreadsheets);
|
|
|
|
xSheet = (XSpreadsheet) AnyConverter.toObject(
|
|
new Type(XSpreadsheet.class),xSheetsIndexArray.getByIndex(sheetNumber));
|
|
|
|
} catch (IllegalArgumentException ex){
|
|
throw new Exception(ex, "Couldn't get sheet '" +sheetNumber + "'");
|
|
} catch (IndexOutOfBoundsException ex){
|
|
throw new Exception(ex, "Couldn't get sheet '" +sheetNumber + "'");
|
|
} catch (WrappedTargetException ex) {
|
|
throw new Exception(ex, "Couldn't get sheet '" +sheetNumber + "'");
|
|
}
|
|
return xSheet;
|
|
}
|
|
}
|