| | Class | Description |
|---|
 | ExcelAutoFilter |
Represents the AutoFilter of a worksheet: the drop-down arrows in the header row of a range and the filters
set on its columns. Create it with AddAutoFilter and get it with AutoFilter.
A worksheet has at most one AutoFilter (the tables have their own). When a filter is set, the library hides
the rows of the range that do not meet the filters of all the columns, as Excel does; Excel keeps the filters
and lets the user change them. The first row of the range is the header row and is never hidden.
In the Excel 97-2003 format a column can be filtered by at most two values or two conditions. Formula cells are
compared by their calculated results (call UpdateFormulaResult first for the formulas added in code).
|
 | ExcelCellAlignment |
Represents the alignment style options of the text in a cell.
|
 | ExcelCellBorder |
Represents one of the borders of a range or style
|
 | ExcelCellBordersCollection |
Represents a collection of four borders of a Range or a Style. A border index can be used to identify the
Border object
|
 | ExcelCellFill |
Represents the interior style of a cell or range of cells.
|
 | ExcelCellFillGradient |
Represents a gradient fill options for a cell or range.
|
 | ExcelCellFillPattern |
Represents the pattern fill of a cell interior
|
 | ExcelCellFillSolid |
Represents the solid fill for a cell interior.
|
 | ExcelCellNumber |
Represents the number format options for a cell or a range of cells.
|
 | ExcelCellProtection |
Represents the protection options for a cell or a range of cells.
|
 | ExcelCellStyle |
Represents the style of a cell or a range of cells.
|
 | ExcelCellStylesCollection |
Represents a collection of cell styles. The ExcelWorkbook offers such a collection containing all the styles created in the workbook.
|
 | ExcelChart |
Represents a chart shape in a worksheet.
|
 | ExcelChartArea |
Represents an area in an Excel chart.
|
 | ExcelChartCategoryAxis |
Represents the category axis (horizontal axis) of a chart
|
 | ExcelChartDataPoint |
Represents a data point in the chart.
|
 | ExcelChartDataPointLabel |
Represents the label of a chart data point
|
 | ExcelChartDataPointsCollection |
Represents a collection of data points in a chart series
|
 | ExcelChartDataTable |
Represents the formatting options for the chart data table.
|
 | ExcelChartFormattedText |
Represents a formatted text area in a chart.
|
 | ExcelChartInterior |
Represents the interior of a chart element
|
 | ExcelChartLegend |
Represents the legend of a chart.
|
 | ExcelChartLegendEntriesCollection |
Represents the collection of legend entries for a picture.
|
 | ExcelChartLegendEntry |
Represents and entry in the chart legend.
|
 | ExcelChartLine |
Represents the border of a chart element
|
 | ExcelChartRotation3D |
Represents the rotation properties for a 3D chart.
|
 | ExcelChartsCollection |
Represents the collection of charts in a worksheet
|
 | ExcelChartSeries |
Represents a data series in a Excel chart
|
 | ExcelChartSeriesAxis |
Represents the series axis (depth axis) of a chart
|
 | ExcelChartSeriesCollection |
Represents a collection of chart series.
|
 | ExcelChartValueAxis |
Represents the value axis (vertical axis) of a chart
|
 | ExcelChartWorksheet |
Represents a chart worksheet.
|
 | ExcelChartWorksheetPageSetup |
Represents the chart worksheet page setup
|
 | ExcelChartWorksheetsCollection |
Represents a colection of chart worksheets in a workbook.
|
 | ExcelColorsPalette |
Represents the Excel colors palette.
|
 | ExcelComment |
Represents a comment in a mec.
|
 | ExcelCommentsCollection |
Represents a collection of comments in a worksheet
|
 | ExcelConditionalFormat |
Represents a conditional format rule of a range of cells. The rules are created with the methods of the
ExcelConditionalFormatsCollection returned by ConditionalFormats.
The font, fill and border properties apply to the cell value and formula rules; the data bar and icon
set properties apply only to the rules of these types.
|
 | ExcelConditionalFormatsCollection |
Represents the conditional format rules of a range of cells, returned by ConditionalFormats.
The rules are evaluated by Excel when the workbook is displayed: cell value and formula rules change the font,
fill and borders of the cells that meet the condition; color scales, data bars and icon sets visualize the
cell values. All the rule types are supported in the Excel 97-2003 (.xls) and Excel 2007+ (.xlsx) formats.
|
 | ExcelDataValidator |
Represents a data type validator for a range of cells.
|
 | ExcelDocumentProperties |
The document properties like title, subject, keywords, author, etc.
|
 | ExcelDocumentSecurity |
Manage the document security like workbook structure and windows protection, open/write password protection.
|
 | ExcelFont |
Represents a font in the Excel workbook
|
 | ExcelHyperlink |
Represents a hyperlink in the worksheet hyperlinks collection.
|
 | ExcelHyperlinksCollection |
Represents a collection of hyperlinks
|
 | ExcelLibException |
Exception thrown by the Excel library
|
 | ExcelNamedRange |
Represents a named range in a worksheet. Named ranges can be added to the worksheet or workbook named ranges collection.
|
 | ExcelNamedRangesCollection |
Represents a collection of named ranges. The ExcelWorksheet and ExcelWorkbook define such collections.
|
 | ExcelPageBreak |
Represents a horizontal or vertical page break in worksheet
|
 | ExcelPageBreaksCollection |
Represents a collection of page breaks.
|
 | ExcelPageSetup |
Represents the Excel page setup.
|
 | ExcelPicture |
Represents a picture in a worksheet.
|
 | ExcelPicturesCollection |
Represents a collection of picture in a worksheet.
|
 | ExcelRange |
Represents a range of cells in a worksheet
|
 | ExcelRangesCollection |
Represents a collection of ranges in a worksheet.
|
 | ExcelShapeFill |
Represents the interior of a shape
|
 | ExcelShapeFillGradient |
Represents a gradient fill options for a shape.
|
 | ExcelShapeFillPattern |
Represents the pattern fill of a shape interior.
|
 | ExcelShapeFillPicture |
Represents a picture fill of a shape interior.
|
 | ExcelShapeFillSolid |
Represents the solid fill for a shape interior.
|
 | ExcelShapeFillTexture |
Represents the texture fill of a shape interior.
|
 | ExcelSortKey |
A column to sort by and its order, used by Sort(ExcelSortKey, Boolean).
|
 | ExcelSparklineGroup |
Represents a group of sparklines: small charts drawn in cells, one for each row or column of a data range,
that share the same type, colors and markers. Create it with Add(ExcelSparklineType, ExcelRange, ExcelRange)
of SparklineGroups. Sparklines are available only in the Excel 2007+ (.xlsx)
format and are displayed by Excel 2010 and later.
|
 | ExcelSparklineGroupsCollection |
Represents the sparkline groups of a worksheet, returned by SparklineGroups.
Sparklines are available only in the Excel 2007+ (.xlsx) format and are displayed by Excel 2010 and later;
the Excel 97-2003 format cannot store them.
|
 | ExcelTable |
Represents an Excel table (a list object): a range of cells with a header row, a table style, filter buttons in
the header row and an optional totals row. Create it with Add(String, ExcelRange) of
Tables. Excel tables are available only in the Excel 2007+ (.xlsx) format.
|
 | ExcelTableColumn |
Represents a column of an Excel table.
|
 | ExcelTableColumnsCollection |
Represents the columns of an Excel table.
|
 | ExcelTablesCollection |
Represents the Excel tables of a worksheet, returned by Tables.
Excel tables are available only in the Excel 2007+ (.xlsx) format; in an Excel 97-2003 workbook use
AddAutoFilter for the filter buttons and cell styles for the formatting.
|
 | ExcelUnitsConverter |
Utility class to convert between various Excel measurement units (points, pixels, width characters)
|
 | ExcelWorkbook |
The Excel Workbook
|
 | ExcelWorkbookDefaultSettings |
A class encapsulating the default options (font, row height, column width) for a newly created workbook.
|
 | ExcelWorksheet |
Excel Worksheet
|
 | ExcelWorksheetPageSetup |
Represents the Excel page setup for a worksheet.
|
 | ExcelWorksheetsCollection |
Represents the collection of Excel worksheets in a workbook
|
 | ExcelWorksheetSecurity |
Manages the security options for a worksheet.
|