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

ClassDescription
CellAttachObjectRepresents an cell’s attachment object like Comment, Hyperlink, etc.
CellErrorHandlerRepresents the interface that intend to handle cell error events.
CellEventHandlerRepresents the interface that intend to handle cell events.
CellEventStringHandlerRepresents the method that intend to handle cell events. same as CellEventHandler interface,but return string result
CellImageReprensents a hyperlink with image src.
CustomCommandEventHandlerRepresents the interface that intend to handle Custom Command events.
GridAbstractCalculationEngineRepresents user’s custom calculation engine to extend the default calculation engine of Aspose.Cells.
GridCalculationDataRepresents the required data when calculating one function, such as function name, parameters, …etc.
GridCellRepresents a cell object.
GridCellAreaRepresents an area of cells.
GridCellExceptionRepresents a cell operation error.
GridCellsEncapsulates a collection of GridCell objects.
GridColumnRepresents a single column in a worksheet.
GridColumnCollectionCollects the objects that represent the individual columns in a worksheet.
GridCommentEncapsulates the object that represents a cell comment.
GridCommentCollectionEncapsulates a collection of GridComment objects.
GridHtmlSaveOptionsRepresents the options for saving html file.
GridHyperlinkEncapsulates the object that represents a hyperlink.
GridHyperlinkCollectionEncapsulates a collection of GridHyperlink objects.
GridLoadOptionsRepresents 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 “)]
GridNameEncapsulates the object that represents a name object.
GridNameCollectionEncapsulates a collection of GridName objects.
GridPictureEncapsulates the object that represents a single picture in a spreadsheet.
GridPictureCollectionEncapsulates a collection of GridPicture objects.
GridPivotFieldRepresents a field in a PivotTable report.
GridPivotFieldCollectionEncapsulates a collection of GridPivotField objects.
GridPivotItemRepresents a item in a PivotField report.
GridPivotItemCollectionEncapsulates a collection of GridPivotItem objects.
GridPivotTableRepresents 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.
GridPivotTableCollectionEncapsulates a collection of GridPivotTable objects.
GridReferredAreaRepresents a referred objcet by the formula.
GridRowEncapsulates the object that represents a single picture in a spreadsheet.
GridRowCollectionEncapsulates a collection of GridRow objects.
GridSaveOptionsRepresents all save options
GridShapeRepresents a shape object.
GridShapeCollectionEncapsulates a collection of GridShape objects.
GridTxtLoadOptionsRepresents the options for loading text file.
GridValidationRepresents data validation.settings.
GridValidationCollectionEncapsulates a collection of GridValidation objects.
GridWebExceptionThe exception that is thrown when Aspose.Cells.GridWeb specified error occurs.
GridWorkbookRepresents a root object to create an Excel spreadsheet.
GridWorkbookSettingsRepresents settings of the workbook.
GridWorksheetEncapsulates the object that represents a single worksheet.
GridWorksheetCollectionEncapsulates a collection of GridWorksheet objects.
Hyperlink
Hyperlinks
InitializeNewBindRowHandlerRepresents the method that intend to handle InitializeNewBindRow event. sender: The worksheet object. bindObject: The new created bind object. Generally it’s a DataRowView object.
OnErrorActionQueryUsed in the CellError event of the GridWeb.
PivotCacheRepresents the memory cache for a PivotTable report. The PivotCache object is a member of the PivotCaches collection.
PivotCachesRepresents the collection of memory caches from the PivotTable reports in a workbook. Each memory cache is represented by a PivotCache object.
PivotFieldRepresents 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.
PivotFieldsReprents A collection of all the PivotField objects in a PivotTable report.
PivotItemRepresents 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.
PivotItemsRepresents A collection of all the PivotItem objects in a PivotTable field. The items are the individual data entries in a field category.
PivotTableRepresents 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.
PivotTablesRepresents a collection of all the PivotTable objects
RowColumnEventHandlerRepresents the interface that intend to handle row/column events.
RowFilterSettingsSummary description for RowFilter.
SheetEventHandlerRepresents the interface that intend to handle sheet events.
WebCell
WebCellArea
WebCellExceptionRepresents a cell operation error.
WebCells
WebComment
WebComments
WebWorksheetRepresents a web worksheet.
WebWorksheets
WorkbookEventHandlerRepresents the interface that intend to handle workbook events.

Interfaces

InterfaceDescription
GridCustomServerValidationthe interface you need to implement when use server side validation. CustomServerFunction.
ICustomFilterSummary description for ICustomFilter.

Enumeration

EnumerationDescription
GridCellErrorTypeUsed in WebCellException. Represents the cell error type.
GridImageTypeSpecifies the type (format) of an image.
GridMsoDrawingTypeRepresents office drawing objects type.
GridOperatorTypeRepresents the operator type of conditional format and data validation.
GridPivotFieldFunctionRepresents consolidation function.
GridPivotFieldTypeRepresents PivotTable field type.
GridSaveFormatEnumerates supported file format types.
GridShiftTypeRepresent the shift options when deleting a range of cells.
GridValidationTypeRepresents data validation type.
HyperlinkActionTypeHyperlink 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.
NumberTypeRepresents the number or datetime format type.
OnErrorActionTypeUsed in CellError event of the GridWeb. User set the OnErrorActionQuery.OnErrorAction to tell the control Stop processing or Ignore error.
PivotFieldFunctionRepresents functions used to summarize the PivotTable data field
PivotFieldOrientationRepresents The location of the field in the specified PivotTable report.
PivotFieldSortRepresents the order used to sort the specified PivotTable field.
PivotSourceTypeRepresents the source data type.
SortByOrderRepresents what order the data sort by.
SortOrientationRepresents sorting orientation
SubtotalFunctionRepresents subtotal function type. Used in the GridWorksheet.CreateSubtotal method.
WebCellErrorTypeUsed in WebCellException. Represents the cell error type.