GrapeCity.Spreadsheet Namespace

In This Topic

Classes

	Class	Description
	Authors	Represents a list of authors.
	BuiltInNumberFormats	Represents all built-in number formats.
	CalculationEngine	Represents a class which store, evaluate or adjust expressions. Represents util functions for calculation.
	CellImageAttribute	Represents an attributes that allow to specify the cell inline image data.
	CellValueChangedEventArgs	Represents a class which stores cell calculated information.
	ColorStop	Represents the color stop point for a gradient fill in a range or selection.
	DisplayFormat	Represents the display settings for an associated Range object.
	ExpressionViewCell	Represents a cell in the ExpressionView.
	Features	Represents all customizable features of Spread.
	RichText	Represents the rich text.
	WorksheetOptions	Represents all options of the IWorksheet object.

Interfaces

	Interface	Description
	IAboveAverage	Represents an above average visual of a conditional formatting rule.
	IAlternatingStyles	Represents a collection of alternating styles.
	IAreas	Represents a collection of the areas, or contiguous blocks of cells, within a selection.
	IArray<T>	Represents an array of items which are declared as T type.
	IAuthor	Represents the author of the ICommentThreaded object.
	IAutoFilter	Represents the filter for the specified worksheet.
	IAutoFilterOwner	Represents an object which contains an AutoFilter.
	IBorder	Represents the border of an object.
	IBorders	A collection of Border objects that represent the four borders of a Range or Style object.
	ICellEditor	Represents the editor of a cell.
	ICellRenderer	Represents the renderer of a cell
	ICellType	Represents the cell type of a cell.
	ICharacters	Represents characters in an object that contains text.
	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.
	IComment	Represents a cell comment.
	IComments	Represents a collection of cell comments.
	ICommentsThreaded	Represents a collection of top-level ICommentThreaded objects in a worksheet, or a collection of replies in a single threaded comment.
	ICommentThreaded	Represents a cell's threaded comment. This object can represent both a top-level comment or its replies.
	IConditionValue	Represents how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule.
	IDatabar	Represents a data bar conditional formatting rule.
	IDatabarBorder	Represents the border of the data bars specified by a conditional formatting rule.
	IDataManager	Represents the data manager of a worksheet.
	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 formatter.
	IGradient	Contains the font attributes (font name, font size, color, and so on) for an object.
	IGraphic	Contains properties that apply to header and footer picture objects.
	IHyperlink	Represents a hyperlink.
	IHyperlinks	Represents the collection of hyperlinks for a worksheet or range.
	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.
	IMedia	Represents an embedded resource.
	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 formatting rule.
	INumFmtSupportCellType	Represents the cell type of a cell which supports NumberFormat.
	IOutline	Represents an outline on a worksheet.
	IProtection	Represents the various types of protection options available for a worksheet.
	IRange	Interface that represent a range of a worksheet.
	IReadonlyArray<T>	Represents a read-only array of items which are declared as T type.
	IRowHeader	Represents the row header of a worksheet.
	ISheet	Represents a sheet in the workbook.
	ISheets	Represents a collection of all the sheets in the specified or active workbook.
	ISheetView	Represents a sheet view.
	ISort	Represents a sort of a range of data.
	ISortComparer	Represents a custom sort comparer.
	ISortField	Represent an object contains all the sort information for the IWorksheet, ITable, and IAutoFilter objects.
	ISortFields	Represents the collection of ISortField objects.
	ISparkAxes	Represents the settings for the horizontal and vertical axes of a group of sparklines.
	ISparkColor	Represents the color of the horizontal axis and the markers for points in a sparkline.
	ISparkHorizontalAxis	Represents the settings for the horizontal axes of a group of sparklines.
	ISparkline	Represents a single sparkline.
	ISparklineGroup	Represents a group of sparklines.
	ISparklineGroups	Represents a collection of sparkline groups.
	ISparkPoints	Represents the settings of the markers for points of data on a sparkline.
	ISparkVerticalAxis	Represents the settings for the vertical axes of a group of sparklines.
	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	Represents a collection of all styles in the worksheet.
	IWorksheetView	Represents a worksheet view.

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	Represents the border of an object.
	BorderLine	Represent the line settings of border.
	Break	Represents a page break information.
	CellProtection
	CellReference	Represents a reference to a position of cell.
	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.
	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.
	StyleFormat	Represents all style settings of the cell.
	TableStyleElement	Represents a single table style element.
	WorksheetReference	Represents a reference to a range of cells in the specified worksheet.

Enumerations

	Enumeration	Description
	AboveBelow	Specifies if the values are above or below average.
	AlignmentAttributes	Specifies all attributes of the Alignment value.
	AutoFillType	Specifies how the target range is to be filled, based on the contents of the source range.
	AutoFilterOperator	Specifies the operator to use to associate two criteria applied by a filter.
	Behaviors	Represents the behaviors of operations.
	BorderLineStyle	Represents the line style of border.
	BordersIndex	Specifies the border to be retrieved.
	BuiltInSlicerStyles	Represents all built-in slicer styles.
	BuiltInStyle	Represents all built-in styles.
	BuiltInTableStyles	Represents all built-in table styles.
	CalcFeatures	Represents all available features of the calculation engine.
	Calculation	Represents when calculation engine should calculate formulas in the spreadsheet.
	CalculationOnDemandMode	Specifies whether invidiual cells are re-calculated.
	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.
	ChartLocks	Represents protection options of a chart sheet.
	ClassicCfRuleType
	ColorType	Specifies the color format type.
	ColumnDataType	Specifies how a column is to be parsed.
	Compatibility	Represents compatibility options for spreadsheet.
	ContainsOperator	Specifies the text operator used in a function.
	CustomFilterOperator	Specifies the comparison operation to be performed.
	CutCopyMode	Specifies whether status is Copy mode or Cut mode.
	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.
	DeleteShiftDirection	Represents the choise to delete cells.
	Direction	Specifies the direction in which to move.
	DisplayBlanksAs	Specifies how empty cells are plotted.
	DisplayValueStyle	Represents the display style of a value.
	DupeUnique	Specifies whether duplicate or unique values shoud be displayed.
	DynamicFilterType	Specifies the type of dynamic filter to be applied.
	EnableSelection	Specifies what can be selected on the sheet.
	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.
	FindLookIn	Specifies the type of data to search.
	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.
	HyperlinkType	Specifies the type of hyperlink.
	IconSetType
	ImeMode	Specifies a value that determines the Input Method Editor (IME) status.
	InsertFormatOrigin	Specifies from where to copy the format for inserted cells.
	InsertShiftDirection	Represents the choice to insert cells.
	LookAt	Specifies whether a match is made against the whole of the search text or any part of the search text.
	ManipulationOptions	Indicates which data type will be performed.
	MergePolicy	Specifies how the control handles automatic merging of cells based on the values in the cells.
	NewRowPosition	Represents the position of the new row.
	NumberFormatConvertMode	Represents how localized number format is parsed.
	Operator	Represents the comparison operator.
	PageBreak	Specifies page break location in the worksheet.
	PasteSpecialOperation	Specifies how numeric data will be calculated with the destinations cells on the worksheet.
	PasteType	Specifies the part of the range to be pasted.
	PatternType	Represents the Fill pattern type.
	PredefinedNumberFormats	Represents predefined cell number formats.
	ProtectionMode	Represents the protection type of the workbook or worksheet.
	ReferenceStyle	Specifies the reference style in formulas and custom names in the sheet.
	SearchDirection	Specifies the search direction when searching a range.
	SearchOrder	Specifies the order in which to search the range.
	SheetViewType	Represents the view type of a IWorksheetView.
	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.
	SortOrientation	Represents the sort orientation.
	SparklineRowCol	Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range.
	SparkScale	Specifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.
	SparkType	Specifies the type of sparkline.
	SpecialCellsValue	Specifies cells with a particular type of value to include in the result.
	SpecialCellType	Specifies the type of cells.
	StyleFormatApplyment
	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	Specifies the type of a table.
	TextParsingType	Specifies the column format for the data in the text file that you are importing into a query table.
	TextQualifier	Specifies the delimiter to use to specify text.
	TextReadingOrder	Specifies the reading order.
	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	Specifies the vertical alignment of text line.
	WorkbookLocks	Represent protected data of the workbook.
	WorksheetLocks	Represents protection options of a worksheet.
	WorksheetSubType	Specifies the type of worksheet headers and footers.
	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