Spread WPF Documentation
Inheritance Hierarchy
In This Topic
    GrapeCity.Excel Namespace
    In This Topic
    Provides the base classes, enumerations, and interfaces to read and write Microsoft Excel BIFF8 formatted structured storage model files.
    Classes
     ClassDescription
    ClassRepresents an absolute anchor
    ClassDefines properties related to alignment settings.
    ClassRepresents all excel built-in styles.
    ClassA class implements IFunction used to represents An interface used to represents built-in name used in Excel
    ClassThis class represents all properties related to excel calculation settings.
    ClassA class implements IColorScheme represents color scheme used for excel theme
    ClassA class implements IExcelStyle used to represents custom cell style.
    ClassRepresent formatting properties that are used in various features to modify cell formatting
    ClassRepresents new excel 2010 DataBar rule.
    ClassRepresents excel 2010 new supported data validation which has at least one external reference formula.
    ClassA class implements interface IExcelAutoFilter
    ClassRepresent the border settings used in ExtendedFormat
    ClassRepresent the border line properties.
    ClassRepresents Excel calc errors
    ClassRepresent a cell in the IExcelWorksheet.
    ClassA class implements IRange used to represents a range
    ClassRepresents color used in Excel
    ClassA class implements interface IExcelColorFilter
    ClassRepresents an icon set conditional formatting rule.
    ClassRepresent a excel column in ExcelWorksheet
    ClassRepresent a conditional formatting conditions
    ClassDescribes the values of the interpolation points in a gradient scale
    ClassA class implements interface IExcelCustomFilter
    ClassA class implements interface IExcelCustomFilters
    ClassA class implements IFunction used to represents a custom function
    ClassDescribes a data bar conditional formatting rule.
    ClassA class implements IExcelDataValidation used to represents the data validation settings used in Excel.
    ClassA class implements interface IExcelDateGroupItem
    ClassA class implement interface IExcelDynamicFilter
    ClassA class implements interface IExcelFilterColumn
    ClassAn class implements interface IExcelFilters
    ClassRepresent the Excel Font settings.
    ClassA class implements IExcelFormula, used to represent formula in Excel
    ClassA class implements IExcelGeneralRule represents a general conditional formatting rule.
    ClassRepresents a highlighting rule
    ClassRepresents 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.
    ClassA class implements interface IExcelIconFilter
    ClassDescribes an icon set conditional formatting rule.
    ClassRepresents an Excel Image item
    ClassA class implements IExcelNumberFormat represents a number format settings
    ClassA class used to open or save Excel document by IExcelReader and IExcelWriter.
    ClassRepresent the print settings for the entire workbook.
    ClassRepresent the page margin settings for the entire workbook.
    ClassRepresent the print page settings for the entire workbook.
    ClassRepresent the print settings for the entire workbook. the print setting contains page margin, page settings and print option settings.
    ClassA class implements interface IExcelRect, used to represents the client area of the window
    Classrepresent a single row in ExcelWorksheet
    ClassAn implementation of IExcelSparkline used to specifies information for a single sparkline
    ClassAn implementation used to represents a excel sparkline group setting.
    ClassAn class implements IBuiltInExcelStyle used to represent Excel built-in cell style.
    ClassAn implementation of IExcelTable
    ClassRepresent the excel table border settings
    ClassAn implementation of IExcelTableColumn
    ClassAn implementation of IExcelTableStyle
    ClassAn implementation of IExcelTableStyleInfo
    ClassA class implements IExcelTheme used for represents theme used for excel.
    ClassA class implements interface IExcelTop10Filter
    ClassRepresents the warnings arising from loading or saving Excel files.
    ClassRepresents a Workbook
    ClassRepresent workbook properties.
    ClassRepresents a worksheet
    ClassSpecifies the position of frozen panes or unfrozen panes in the window used to display the sheet.
    ClassRepresent the collection of IExcelWorksheet instances.
    ClassRepresents the cell formats and styles in a workbook.
    ClassRepresents the extended header footer setting for print.
    ClassA class implements IExternalRange used to represents an external range.
    ClassA class implements the IExternalWorkbookInfo interface which used to represents an external workbook
    ClassA class implements IFontScheme represents the font scheme used for excel theme
    ClassContains system colors.
    ClassUsed 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.
    ClassRepresents one cell anchor
    ClassA class implements IRunFormatting represents the run formatting
    ClassA class implement ISelectionRange used to represents a selection range
    ClassAn implementation of IExcelTableStyleElement
    ClassA class implements IThemeFont used for represents the theme font
    ClassRepresents the theme fonts
    ClassSpecifies a two cell anchor placeholder for a group, a shape, or a drawing element.
    ClassRepresents the unsupported biff records
    Class 
    Interfaces
     InterfaceDescription
    InterfaceDefines properties related to alignment settings.
    InterfaceDummy interface used to represents anchor.
    InterfaceDefines the built-in cell style
    InterfaceAn interface used to represents built-in name used in Excel
    InterfaceDefines workbook formula setting properties
    InterfaceAn 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.
    InterfaceDefines 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.
    InterfaceRepresents new excel 2010 DataBar rule.
    InterfaceAn interface represents an AutoFilter definitions
    InterfaceExpress a single set of cell border formats. (left, right, top, bottom). Color is optional, when missing, 'automatic' is implied.
    InterfaceRepresents border side used in excel border
    InterfaceDefines a generalized collection of properties that a value or class implements to represent properties of excel cell
    InterfaceRepresents a collection of generalized method which be used to read excel charts.
    InterfaceRepresents a collection of generalized method which be used to read excel charts.
    InterfaceDefines color used for excel
    InterfaceSpecifies the color to filter by and whether to use the cell's fill or font color in the filter criteria.
    InterfaceDescribes an icon set conditional formatting rule.
    InterfaceDefines a generalized collection of properties that a value or class implements to represent properties of excel column
    InterfaceDefines a format, such as cell shading or font color, that excel can automatically apply to cells if a specified condition is true.
    InterfaceDefines the common properties for every conditional formatting rule
    InterfaceDescribes the values of the interpolation points in a gradient scale.
    InterfaceSpecifies an operator and a value.
    InterfaceSpecifies an operator and a value
    InterfaceDescribes a data bar conditional formatting rule.
    InterfaceDefines properties and conditions used to represents data validation used in Excel.
    InterfaceRepresents a group of dates or times which are used in an AutoFilter criteria.
    InterfaceSpecifies dynamic filter criteria
    InterfaceA generalized interface used to represent generalized ExcelFilter concept.
    InterfaceRepresents a column in the IExcelAutoFilter range and specifies filter information that has been applied to this column
    InterfaceWhen 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.
    InterfaceDefines properties used for representing excel font settings
    InterfaceDefines Excel formula used in Excel
    InterfaceRepresent a general conditional formatting rule.
    InterfaceDefines a highlighting rule
    InterfaceRepresents Hyperlink used in excel.
    InterfaceSpecifies the icon set and particular icon within that set to filter by.
    InterfaceDefines an icon set conditional formatting rule.
    InterfaceRepresents an excle image item
    InterfaceRepresents an load on demand excel reader
    InterfaceLossless reader used to read the records which not support in the current vesion.
    InterfaceRepresents methods used to support excel lossless editing features.
    InterfaceDefines number format setting
    InterfaceDefines properties used to represents excel print options
    InterfaceDefines properties used to represents excel print page margin
    InterfaceDefines properties of excel print page settings
    InterfaceDefines excel print settings
    InterfaceRepresents a collection of generalized methods which be used to read Excel file or stream.
    InterfaceRepresents a collection of generalized methods which be used to read Excel file or stream.
    InterfaceRepresents the client area of the window.
    InterfaceDefines a generalized collection of properties that a value or class implements to represent properties of excel row.
    InterfaceSpecifies information for a single sparkline.
    InterfaceSpecifies properties of a Excel sparkline group.
    InterfaceRepresents a collection of generalized method which be used to read Excel Sparkline settings.
    InterfaceRepresents a collection of method which be used to write customized sparkline to excel.
    InterfaceDefines cell styles used for excel
    InterfaceDescribes a excel table definition.
    InterfaceExpress a single set of table border formats. (left, right, top, bottom). Color is optional, when missing, 'automatic' is implied.
    InterfaceAn element representing a single column for the table.
    InterfaceRepresents a collection of generalized method which be used to read Excel table settings.
    InterfaceRepresents a single table style definition that indicates how a spreadsheet application should format and display a table.
    InterfaceSpecifies 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.
    InterfaceDescribes which style is used to display the table, and specifies which portions of the table  have the style applied.
    InterfaceRepresents a collection of generalized method which be used to write excel tables.
    InterfaceRepresents theme used for excel.
    InterfaceSpecifies the top N (percent or number of items) to filter by.
    InterfaceDefines generalized properties and methods that value or class implements to represents excel workbook.
    InterfaceDefines a collection of generalized properties that a value or class implements to create type-specific properties used to represents workbook properties.
    InterfaceDefines generalized properties and methods that value or class implements to represents excel worksheet.
    InterfaceRepresents a collection of methods which be used to write customized data module to Excel file or stream.
    InterfaceRepresents a collection of methods which be used to write customized data module to Excel file or stream.
    InterfaceAn interface used to defined format used in cell or style
    InterfaceDefines advanced excel head foot print settings
    InterfaceDefines properties used to represents a external range
    InterfaceAn interface used to represents external referenced workbook info
    InterfaceRepresents 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.
    InterfaceAn interface used to represents custom or built-in function used in Excel formula
    InterfaceDefines a read service used by IExcelLoadOnDemandReader reader
    InterfaceDefines a generalized method that a value or class implements to create a type-specified method for measuring strings.
    InterfaceAn interface used to represents a named cell range
    InterfaceDefines a generalized property that a value or class implements to create type-specific property for get its name.
    InterfaceDefines properties used to represents a range.
    InterfaceDefines the run formatting
    InterfaceRepresents a selection range
    InterfaceDefines the theme font
    InterfaceRepresents the theme fonts
    InterfaceRepresents a unsupport record in the excel.
    Structures
     StructureDescription
    StructureRepresents an ARGB (alpha, red, green, blue) color.
    StructureRepresents an ordered pair of integer x- and y- coordinates that defines a point in a two-dimensional plane
    StructureStores a set of four integers that represent the location and size of a rectangle.
    StructureImplements a structure that is used to describe the GrapeCity.Excel.GcSize of an object.
    Enumerations
     EnumerationDescription
    EnumerationRepresents built in styles used in Excel
    EnumerationDefine the type of the cell
    EnumerationDefines a set of colors for the theme. The set of colors consists of twelve color slots that can each hold a color of choice
    EnumerationSpecifies the axis position for the data bar.
    EnumerationSpecifies the direction of the data bar.
    EnumerationRepresent the border line style.
    Enumerationthe Calculation mode saved with the workbook.
    EnumerationSpecifies the possible types of calendars which can be used
    EnumerationRepresent the print policy if the cell value is error
    EnumerationRepresents the color type
    EnumerationThese conditional format operators are used for "Highlight Cells That Contain…" rules. For example, "highlight cells that begin with "M2" and contain "Mountain Gear"".
    EnumerationRepresent conditional formatting type.
    EnumerationThis 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).
    EnumerationThe style of data validation error alert.
    EnumerationThe relational operator used in data validation.
    EnumerationSpecifies the type of data validation used to validate user input
    EnumerationSpecifies how to group dateTime values.
    EnumerationDynamic filter types
    EnumerationThe type of Excel workbook.
    EnumerationOperator enumerations for filtering.
    EnumerationFont family of a font
    EnumerationRepresent the horizontal alignment of the content within a ExcelCell
    EnumerationIcon set type for conditional formatting
    EnumerationSpecifies how the cell notes are displayed.
    EnumerationRepresents the excel color palette definition.
    EnumerationSpecifies how cell notes are printed.
    EnumerationSpecifies the page orientation used to print the sheet.
    EnumerationSpecifies the order in which pages are printed.
    Enumerationthe reference style used in formulas and custom names in Excel.
    EnumerationSpecifies when the component displays the scroll bars.
    EnumerationRepresent work sheet types
    EnumerationSpecifies information about how the vertical axis minimum or maximum is computed for this sparkline group
    EnumerationSpecifies how empty cells are plotted for all sparklines in the sparkline group
    EnumerationSpecifies the type of the sparkline group.
    EnumerationAn enumeration that specifies the table element's type.
    EnumerationAn enumeration that specifies what function is used to aggregate the data in a column before it is displayed in the totals row.
    EnumerationAn enumeration that specifies what the table data is based on
    EnumerationSpecifies when the component displays the sheet name tabs.
    EnumerationRepresent the vertical alignment of the content within a ExcelCell
    EnumerationSpecifies the warnings codes returned in the Code property of ExcelWarning.
    EnumerationRepresent tie Fill pattern type.
    EnumerationDefines the font language used for a specific run of text
    EnumerationDefines the font scheme, if any, to which this font belongs
    EnumerationRepresents all GcSystemColor index used to retrieve system colors from GcSystemColor.
    EnumerationRepresent the hyperlink types
    Enumeration 
    EnumerationRepresents the position of the window panes
    Enumeration 
    EnumerationSpecifies the unsupport record category
    Enumerationrepresent the text direction
    EnumerationRepresents the font underline style
    EnumerationSpecifies the type of vertical alignment applied to the contents of the current run.
    See Also