Aspose.Cells.GridWeb.Data

The Aspose.Cells.GridWeb.Data namespace contains classes of data control objects such WebWorksheet, GridRow, GridCell, GridPicture, GridPivotTable and more.

Classes

Class	Description
CellAttachObject	Represents an cell’s attachment object like Comment, Hyperlink, etc.
CellErrorHandler	Represents the interface that intend to handle cell error events.
CellEventHandler	Represents the interface that intend to handle cell events.
CellEventStringHandler	Represents the method that intend to handle cell events. same as CellEventHandler interface,but return string result
CellImage	Reprensents a hyperlink with image src.
CustomCommandEventHandler	Represents the interface that intend to handle Custom Command events.
GridAbstractCalculationEngine	Represents user’s custom calculation engine to extend the default calculation engine of Aspose.Cells.
GridCalculationData	Represents the required data when calculating one function, such as function name, parameters, …etc.
GridCell	Represents a cell object.
GridCellArea	Represents an area of cells.
GridCellException	Represents a cell operation error.
GridCells	Encapsulates a collection of GridCell objects.
GridColumn	Represents a single column in a worksheet.
GridColumnCollection	Collects the objects that represent the individual columns in a worksheet.
GridComment	Encapsulates the object that represents a cell comment.
GridCommentCollection	Encapsulates a collection of GridComment objects.
GridHtmlSaveOptions	Represents the options for saving html file.
GridHyperlink	Encapsulates the object that represents a hyperlink.
GridHyperlinkCollection	Encapsulates a collection of GridHyperlink objects.
GridLoadOptions	Represents the options of loading the file. [Obsolete(“This class will be obsoleted after stand alone dll usage of cells public api,instead you can use Aspose.Cells.LodOptions “)]
GridName	Encapsulates the object that represents a name object.
GridNameCollection	Encapsulates a collection of GridName objects.
GridPicture	Encapsulates the object that represents a single picture in a spreadsheet.
GridPictureCollection	Encapsulates a collection of GridPicture objects.
GridPivotField	Represents a field in a PivotTable report.
GridPivotFieldCollection	Encapsulates a collection of GridPivotField objects.
GridPivotItem	Represents a item in a PivotField report.
GridPivotItemCollection	Encapsulates a collection of GridPivotItem objects.
GridPivotTable	Represents a PivotTable report on a worksheet. The PivotTable object is a member of the GridPivotTable collection. The PivotTables collection contains all the PivotTable objects on a control.
GridPivotTableCollection	Encapsulates a collection of GridPivotTable objects.
GridReferredArea	Represents a referred objcet by the formula.
GridRow	Encapsulates the object that represents a single picture in a spreadsheet.
GridRowCollection	Encapsulates a collection of GridRow objects.
GridSaveOptions	Represents all save options
GridShape	Represents a shape object.
GridShapeCollection	Encapsulates a collection of GridShape objects.
GridTxtLoadOptions	Represents the options for loading text file.
GridValidation	Represents data validation.settings.
GridValidationCollection	Encapsulates a collection of GridValidation objects.
GridWebException	The exception that is thrown when Aspose.Cells.GridWeb specified error occurs.
GridWorkbook	Represents a root object to create an Excel spreadsheet.
GridWorkbookSettings	Represents settings of the workbook.
GridWorksheet	Encapsulates the object that represents a single worksheet.
GridWorksheetCollection	Encapsulates a collection of GridWorksheet objects.
Hyperlink
Hyperlinks
InitializeNewBindRowHandler	Represents the method that intend to handle InitializeNewBindRow event. sender: The worksheet object. bindObject: The new created bind object. Generally it’s a DataRowView object.
OnErrorActionQuery	Used in the CellError event of the GridWeb.
PivotCache	Represents the memory cache for a PivotTable report. The PivotCache object is a member of the PivotCaches collection.
PivotCaches	Represents the collection of memory caches from the PivotTable reports in a workbook. Each memory cache is represented by a PivotCache object.
PivotField	Represents a field in a PivotTable report. The PivotField object is a member of the PivotFields collection. NOTE: This class is now obsolete. Instead, please use GridPivotField. This class will be removed after 6 months since Aug. 2014. Aspose apologizes for any inconvenience you may have experienced.
PivotFields	Reprents A collection of all the PivotField objects in a PivotTable report.
PivotItem	Represents an item in a PivotTable field. The items are the individual data entries in a field category. The PivotItem object is a member of the PivotItems collection. The PivotItems collection contains all the items in a PivotField object.
PivotItems	Represents A collection of all the PivotItem objects in a PivotTable field. The items are the individual data entries in a field category.
PivotTable	Represents a PivotTable report on a worksheet. The PivotTable object is a member of the PivotTables collection. The PivotTables collection contains all the PivotTable objects on a control.
PivotTables	Represents a collection of all the PivotTable objects
RowColumnEventHandler	Represents the interface that intend to handle row/column events.
RowFilterSettings	Summary description for RowFilter.
SheetEventHandler	Represents the interface that intend to handle sheet events.
WebCell
WebCellArea
WebCellException	Represents a cell operation error.
WebCells
WebComment
WebComments
WebWorksheet	Represents a web worksheet.
WebWorksheets
WorkbookEventHandler	Represents the interface that intend to handle workbook events.

Interfaces

Interface	Description
GridCustomServerValidation	the interface you need to implement when use server side validation. CustomServerFunction.
ICustomFilter	Summary description for ICustomFilter.

Enumeration

Enumeration	Description
GridCellErrorType	Used in WebCellException. Represents the cell error type.
GridImageType	Specifies the type (format) of an image.
GridMsoDrawingType	Represents office drawing objects type.
GridOperatorType	Represents the operator type of conditional format and data validation.
GridPivotFieldFunction	Represents consolidation function.
GridPivotFieldType	Represents PivotTable field type.
GridSaveFormat	Enumerates supported file format types.
GridShiftType	Represent the shift options when deleting a range of cells.
GridValidationType	Represents data validation type.
HyperlinkActionType	Hyperlink has two action type: UrlLink and CellCommand. UrlLink type hyperlink is an anchor in a cell, click it will navigate to another page or open a new browser window. CellCommand type hyperlink is an command button in a cell, click it will generate a server side event.
NumberType	Represents the number or datetime format type.
OnErrorActionType	Used in CellError event of the GridWeb. User set the OnErrorActionQuery.OnErrorAction to tell the control Stop processing or Ignore error.
PivotFieldFunction	Represents functions used to summarize the PivotTable data field
PivotFieldOrientation	Represents The location of the field in the specified PivotTable report.
PivotFieldSort	Represents the order used to sort the specified PivotTable field.
PivotSourceType	Represents the source data type.
SortByOrder	Represents what order the data sort by.
SortOrientation	Represents sorting orientation
SubtotalFunction	Represents subtotal function type. Used in the GridWorksheet.CreateSubtotal method.
WebCellErrorType	Used in WebCellException. Represents the cell error type.