IExcelDataWorkbook class

IExcelDataWorkbook class

Represents a workbook that provides access to Excel data for general use.

The IExcelDataWorkbook type exposes the following members:

Methods

MethodDescription
get_cellRetrieves a cell from the specified worksheet using its index and cell coordinates.
get_cellRetrieves a cell from the specified worksheet using its name and cell coordinates.
get_cellRetrieves a cell from the specified worksheet using its index and Excel-style cell name (e.g., “B2”).
get_cellRetrieves a cell from the specified worksheet using Excel-style cell name (e.g., “B2”).
get_cellsRetrieves a collection of cells from the workbook that match the specified formula.
get_charts_from_worksheetRetrieves a dictionary containing the indexes and names of all charts in the specified worksheet of an Excel workbook.
get_worksheet_namesRetrieves the names of all worksheets contained in the Excel workbook.

See Also