GrapeCity.Spreadsheet Namespace (GrapeCity.Spreadsheet)

In This Topic

Provides the namespaces, classes and enumerations for the spreadsheet features.

Classes

	Class	Description
	BuiltInNumberFormats
	CalculationEngine	Represents a class which store, evaluate or adjust expressions. This class cannot be inherited.
	CfRule
	ColorManager
	ColorResolver
	ColorStop	Represents the color stop point for a gradient fill in a range or selection. This class cannot be inherited.
	ConfirmationEventArgs	Represents the event argument for confirming user's option.
	DataValidations	Represents the data validations associated with the specified Worksheet.
	DifferentialFormat
	DisplayFormat	Represents the display settings for an associated Range object. This class cannot be inherited.
	ExpressionView	Represents a view of cell range in worksheet which all cell values are calculated by a specified formula.
	ExpressionViewCell	Represents a cell in the ExpressionView. This class cannot be inherited.
	ExternalVariable	Represents a external variable.
	Factory	Represents a spreadsheet factory for customizable types.
	Features
	PageBreaks	Represents page break information used for print layout view, page layout view, drawing print breaks in normal view, and for printing the worksheet. This class cannot be inherited.

Interfaces

	Interface	Description
	IAboveAverage	Represents an above average visual of a conditional formatting rule.
	IAlternatingStyles
	IAreas	Represents a collection of the areas, or contiguous blocks of cells, within a selection.
	IArray<T>
	IAutoFilter	Represents the filter for the specified worksheet.
	IBorder	Represents the border of an object.
	IBorders	A collection of Border objects that represent the four borders of a Range or Style object.
	ICellType
	IColorPalette	Represents the color palette that contains indexed colors.
	IColorScale
	IColorScaleCriteria	A collection of ColorScaleCriterion objects that represents all of the criteria for a color scale conditional format. Each criterion specifies the minimum, midpoint, or maximum threshold for the color scale.
	IColorScaleCriterion	Represents the criteria for the minimum, midpoint, or maximum thresholds for a color format conditional format.
	IColorStops	A collection of all the ColorStop objects for the specified series.
	IColumnFooter	Represents the column footer of a worksheet.
	IColumnHeader	Represents the column header of a worksheet.
	IConditionValue	Represents how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule.
	IDatabar	Represents a data bar conditional formating rule.
	IDatabarBorder	Represents the border of the data bars specified by a conditional formatting rule.
	IFilter	Represents a filter for a single column.
	IFilters	Represents a collection of IFilter objects that represents all the filters in an auto filtered range.
	IFont	Contains the font attributes (font name, font size, color, and so on) for an object.
	IFormatCondition	Represents a conditional format.
	IFormatConditions	Represents the collection of conditional formats for a single range.
	IFormatter	Represents the value formater.
	IGradient	Contains the font attributes (font name, font size, color, and so on) for an object.
	IIconCriteria	Represents the collection of IconCriterion objects. Each IconCriterion represents the values and threshold type for each icon in an icon set conditional formatting rule.
	IIconCriterion	Represents the criterion for an individual icon in an icon set. The criterion specifies the range of values and the threshold type associated with the icon in an icon set conditional formatting rule.
	IIconSetCondition	Represents an icon set conditional formatting rule.
	IInterior	Represents the interior of an object.
	IName	Represents a defined name.
	INames	Represents a collection of all the IName objects in the workbook.
	INegativeBarFormat	Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule.
	IOutline	Represents an outline on a worksheet.
	IRange	Interface that represent a range of a worksheet.
	IReadonlyArray<T>
	IRowHeader	Represents the row header of a worksheet.
	ISort	Represents a sort of a range of data.
	ISortComparer
	ISortField	Represent an object contains all the sort information for the IWorksheet, ITable, and IAutoFilter objects.
	ISortFields
	IStyle	Represents the appearance of the cells in the worksheet.
	IStyles	Represents a collection of all styles in the workbook.
	ITable	Represents a table of the worksheet.
	ITableColumn	Represents a column in a table.
	ITableColumns	Represents a collection of all the ITableColumn objects in the specified ITable object.
	ITableRow	Represents a row in a table.
	ITableRows	Represents a collection of all the table rows in the specified table.
	ITables	Represents an ITables object which manages all ITable tables in the specified IWorksheet.
	ITableStyle	Represents a single style that can be applied to a table.
	ITableStyleElement	Represents a single table style element.
	ITableStyleElements	Represents table style elements.
	ITableStyles	Represents styles that can be applied to a table.
	ITop10	Represents a top ten visual of a conditional formatting rule. Applying a color to a range helps you see the value of a cell relative to other cells.
	IUniqueValues	The UniqueValues object uses the DupeUnique property to Gets or sets an enum that determines whether the rule should look for duplicate or unique values in the range.
	IValidation	Represents data validation for a worksheet range.
	IWorkbook	Represents a workbook.
	IWorkbooks	Represents a set of workbooks in a workbook set.
	IWorkbookSet	Represents a set of workbooks which may refer to each other by external cell references or external defined name references.
	IWorksheet	Represents a worksheet.
	IWorksheets	Represents a set of worksheets in a workbook.
	IWorksheetStyles
	IWorksheetView

Structures

	Structure	Description
	ActionResult<T>	Represents the executing result of an action.
	Alignment
	AutoFilterColumn	The FilterColumn collection identifies a particular column in the AutoFilter range and specifies filter information that has been applied to this column. If a column in the AutoFilter range has no criteria specified, then there is no corresponding filterColumn collection expressed for that column.
	Border
	BorderLine
	Break	Represents a page break information.
	CellProtection
	CellReference	Represents a reference to a range of cells.
	CfExecutedResult	Represents the matched conditional formatting result.
	CfIcon	Represents a single icon of an icon set.
	CfValue
	Color	Struct ColorData
	CustomFilterCriteria	A custom AutoFilter specifies an operator and a value. There can be at most two customFilters specified, and in that case the parent element specifies whether the two conditions are joined by 'and' or 'or'. For any cells whose values do not meet the specified criteria, the corresponding rows shall be hidden from view when the fitler is applied.
	DataValidationExecutedResult
	DataValidationSuggestionItem	Represents a suggested data for the cell.
	DateGroupItem	This collection is used to express a group of dates or times which are used in an AutoFilter criteria
	Fill	Represent the fill formatting.
	FilterData	Represents all filter data of a filter column.
	FilterData.DateTimeItem	Represents a date time value and its corresponding IFormatter in the worksheet.
	Font	Defines a particular format for text, including font face, size, and style attributes.
	FormatResult	Represents the formatting value result.
	GradientFillEffect	Represents the gradient fill effect.
	GradientStop	Represents the gradient stop.
	NumberFormat	Represents number format properties which indicate how to format and render the numeric value of a cell
	Reference	Represents a reference to a range of cells.
	TableStyleElement	Represents a single table style element.

Enumerations

	Enumeration	Description
	AboveBelow	Specifies if the values are above or below average.
	AlignmentAttributes
	AutoFilterOperator	Specifies the operator to use to associate two criteria applied by a filter.
	Behaviors	Represents the behaviors of operations.
	BorderLineStyle	Enum the line style for border.
	BordersIndex	Specifies the border to be retrieved.
	BreakAttributes
	BuiltInSlicerStyles
	BuiltInStyle	Represents all built-in styles.
	BuiltInTableStyles	Represents all built-in table styles.
	CalcFeatures
	Calculation	Represents when calculation engine should calculate formulas in the spreadsheet.
	CalendarType
	CellDataType	Represents the data type of a cell in the ExpressionView.
	CfValueType	Specifies the types of condition values that can be used.
	CharacterSet	Defines the possible sets of character glyphs that are defined in fonts for graphics output.
	ClassicCfRuleType
	ColorType	Specifies the color format type.
	Compatibility	Represents compatibility options for spreadsheet.
	ContainsOperator	Specifies the text operator used in a function.
	CustomFilterOperator
	DatabarAxisPosition	Represents the axis position for the data bar.
	DatabarBorderType	Specifies the border of a data bar.
	DatabarDirection	Specifies a value indicating whether the axis appears from right to left.
	DatabarFillType	Specifies how a data bar is filled with color.
	DatabarNegativeColorType	Specifies whether to use the same border and fill color as postive data bars.
	DataRestrictions	Specifies the reason for an unaccepted expression or value.
	DataValidationErrorStyle	The style of data validation error alert.
	DataValidationOperator	The relational operator used in data validation.
	DataValidationType	Specifies the type of data validation used to validate user input.
	DateTimeGrouping	Specifies the part of the date time value used in a comparision.
	Direction	Specifies the direction in which to move.
	DisplayValueStyle	Represents the display style of a value.
	DupeUnique	Specifies whether duplicate or unique values shoud be displayed.
	DynamicFilterType
	FilterDataType	Represents the filter mode which UI should be displayed.
	FilterOptions	Represents the filtering options for querying defined names.
	FilterScopes	Represents the filtering scopes for querying defined names.
	FontAttributes	Represents all attributes of a font.
	FontFamily	The FamilyFont enumeration specifies the font family. Font families describe the look of a font in a general way. They are intended for specifying fonts when the exact typeface desired is not available.
	FontStyle	Represents the style of the typeface of a font.
	FormatColorEnum	Represents all formatted color values.
	FormatConditionOperator	Specifies the operator to use to compare a formula against the value in a cell or, for Between and NotBetween , to compare two formulas.
	FormatConditionType	Specifies whether the conditional format is based on a cell value or an expression.
	FormatOptions	Represents advanced options for formatting value to text.
	GradientType	Type of gradient fill being used, either linear or path.
	HorizontalAlignment	Enum the horizontal alignment of a cell or object.
	IconSetType
	ImeMode	Specifies a value that determines the Input Method Editor (IME) status.
	ManipulationOptions	Indicates which data type will be performed.
	Operator	Represents the comparison operator.
	PageBreak	Specifies page break location in the worksheet.
	PatternType	Represents the Fill pattern type.
	ProtectionMode	Represents the protection type of the workbook or worksheet.
	ReferenceStyle	Specifies the reference style in formulas and custom names in the sheet.
	SheetViewType	Represents the view type of a GrapeCity.Spreadsheet.ISheetView.
	SheetVisibility	Specifies whether the worksheet is visible.
	SortDataOption	Specifies how to sort text.
	SortMethod	Specifies the sort method for Chinese languages.
	SortOn	Represents which data will be sorted.
	SortOrder	Represents whether to sort in ascending order or descending order.
	SummaryColumn	Specifies the location of the summary columns in the outline.
	SummaryRow	Specifies the location of the summary rows in the outline.
	TableStyleElementType	Represents the table style element's type.
	TableStyleSettings
	TableType
	TextReadingOrder
	ThemeFont	Represents the theme font within the theme. The theme font consists of a pair of major and minor fonts for which to used in a document.
	TimePeriods	Represents a time period which is used in date conditions.
	TopBottom	Specifies the top 10 values from the top or bottom of a series of values.
	TotalsCalculation	An enumeration that specifies what function is used to aggregate the data in a column before it is displayed in the totals row.
	UnderlineStyle	Specifies the underline style of text.
	UpdateLinks	Specifies a workbook's setting for updating embedded links.
	VerticalAlignment	Specifies the vertical alignment of text.
	VerticalTextAlignment
	WorkbookLocks	Represent protected data of the workbook.
	WorksheetLocks	Represents protected data of the worksheet.
	WorksheetType	Specifies the worksheet type.
	YesNoCancel	Represents the choice to perform an action.
	YesNoGuess	Specifies whether or not the first row contains headers.

Reference

GrapeCity.Spreadsheet Assembly

Product Support Forum | Print this page