com.aspose.slides

Interfaces

Classes

Exceptions

com.aspose.slides

Interface IChartDataWorkbook

  • All Known Implementing Classes:
    ChartDataWorkbook


    public interface IChartDataWorkbook

    Provides access to embedded Excel workbook

    • Method Summary

      All Methods Instance Methods Abstract Methods 
      Modifier and Type Method and Description
      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.
        Returns:
        Set of cells IChartCellCollection
      • 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