IChartDataWorkbook

IChartDataWorkbook interface

Provides access to embedded Excel workbook

public interface IChartDataWorkbook

Properties

NameDescription
Worksheets { get; }Gets a collection of worksheets.

Methods

NameDescription
CalculateFormulas()Calculates all formulas in the workbook and updates corresponding cells values.
Clear(int)Clear all cells values on sheet
GetCell(int, string)Gets the cell that can be used for chart series or categories
GetCell(int, int, int)Gets the cell that can be used for chart series or categories
GetCell(int, string, object)Gets the cell that can be used for chart series or categories
GetCell(string, int, int)Gets the cell that can be used for chart series or categories
GetCell(int, int, int, object)Gets the cell that can be used for chart series or categories
GetCellCollection(string, bool)Gets the set of cells.

See Also