com.aspose.slides
Interface IChartDataWorkbook

All Known Implementing Classes:
ChartDataWorkbook

public interface IChartDataWorkbook

Provides access to embedded Excel workbook


Method Summary
 void clear(int sheetIndex)
           Clear all cells values on sheet
 IChartDataCell getCell(int worksheetIndex, int row, int column)
           Gets the cell that can be used for chart series or categories
 IChartDataCell getCell(int worksheetIndex, int row, int column, java.lang.Object value)
           Gets the cell that can be used for chart series or categories
 IChartDataCell getCell(int worksheetIndex, java.lang.String cellName)
           Gets the cell that can be used for chart series or categories
 IChartDataCell getCell(int worksheetIndex, java.lang.String cellName, java.lang.Object value)
           Gets the cell that can be used for chart series or categories
 IChartDataCell getCell(java.lang.String worksheetName, int row, int column)
           Gets the cell that can be used for chart series or categories
 IChartCellCollection getCellCollection(java.lang.String formula, boolean skipHiddenCells)
           Gets the set of cells.
 

Method Detail

getCellCollection

IChartCellCollection getCellCollection(java.lang.String formula,
                                       boolean skipHiddenCells)

Gets the set of cells.

Parameters:
formula - Excel formula like "Sheet1!$A$2:$A$5".
skipHiddenCells - If true then method returns collection without hidden cells.

getCell

IChartDataCell getCell(java.lang.String worksheetName,
                       int row,
                       int column)

Gets the cell that can be used for chart series or categories

Parameters:
worksheetName - Name of the worksheet.
row - The row.
column - The column.
Returns:
Cell object

getCell

IChartDataCell getCell(int worksheetIndex,
                       int row,
                       int column)

Gets the cell that can be used for chart series or categories

Parameters:
worksheetIndex - Index of the worksheet.
row - The row.
column - The column.
Returns:
Cell object

getCell

IChartDataCell getCell(int worksheetIndex,
                       java.lang.String cellName)

Gets the cell that can be used for chart series or categories

Parameters:
worksheetIndex - Index of the worksheet.
cellName - Name of the cell.
Returns:
Cell object

getCell

IChartDataCell getCell(int worksheetIndex,
                       java.lang.String cellName,
                       java.lang.Object value)

Gets the cell that can be used for chart series or categories

Parameters:
worksheetIndex - Index of the worksheet.
cellName - Name of the cell.
value - The value.
Returns:
Cell object

getCell

IChartDataCell getCell(int worksheetIndex,
                       int row,
                       int column,
                       java.lang.Object value)

Gets the cell that can be used for chart series or categories

Parameters:
worksheetIndex - Index of the worksheet.
row - The row.
column - The column.
value - The value.
Returns:
Cell object

clear

void clear(int sheetIndex)

Clear all cells values on sheet

Parameters:
sheetIndex - Index of sheet


Copyright © Copyright 2004-2016 Aspose Pty Ltd. All Rights Reserved.