On 10/18/10 07:51, Pivithuru Wijegunawardana wrote:
You can use com.sun.star.sheet.XCellRangeAddressable interface and CellRangeAddress.com.sun.star.sheet.XCellRangeAddressable xRangeAddr = (com.sun.star.sheet.XCellRangeAddressable) UnoRuntime.queryInterface(com.sun.star.sheet.XCellRangeAddressable.class, xCellRange); CellRangeAddress aRangeAddress = xRangeAddr.getRangeAddress(); From aRangeAddress you can get details about range start column,start row and range end column,end row. Then you can get the no of columns and rows you have in the range int noOfColums = aRangeAddress.EndColumn - aRangeAddress.StartColumn + 1; int noOfRows = aRangeAddress.EndRow - aRangeAddress.StartRow + 1; Then traverse through the range using this and you can get all the cells inside the given range. for (int i = 0; i< noOfColums; i++) { for (int j = 0; j< noOfRows; j++) { XCell cell = xCellRange.getCellByPosition(i, j); }
Or if the parameter has a type like "sequence< sequence< double > >" in IDL, which is "double[][]" in Java, you can just use "length" to access the array's length.
Niklas --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
