GrapeCity.Excel Namespace

Provides the base classes, enumerations, and interfaces to read and write Microsoft Excel BIFF8 formatted structured storage model files.

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.

Reference

GrapeCity.Silverlight.Excel Assembly