Classes
| Class | Description | |
|---|---|---|
 | AbsoluteAnchor | Represents an absolute anchor |
| AlignmentBlock | Defines properties related to alignment settings. |
| BuiltInExcelStyles | Represents all excel built-in styles. |
| BuiltInName | A class implements IFunction used to represents An interface used to represents built-in name used in Excel |
| CalculationProperty | This class represents all properties related to excel calculation settings. |
| ColorScheme | A class implements IColorScheme represents color scheme used for excel theme |
| CustomExcelStyle | A class implements IExcelStyle used to represents custom cell style. |
| DifferentialFormatting | Represent formatting properties that are used in various features to modify cell formatting |
| Excel2010DataBarRule | Represents new excel 2010 DataBar rule. |
| Excel2010DataValidation | Represents excel 2010 new supported data validation which has at least one external reference formula. |
| ExcelAutoFilter | A class implements interface IExcelAutoFilter |
| ExcelBorder | Represent the border settings used in ExtendedFormat |
| ExcelBorderSide | Represent the border line properties. |
| ExcelCalcError | Represents Excel calc errors |
| ExcelCell | Represent a cell in the IExcelWorksheet. |
| ExcelCellRange | A class implements IRange used to represents a range |
| ExcelColor | Represents color used in Excel |
| ExcelColorFilter | A class implements interface IExcelColorFilter |
| ExcelColorScaleRule | Represents an icon set conditional formatting rule. |
| ExcelColumn | Represent a excel column in ExcelWorksheet |
| ExcelConditionalFormat | Represent a conditional formatting conditions |
| ExcelConditionalFormatValueObject | Describes the values of the interpolation points in a gradient scale |
| ExcelCustomFilter | A class implements interface IExcelCustomFilter |
| ExcelCustomFilters | A class implements interface IExcelCustomFilters |
| ExcelCustomFunction | A class implements IFunction used to represents a custom function |
| ExcelDataBarRule | Describes a data bar conditional formatting rule. |
| ExcelDataValidation | A class implements IExcelDataValidation used to represents the data validation settings used in Excel. |
| ExcelDateGroupItem | A class implements interface IExcelDateGroupItem |
| ExcelDynamicFilter | A class implement interface IExcelDynamicFilter |
| ExcelFilterColumn | A class implements interface IExcelFilterColumn |
| ExcelFilters | An class implements interface IExcelFilters |
| ExcelFont | Represent the Excel Font settings. |
| ExcelFormula | A class implements IExcelFormula, used to represent formula in Excel |
| ExcelGeneralRule | A class implements IExcelGeneralRule represents a general conditional formatting rule. |
| ExcelHighlightingRule | Represents a highlighting rule |
| ExcelHyperLink | Represents the hyperlink in excel. Every hyperlink can contain a text mark and a description that is show in the sheet instead of the read link. |
| ExcelIconFilter | A class implements interface IExcelIconFilter |
| ExcelIconSetsRule | Describes an icon set conditional formatting rule. |
| ExcelImage | Represents an Excel Image item |
| ExcelNumberFormat | A class implements IExcelNumberFormat represents a number format settings |
| ExcelOperator | A class used to open or save Excel document by IExcelReader and IExcelWriter. |
| ExcelPrintOptions | Represent the print settings for the entire workbook. |
| ExcelPrintPageMargin | Represent the page margin settings for the entire workbook. |
| ExcelPrintPageSetting | Represent the print page settings for the entire workbook. |
| ExcelPrintSettings | Represent the print settings for the entire workbook. the print setting contains page margin, page settings and print option settings. |
| ExcelRect | A class implements interface IExcelRect, used to represents the client area of the window |
| ExcelRow | represent a single row in ExcelWorksheet |
| ExcelSparkline | An implementation of IExcelSparkline used to specifies information for a single sparkline |
| ExcelSparklineGroup | An implementation used to represents a excel sparkline group setting. |
| ExcelStyle | An class implements IBuiltInExcelStyle used to represent Excel built-in cell style. |
| ExcelTable | An implementation of IExcelTable |
| ExcelTableBorder | Represent the excel table border settings |
| ExcelTableColumn | An implementation of IExcelTableColumn |
| ExcelTableStyle | An implementation of IExcelTableStyle |
| ExcelTableStyleInfo | An implementation of IExcelTableStyleInfo |
| ExcelTheme | A class implements IExcelTheme used for represents theme used for excel. |
| ExcelTop10 | A class implements interface IExcelTop10Filter |
| ExcelWarning | Represents the warnings arising from loading or saving Excel files. |
| ExcelWorkbook | Represents a Workbook |
| ExcelWorkbookPropery | Represent workbook properties. |
| ExcelWorksheet | Represents a worksheet |
| ExcelWorksheet.ExcelViewportInfo | Specifies the position of frozen panes or unfrozen panes in the window used to display the sheet. |
| ExcelWorksheetCollection | Represent the collection of IExcelWorksheet instances. |
| ExtendedFormat | Represents the cell formats and styles in a workbook. |
| ExtendedHeadFooterSetting | Represents the extended header footer setting for print. |
| ExternalCellRange | A class implements IExternalRange used to represents an external range. |
| ExternalWorkbookInfo | A class implements the IExternalWorkbookInfo interface which used to represents an external workbook |
| FontScheme | A class implements IFontScheme represents the font scheme used for excel theme |
| GcSystemColors | Contains system colors. |
| NamedCellRange | Used to represent a cell range in the Excel. If you selected a range and provide a name for it. you can then use that name in your formulas instead of using the raw range expression. in excel. |
| OneCellAnchor | Represents one cell anchor |
| RunFormating | A class implements IRunFormatting represents the run formatting |
| SelectionRange | A class implement ISelectionRange used to represents a selection range |
| TableStyleElement | An implementation of IExcelTableStyleElement |
| ThemeFont | A class implements IThemeFont used for represents the theme font |
| ThemeFonts | Represents the theme fonts |
| TwoCellAnchor | Specifies a two cell anchor placeholder for a group, a shape, or a drawing element. |
| UnsupportedBiffRecord | Represents the unsupported biff records |
| UnsupportRecord |
Interfaces
| Interface | Description | |
|---|---|---|
 | IAlignmentBlock | Defines properties related to alignment settings. |
| IAnchor | Dummy interface used to represents anchor. |
| IBuiltInExcelStyle | Defines the built-in cell style |
| IBuiltInName | An interface used to represents built-in name used in Excel |
| ICalculationProperty | Defines workbook formula setting properties |
| IColorScheme | An interface used to defines a set of colors which are referenced to as a color scheme. The color scheme is responsible for defining a list a twelve colors. The twelve colors consist of six accent colors, two dark colors, two light colors and a color for each of a hyperlink and followed hyperlink. |
| IDifferentialFormatting | Defines formatting for all non-cell formatting in the workbook. It specifies incremental (or differential) aspects of formatting directly inline within dxf element. The dxf formatting is to be applied on top of or in addition to any formatting already presents on the object using the dxf record. |
| IExcel2010DataBarRule | Represents new excel 2010 DataBar rule. |
| IExcelAutoFilter | An interface represents an AutoFilter definitions |
| IExcelBorder | Express a single set of cell border formats. (left, right, top, bottom). Color is optional, when missing, 'automatic' is implied. |
| IExcelBorderSide | Represents border side used in excel border |
| IExcelCell | Defines a generalized collection of properties that a value or class implements to represent properties of excel cell |
| IExcelChartReader | Represents a collection of generalized method which be used to read excel charts. |
| IExcelChartWriter | Represents a collection of generalized method which be used to read excel charts. |
| IExcelColor | Defines color used for excel |
| IExcelColorFilter | Specifies the color to filter by and whether to use the cell's fill or font color in the filter criteria. |
| IExcelColorScaleRule | Describes an icon set conditional formatting rule. |
| IExcelColumn | Defines a generalized collection of properties that a value or class implements to represent properties of excel column |
| IExcelConditionalFormat | Defines a format, such as cell shading or font color, that excel can automatically apply to cells if a specified condition is true. |
| IExcelConditionalFormatRule | Defines the common properties for every conditional formatting rule |
| IExcelConditionalFormatValueObject | Describes the values of the interpolation points in a gradient scale. |
| IExcelCustomFilter | Specifies an operator and a value. |
| IExcelCustomFilters | Specifies an operator and a value |
| IExcelDataBarRule | Describes a data bar conditional formatting rule. |
| IExcelDataValidation | Defines properties and conditions used to represents data validation used in Excel. |
| IExcelDateGroupItem | Represents a group of dates or times which are used in an AutoFilter criteria. |
| IExcelDynamicFilter | Specifies dynamic filter criteria |
| IExcelFilter | A generalized interface used to represent generalized ExcelFilter concept. |
| IExcelFilterColumn | Represents a column in the IExcelAutoFilter range and specifies filter information that has been applied to this column |
| IExcelFilters | When multiple values are chosen to filter by, or when a group of date values are chosen to filter by, this element groups those criteria together. |
| IExcelFont | Defines properties used for representing excel font settings |
| IExcelFormula | Defines Excel formula used in Excel |
| IExcelGeneralRule | Represent a general conditional formatting rule. |
| IExcelHighlightingRule | Defines a highlighting rule |
| IExcelHyperLink | Represents Hyperlink used in excel. |
| IExcelIconFilter | Specifies the icon set and particular icon within that set to filter by. |
| IExcelIconSetsRule | Defines an icon set conditional formatting rule. |
| IExcelImage | Represents an excle image item |
| IExcelLoadOnDemandReader | Represents an load on demand excel reader |
| IExcelLosslessReader | Lossless reader used to read the records which not support in the current vesion. |
| IExcelLosslessWriter | Represents methods used to support excel lossless editing features. |
| IExcelNumberFormat | Defines number format setting |
| IExcelPrintOptions | Defines properties used to represents excel print options |
| IExcelPrintPageMargin | Defines properties used to represents excel print page margin |
| IExcelPrintPageSetting | Defines properties of excel print page settings |
| IExcelPrintSettings | Defines excel print settings |
| IExcelReader | Represents a collection of generalized methods which be used to read Excel file or stream. |
| IExcelReader2 | Represents a collection of generalized methods which be used to read Excel file or stream. |
| IExcelRect | Represents the client area of the window. |
| IExcelRow | Defines a generalized collection of properties that a value or class implements to represent properties of excel row. |
| IExcelSparkline | Specifies information for a single sparkline. |
| IExcelSparklineGroup | Specifies properties of a Excel sparkline group. |
| IExcelSparklineReader | Represents a collection of generalized method which be used to read Excel Sparkline settings. |
| IExcelSparklineWriter | Represents a collection of method which be used to write customized sparkline to excel. |
| IExcelStyle | Defines cell styles used for excel |
| IExcelTable | Describes a excel table definition. |
| IExcelTableBorder | Express a single set of table border formats. (left, right, top, bottom). Color is optional, when missing, 'automatic' is implied. |
| IExcelTableColumn | An element representing a single column for the table. |
| IExcelTableReader | Represents a collection of generalized method which be used to read Excel table settings. |
| IExcelTableStyle | Represents a single table style definition that indicates how a spreadsheet application should format and display a table. |
| IExcelTableStyleElement | Specifies formatting for one area of a table or PivotTable.Together the sequence of these elements makes up one entire Table style or PivotTable style definition. |
| IExcelTableStyleInfo | Describes which style is used to display the table, and specifies which portions of the table have the style applied. |
| IExcelTableWriter | Represents a collection of generalized method which be used to write excel tables. |
| IExcelTheme | Represents theme used for excel. |
| IExcelTop10Filter | Specifies the top N (percent or number of items) to filter by. |
| IExcelWorkbook | Defines generalized properties and methods that value or class implements to represents excel workbook. |
| IExcelWorkbookPropery | Defines a collection of generalized properties that a value or class implements to create type-specific properties used to represents workbook properties. |
| IExcelWorksheet | Defines generalized properties and methods that value or class implements to represents excel worksheet. |
| IExcelWriter | Represents a collection of methods which be used to write customized data module to Excel file or stream. |
| IExcelWriter2 | Represents a collection of methods which be used to write customized data module to Excel file or stream. |
| IExtendedFormat | An interface used to defined format used in cell or style |
| IExtendedHeadFooterSetting | Defines advanced excel head foot print settings |
| IExternalRange | Defines properties used to represents a external range |
| IExternalWorkbookInfo | An interface used to represents external referenced workbook info |
| IFontScheme | Represents the font scheme within the theme. The font scheme consists of a pair of major and minor fonts for which to used in a document. |
| IFunction | An interface used to represents custom or built-in function used in Excel formula |
| ILoadOnDemandReadService | Defines a read service used by IExcelLoadOnDemandReader reader |
| IMeasureString | Defines a generalized method that a value or class implements to create a type-specified method for measuring strings. |
| IName | An interface used to represents a named cell range |
| INameSupport | Defines a generalized property that a value or class implements to create type-specific property for get its name. |
| IRange | Defines properties used to represents a range. |
| IRunFormatting | Defines the run formatting |
| ISelectionRange | Represents a selection range |
| IThemeFont | Defines the theme font |
| IThemeFonts | Represents the theme fonts |
| IUnsupportRecord | Represents a unsupport record in the excel. |
Structures
| Structure | Description | |
|---|---|---|
 | GcColor | Represents an ARGB (alpha, red, green, blue) color. |
| GcPoint | Represents an ordered pair of integer x- and y- coordinates that defines a point in a two-dimensional plane |
| GcRect | Stores a set of four integers that represent the location and size of a rectangle. |
| GcSize | Implements a structure that is used to describe the GrapeCity.Excel.GcSize of an object. |
Enumerations
| Enumeration | Description | |
|---|---|---|
 | BuiltInStyleIndex | Represents built in styles used in Excel |
| CellType | Define the type of the cell |
| ColorSchemeIndex | Defines a set of colors for the theme. The set of colors consists of twelve color slots that can each hold a color of choice |
| DataBarAxisPosition | Specifies the axis position for the data bar. |
| DataBarDirection | Specifies the direction of the data bar. |
| ExcelBorderStyle | Represent the border line style. |
| ExcelCalculationMode | the Calculation mode saved with the workbook. |
| ExcelCalendarType | Specifies the possible types of calendars which can be used |
| ExcelCellErrorPrintStyle | Represent the print policy if the cell value is error |
| ExcelColorType | Represents the color type |
| ExcelConditionalFormattingOperator | These conditional format operators are used for "Highlight Cells That Contain…" rules. For example, "highlight cells that begin with "M2" and contain "Mountain Gear"". |
| ExcelConditionalFormatType | Represent conditional formatting type. |
| ExcelConditionalFormatValueObjectType | This simple type expresses the type of the conditional formatting value object (cfvo). In general the cfvo specifies one value used in the gradated scale (max, min, midpoint, etc). |
| ExcelDataValidationErrorStyle | The style of data validation error alert. |
| ExcelDataValidationOperator | The relational operator used in data validation. |
| ExcelDataValidationType | Specifies the type of data validation used to validate user input |
| ExcelDateTimeGrouping | Specifies how to group dateTime values. |
| ExcelDynamicFilterType | Dynamic filter types |
| ExcelFileType | The type of Excel workbook. |
| ExcelFilterOperator | Operator enumerations for filtering. |
| ExcelFontFamily | Font family of a font |
| ExcelHorizontalAlignment | Represent the horizontal alignment of the content within a ExcelCell |
| ExcelIconSetType | Icon set type for conditional formatting |
| ExcelNoteStyle | Specifies how the cell notes are displayed. |
| ExcelPaletteColor | Represents the excel color palette definition. |
| ExcelPrintNotesStyle | Specifies how cell notes are printed. |
| ExcelPrintOrientation | Specifies the page orientation used to print the sheet. |
| ExcelPrintPageOrder | Specifies the order in which pages are printed. |
| ExcelReferenceStyle | the reference style used in formulas and custom names in Excel. |
| ExcelScrollBarPolicy | Specifies when the component displays the scroll bars. |
| ExcelSheetType | Represent work sheet types |
| ExcelSparklineAxisMinMax | Specifies information about how the vertical axis minimum or maximum is computed for this sparkline group |
| ExcelSparklineEmptyCellDisplayAs | Specifies how empty cells are plotted for all sparklines in the sparkline group |
| ExcelSparklineType | Specifies the type of the sparkline group. |
| ExcelTableElementType | An enumeration that specifies the table element's type. |
| ExcelTableTotalsRowFunction | An enumeration that specifies what function is used to aggregate the data in a column before it is displayed in the totals row. |
| ExcelTableType | An enumeration that specifies what the table data is based on |
| ExcelTabStripPolicy | Specifies when the component displays the sheet name tabs. |
| ExcelVerticalAlignment | Represent the vertical alignment of the content within a ExcelCell |
| ExcelWarningCode | Specifies the warnings codes returned in the Code property of ExcelWarning. |
| FillPatternType | Represent tie Fill pattern type. |
| FontLanguage | Defines the font language used for a specific run of text |
| FontSchemeCategory | Defines the font scheme, if any, to which this font belongs |
| GcSystemColorIndex | Represents all GcSystemColor index used to retrieve system colors from GcSystemColor. |
| HyperLinkType | Represent the hyperlink types |
| ImageType | |
| PaneType | Represents the position of the window panes |
| PrintHFImage | |
| RecordCategory | Specifies the unsupport record category |
| TextDirection | represent the text direction |
| UnderLineStyle | Represents the font underline style |
| VerticalAlignRun | Specifies the type of vertical alignment applied to the contents of the current run. |
See Also