GrapeCity.Spreadsheet Namespace (GrapeCity.Spreadsheet)

In This Topic

Classes

	Class	Description
	ArrayHelper	The class intend not to be used directly in user code. This is a %[LangWord]static class% and so cannot be inherited or instantiated.
	Authors	Represents a list of authors. This class cannot be inherited.
	AutoFilter	Represents autofiltering for the specified worksheet.
	BuiltInCfRule	Represents a built-in conditional formatting rule. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	BuiltInDataValidation
	BuiltInNumberFormats	Represents all built-in number formats.
	CalculationEngine	Represents util functions for calculation. This class cannot be inherited.
	CellRangeDataSource	Represents the data source which binds to the specified cell range via a reference or a defined name. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	CellValueChangedEventArgs	Represents a class which stores cell calculated information. This class cannot be inherited.
	CfRule
	ClassicCfRule	Represents a classic conditional formatting rule.
	Collection<T>	Represents a strongly typed list of objects that can be accessed by index.
	ColorFilter	This element specifies the color to filter by and whether to use the cell's fill or font color in the filter criteria. If the cell's font or fill color does not match the color specified in the criteria, the rows corresponding to those cells are hidden from view.
	ColorManager	Represents the color manager of the IWorkbookSet object. This class cannot be inherited.
	ColorResolver
	ColorScaleCfRule
	ColorStop	Represents the color stop point for a gradient fill in a range or selection. This class cannot be inherited.
	Comment
	CommentBase
	CompatibleFeatures
	ConditionalFormatting	Represents a conditional formatting which apply a set of rules to a set of range references.
	ConfirmationEventArgs	Represents the event argument for confirming user's option.
	CustomFilter	When there is more than one custom filter criteria to apply (an 'and' or 'or' joining two criteria), then this element groups the customFilter elements together
	DatabarCfRule	Represents the data bar conditional formatting rule.
	DataValidation	Represent for the data valiation information.
	DataValidations	Represents the data validations associated with the specified Worksheet.
	DataValidationSuggestionList
	DataValidator
	DefinedName	Represents a defined name.
	DifferentialFormat
	DisplayFormat	Represents the display settings for an associated Range object. This class cannot be inherited.
	DocumentProperties	Represents all properties of the spreadsheet document. This class cannot be inherited.
	DynamicFilter	This collection specifies dynamic filter criteria. These criteria are considered dynamic because they can change, either with the data itself (e.g., "above average") or with the current system date (e.g., show values for "today"). For any cells whose values do not meet the specified criteria, the corresponding rows shall be hidden from view when the filter is applied.
	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	Represents all customizable features of Spread. This class cannot be inherited.
	Filter	Represents the base class for filter. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	FormatConditionalHelper
	FormatConditions	Represents the conditional formats associated with the specified Worksheet.
	Hyperlink	Represents a hyperlink. This class cannot be inherited.
	IconFilter	This element specifies the icon set and particular icon within that set to filter by. For any cells whose icon does not match the specified criteria, the corresponding rows shall be hidden from view when the filter is applied.
	IconSetCfRule	Class IconSetConditionalFormattingRule. This class cannot be inherited.
	IndexBitmap	Represents the roaring bitmap data structure. This class cannot be inherited.
	IntervalArray<T>	Represents an one dimension array data structure which is stored as intervals.
	IntervalBitmap	Represents an one dimension array data structure which is stored as intervals.
	LayoutManager	Represents the layout manager.
	MultiValuesFilter	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.
	NamedObjectCollection<TItem,TContainer>	Represents a strongly typed list of objects that can be accessed by index or string key.
	Outline
	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.
	RichText	Represents the rich text. This class cannot be inherited.
	Sort	Represents a sort of a range of data.
	SortField
	Sparkline	Represents a sparkline. This class cannot be inherited.
	SparklineDataSource	Represents the data source of a sparkline. This is a %[LangWord]static class% and so cannot be inherited or instantiated.
	SparklineGroup	Represents a group of sparklines. This class cannot be inherited.
	SparklineSetting	Represents settings for sparklines.
	SparklineStorage	Represents the sparkline storage This class cannot be inherited.
	SparseArray<T>	Represents a strongly typed arry of objects that can be accessed by index. Provides methods to manipulate objects.
	SpreadsheetHelper	The class intend not to be used directly in user code. This is a %[LangWord]static class% and so cannot be inherited or instantiated.
	Styles	Represents a collection of all styles in the workbook.
	SubWorksheet
	Table	Represents a table of the worksheet.
	Tables	Represents a Tables which manages all Table tables in the specified Worksheet.
	TableStyle	Represents a single style that can be applied to a table. This class cannot be inherited.
	ThreadedComment
	Top10Filter	This element specifies the top N (percent or number of items) to filter by.
	Utils	Internal use only. This is a %[LangWord]static class% and so cannot be inherited or instantiated.
	Workbook	Represents a workbook.
	WorkbookBase	Represents a workbook base. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	WorkbookSet	Represents a set of workbooks which may refer to each other by external cell references or external defined name references.
	Worksheet	Represents a worksheet.
	WorksheetBase	Represents a worksheet base. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	WorksheetFunction	Represents the container for worksheet functions that can be called from application. This class cannot be inherited.
	WorksheetOptions	Represents all options of the IWorksheet object. This class cannot be inherited.
	WorksheetView	Represents a worksheet view. This class cannot be inherited.

Interfaces

	Interface	Description
	Cloner<T>	Supports cloning, which creates a new instance of a class with the same value as an existing instance.
	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.
	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.
	ICompositeExtendData	Represents an interface for other products to extend composable data of 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.
	IDataManager	Represents the data manager of a worksheet.
	IEditor	Represents the editor of a cell.
	IExtendedData	Represents an interface for other products to extend data of 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 formating rule.
	INumberFormatExtendData	Represents extend data for NumberFormat.
	IOutline	Represents an outline on 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.
	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.
	ISpreadsheet	Represent an absract spreadsheet.
	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.
	NamedObjectCollection.IContainer<TItem,TContainer>	Represents the container which contains this NamedObjectCollection<TItem,TContainer> collection.
	NamedObjectCollection.IItem<TItem,TContainer>	Represents the type of elements in this NamedObjectCollection<TItem,TContainer> collection.

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 position of cell.
	CfExecutedResult	Represents the matched conditional formatting result.
	CfIcon	Represents a single icon of an icon set.
	CfValue
	Chunk	Stores an ordered pair of integers.
	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.
	StyleFormat
	TableColumn	Represents a table column.
	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.
	AxisProperty	Properties of axis
	Behaviors	Represents the behaviors of operations.
	BorderLineStyle	Enum the line style for border.
	BorderSides
	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.
	CellProtectionAttributes	Represents the cell protection attributes.
	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	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.
	DefaultNumberFormats
	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.
	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 choise 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.
	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.
	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.
	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 protected data of the 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

Product Support Forum | Print this page