Expert |
The root namespace of the EpertXls Excel Library for .NET
Classes| Class | Description | |
|---|---|---|
 | 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 |
| 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. |
| 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. |
Enumerations| Enumeration | Description | |
|---|---|---|
 | ExcelCellBorderIndex | Specifies the index of the border to be retrieved from a borders collection. |
| ExcelCellFillPatternType | The interior pattern of a cell |
| ExcelCellFillType | Represents the type of interior for cell or range of cells. |
| ExcelCellHorizontalAlignmentType | The horizontal alignment of data in a cell |
| ExcelCellLineStyle | Enumeration of the border line styles for cells in Excel. |
| ExcelCellTextDirectionType | Specifies the reading order for the cell |
| ExcelCellUnderlineType | Represents the underline style of the text in a cell |
| ExcelCellVerticalAlignmentType | The vertical alignment of data in a cell |
| ExcelChartAxisLabelPosition | Represents the axis labels position from the chart axis |
| ExcelChartCategoryAxisType | Represents the type of the category axis of a chart |
| ExcelChartLegendPosition | Represents the chart legend position in chart area. |
| ExcelChartLineType | Represents the type of line for a chart element border. |
| ExcelChartLineWeightType | Represents the weight of a chart border line |
| ExcelChartTickMarkType | Represents the chart axis tick marks type |
| ExcelChartTimeUnit | Represents the time unit for category axis |
| ExcelChartType | Enumeration of the Chart types in Excel. |
| ExcelChartValueDisplayUnits | The display units for the value axis. |
| ExcelDataValidatorDataType | Represents the data types allowed by a data validator. |
| ExcelDataValidatorErrorStyle | Represents the style of the error alert for data validator. |
| ExcelDataValidatorOperator | Represents a comparison operator used by a data validator. |
| ExcelDeleteShiftDirection | Describes how the cells are shifted to replace deleted cells. |
| ExcelGradientColors | Represents the colors mode of a gradient |
| ExcelGradientDirection | Represents the possible directions of the gradient |
| ExcelGradientVariants | Represents the variants for a gradient direction. |
| ExcelGroupBy | Describes how to group the range. |
| ExcelHyperlinkType | Represents the type of URL in a worksheet. |
| ExcelNamedRangeScopeType | Represents the scope of a named range. |
| ExcelPageBreakType | Represents the type of pae break (horizontal or vertical). |
| ExcelPageOrientation | Represents the page orientation of a worksheet. |
| ExcelPagePaperSize | Represents the paper size for an Excel document. |
| ExcelPagePrintCommLocation | Represents the location where the comments in a worksheet will be printed. |
| ExcelPagePrintErrorsMode | Represents the mode of printing errors. |
| ExcelPagePrintOrder | Specifies the order in which cells are processed. |
| ExcelPicturePlacement | Represents how the picture is attached to the cells below it. |
| ExcelProtectionAllowFlags | The allowed operations for a protected worksheet. |
| ExcelShapeFillPatternType | Represents the possible patterns of shape interior. |
| ExcelShapeFillPresetGradientType | Represents the available preset gradients |
| ExcelShapeFillTextureType | Represents the possible textures of the shape interior. |
| ExcelShapeFillType | Represents the type of interior of a shape. |
| ExcelWorkbookFormat | The Excel workbook format |