com.aspose.slides
Class ChartDataWorkbook

java.lang.Object
  extended by com.aspose.slides.ChartDataWorkbook
All Implemented Interfaces:
IChartDataWorkbook

public class ChartDataWorkbook
extends java.lang.Object
implements 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.
 com.aspose.slides.IDOMObject getParent_Immediate()
           Returns Parent_Immediate object.
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Method Detail

getCellCollection

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

Gets the set of cells.

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

getCell

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

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

Specified by:
getCell in interface IChartDataWorkbook
Parameters:
worksheetName - Name of the worksheet.
row - The row.
column - The column.
Returns:
Cell object

getCell

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

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

Specified by:
getCell in interface IChartDataWorkbook
Parameters:
worksheetIndex - Index of the worksheet.
row - The row.
column - The column.
Returns:
Cell object

getCell

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

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

Specified by:
getCell in interface IChartDataWorkbook
Parameters:
worksheetIndex - Index of the worksheet.
cellName - Name of the cell.
Returns:
Cell object

getCell

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

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

Specified by:
getCell in interface IChartDataWorkbook
Parameters:
worksheetIndex - Index of the worksheet.
cellName - Name of the cell.
value - The value.
Returns:
Cell object

getCell

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

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

Specified by:
getCell in interface IChartDataWorkbook
Parameters:
worksheetIndex - Index of the worksheet.
row - The row.
column - The column.
value - The value.
Returns:
Cell object

clear

public void clear(int sheetIndex)

Clear all cells values on sheet

Specified by:
clear in interface IChartDataWorkbook
Parameters:
sheetIndex - Index of sheet

getParent_Immediate

public com.aspose.slides.IDOMObject getParent_Immediate()

Returns Parent_Immediate object. Read-only IDOMObject.



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