GrapeCity.Xaml.SpreadSheet.Data
Worksheet Class Members
Properties  Methods  Events


The following tables list the members exposed by Worksheet.

Public Constructors
 NameDescription
Public ConstructorWorksheet ConstructorOverloaded.   
Top
Public Properties
 NameDescription
Public PropertyActiveCell Gets the active cell in the sheet.  
Public PropertyActiveColumn Gets the active column in the sheet.  
Public PropertyActiveColumnIndex Gets or sets the column index of the active cell in the sheet.  
Public PropertyActiveRow Gets the active row in the sheet.  
Public PropertyActiveRowIndex Gets or sets the row index of the active cell in the sheet.  
Public PropertyAutoGenerateColumns Gets or sets whether to automatically generate the columns for a sheet based on the data source.  
Public PropertyCalcManager  
Public PropertyCells Gets the two-dimensional collection of Cell objects.  
Public PropertyCharts Gets the charts.  
Public PropertyColumnCount Gets or sets the number of columns in the sheet.  
Public PropertyColumnHeader Gets the column header area of the sheet.  
Public PropertyColumnHeaderSpanModel Gets the column header span model.  
Public PropertyColumnRangeGroup Gets the column range group.  
Public PropertyColumns Gets the one-dimensional collection of Column objects.  
Public PropertyConditionalFormats Gets the conditional format for the sheet.  
Public PropertyCustomFunctions Gets the name of all custom functions.  
Public PropertyCustomNames Gets all custom names.  
Public PropertyDataAutoHeadings Gets or sets whether to automatically generate column names for a sheet based on the data source.  
Public PropertyDataSource Gets or sets the data source that populates the sheet.  
Public PropertyDefaultColumnWidth Gets or sets the default column width.  
Public PropertyDefaultRowHeight Gets or sets the default row height.  
Public PropertyDefaultStyle Gets or sets default style information for the workbook.  
Public PropertyFloatingObjects Gets the floating objects.  
Public PropertyFrozenColumnCount Gets or sets the number of nonscrolling columns on the leading edge of this sheet.  
Public PropertyFrozenRowCount Gets or sets the number of nonscrolling rows on the leading edge of this sheet.  
Public PropertyFrozenTrailingColumnCount Gets or sets the number of nonscrolling columns on the trailing edge of this sheet.  
Public PropertyFrozenTrailingRowCount Gets or sets the number of nonscrolling rows on the trailing edge of this sheet.  
Public PropertyGridLineColor Gets or sets the gridline color.  
Public PropertyItemOverloaded.  Gets a new cell with a specified tag, or returns null if there is no cell with the specified tag.  
Public PropertyLastNonEmptyRowIndex Gets the last nonempty bound row index on the sheet.  
Public PropertyName Gets or sets the name of the sheet.  
Public PropertyNamedStyles Gets or sets a collection of StyleInfo objects for this sheet.  
Public PropertyNonEmptyRowCount Gets the number of rows in cell blocks that contain data, styles, tags, or sparklines.  
Public PropertyPictures Gets the pictures.  
Public PropertyPrintInfo Gets or sets the print information for printing to PDF.  
Public PropertyProtect Gets or sets whether cells on this sheet that are marked as protected are uneditable.  
Public PropertyReferenceStyle Gets or sets the style for cell and range references in cell formulas on this sheet.  
Public PropertyRowCount Gets or sets the number of rows in the sheet.  
Public PropertyRowFilter Gets or sets the row filter for the sheet.  
Public PropertyRowHeader Gets the row header area of the sheet.  
Public PropertyRowHeaderSpanModel Gets the row header span model.  
Public PropertyRowRangeGroup Gets the row range group.  
Public PropertyRows Gets the one-dimensional collection of Row objects.  
Public PropertySelectionBackground Gets or sets a Brush object for the selection style.  
Public PropertySelectionBorderColor Gets or sets a Color object for the selection style.  
Public PropertySelectionBorderThemeColor Gets or sets a string object for the selection style.  
Public PropertySelectionPolicy Gets or sets whether users can select ranges of items.  
Public PropertySelections Returns a collection of selected cell ranges.  
Public PropertySelectionUnit Gets or sets whether users can select cells, rows, or columns.  
Public PropertySheetTabColor A color object used to represent the sheet tab color.  
Public PropertySheetTabThemeColor A theme color used to represent the sheet tab color.  
Public PropertyShowGridLine Determines whether to show gridlines.  
Public PropertySpanModel Gets the sheet span model.  
Public PropertyStartingColumnNumber Gets or sets the number or letter displayed in the first column header in this sheet.  
Public PropertyStartingRowNumber Gets or sets the number or letter displayed in the first row header in this sheet.  
Public PropertyTag Gets or sets the tag.  
Public PropertyTouchSelectionGripperBackgroundColor Gets or sets a Color object for the selection style.  
Public PropertyTouchSelectionGripperBackgroundThemeColor Gets or sets a string object for the selection style.  
Public PropertyVisible Gets or sets a value that indicates whether to display the sheet.  
Public PropertyWorkbook Gets the parent workbook for this sheet.  
Public PropertyZoomFactor Gets or sets the scaling factor for displaying this sheet.  
Top
Public Methods
 NameDescription
Public MethodAddChartOverloaded.  Adds the chart in the sheet.  
Public MethodAddColumnsOverloaded.  Adds the column or columns to the data model at the specified index.  
Public MethodAddColumnViewport Adds the column viewport.  
Public MethodAddCustomFunction Adds the specified user-defined custom function to the collection.  
Public MethodAddPictureOverloaded.  Adds the picture.  
Public MethodAddRowsOverloaded.  Adds rows in this sheet.  
Public MethodAddRowViewport Adds the row viewport.  
Public MethodAddSelectionOverloaded.  Adds a cell range to the selection.  
Public MethodAddSpanCellOverloaded.  Adds a span of cells in this sheet in the specified sheet area.  
Public MethodAddTableOverloaded.  Adds a range table with a specified size to the sheet.  
Public MethodBindDataColumn Binds the column to the data source column for a sheet.  
Public MethodClearOverloaded.  Clears the specified area.  
Public MethodClearCustomFunctions Removes all user-defined custom functions (FunctionInfo object) on this sheet.  
Public MethodClearCustomName Clears the specified name in the name collection.  
Public MethodClearCustomNames Removes all custom names on this sheet.  
Public MethodClearSelectionOverloaded.  Clears the specified selection range from the selection list, if one exists.  
Public MethodClearSelections Clears the selections.  
Public MethodClearSpanCells Clears the span that contains a specified anchor cell from a range of cells in the specified sheet area.  
Public MethodCopyTo Copies data from one range to another.  
Public MethodExtendSelection Specifies the last cell in the selection of cells.  
Public MethodFillAutoOverloaded.  Fills the specified range in the specified direction.  
Public MethodFillDateOverloaded.  Fills the specified range when the source value type is date.  
Public MethodFillGrowthOverloaded.  Fills the specified range growth trend when the source value type is number.  
Public MethodFillLinearOverloaded.  Fills the specified range linear trend when the source value type is number.  
Public MethodFindChart Finds the chart with specified name.  
Public MethodFindFloatingObject Finds the floating object with specified name.  
Public MethodFindFormulas Gets formulas in the specified area.  
Public MethodFindPicture Finds the picture with specified name.  
Public MethodFindTableOverloaded.  Gets the table of the specified cell.  
Public MethodGetActiveColumnViewportIndex Gets the index of the active column viewport.  
Public MethodGetActiveRowViewportIndex Gets the index of the active row viewport.  
Public MethodGetActualColumnVisible Gets whether a column in the specified sheet area is displayed.  
Public MethodGetActualColumnWidthOverloaded.  Gets the width in pixels for the specified column in the specified sheet area.  
Public MethodGetActualRowHeightOverloaded.  Gets the height in pixels for the specified row in the specified sheet area.  
Public MethodGetActualRowVisible Gets whether the control displays the specified row in the specified sheet area.  
Public MethodGetActualStyleInfoOverloaded.  Gets the actual style information for a specified cell in the specified sheet area.  
Public MethodGetArrayOverloaded.  Gets an object array from a specified range of cells.  
Public MethodGetArrayFormula Gets the formula in the specified area in this sheet.  
Public MethodGetColumnAutoText Gets the automatic text displayed in the column header for the specified column.  
Public MethodGetColumnDataType Gets the column data type at the specified position.  
Public MethodGetColumnLabelOverloaded.  Gets the text in the specified column header cell.  
Public MethodGetColumnResizableOverloaded.  Gets a value that indicates whether the user can resize a specified column in the specified sheet area.  
Public MethodGetColumnViewportCount Gets the column viewport count.  
Public MethodGetColumnVisibleOverloaded.  Gets whether a column in this sheet is displayed.  
Public MethodGetColumnWidthOverloaded.  Gets the width in pixels for the specified column in the specified sheet area.  
Public MethodGetCsvOverloaded.  Gets the CSV text from a range.  
Public MethodGetCustomFunction Gets the specified user-defined custom function.  
Public MethodGetCustomName Finds the specified custom name.  
Public MethodGetDataColumnName Gets the column name at the specified position.  
Public MethodGetDrawingObject Gets the data bar object or icon object of the current sheet in the specified range.  
Public MethodGetFillText  
Public MethodGetFormula Gets the formula in the specified cell in this sheet.  
Public MethodGetGridLine Gets the control gridline; the gridline color is based on the ShowGridLine property.  
Public MethodGetLastDirtyColumn Gets the last dirty column index.  
Public MethodGetLastDirtyRow Gets the last dirty row index.  
Public MethodGetNonEmptyColumns Returns a list of nonempty column indexes.  
Public MethodGetNonEmptyRows Returns a list of nonempty row indexes.  
Public MethodGetRowAutoText Gets the automatic text displayed in the row header for the specified row.  
Public MethodGetRowHeightOverloaded.  Gets the height using the specified unit type for the specified row in the specified sheet area.  
Public MethodGetRowLabelOverloaded.  Gets the text in the specified row header cell.  
Public MethodGetRowResizableOverloaded.  Gets a value that indicates whether users can resize the specified row in the specified sheet area.  
Public MethodGetRowViewportCount Gets the row viewport count.  
Public MethodGetRowVisibleOverloaded.  Gets whether the control displays the specified row.  
Public MethodGetSpanCellOverloaded.  Gets the range of cells that are spanned at a specified cell in this sheet.  
Public MethodGetSparkline Gets the sparkline for the specified cell.  
Public MethodGetStyleInfoOverloaded.  Gets the style information of the specified cell, row, or column.  
Public MethodGetStyleNameOverloaded.  Gets the name of the style assigned to a cell, column, row, or default model in the specified sheet area.  
Public MethodGetTables Gets the sheet tables.  
Public MethodGetTagOverloaded.  Gets the application-defined tag value for the specified cell, column, row, or entire sheet in the specified sheet area.  
Public MethodGetTextOverloaded. Gets the formatted text in the cell in the specified sheet area using the IFormatter object for the cell.  
Public MethodGetValueOverloaded.  Gets unformatted data from the specified cell.  
Public MethodGetViewportHeight Gets the height of the viewport.  
Public MethodGetViewportInfo Gets the viewport information of the current sheet.  
Public MethodGetViewportLeftColumn Gets the viewport left column.  
Public MethodGetViewportTopRow Gets the viewport top row.  
Public MethodGetViewportWidth Gets the width of the viewport.  
Public MethodGroupSparkline Groups the sparklines.  
Public MethodInvalidateFormulas Invalidates all formulas that are intersected with a specified range.  
Public MethodIsAnyCellInColumnSelected Determines whether any cell in the specified column is in the selection.  
Public MethodIsAnyCellInRowSelected Determines whether any cell in the specified row is in the selection.  
Public MethodIsColumnBound Gets whether the specified column is bound to a data source.  
Public MethodIsRowBound Gets whether the specified row is bound to a data source.  
Public MethodIsSelected Determines whether the specified cell is in the selection.  
Public MethodIsValid Determines whether the specified cell value is valid.  
Public MethodMoveTableOverloaded.  Changes the table location.  
Public MethodMoveTo Moves data from one range to another.  
Public MethodNextActualVisibleColumn Gets the index of the next visible column from the current column.  
Public MethodNextActualVisibleRow Gets the index of the next visible row from the current row.  
Public MethodNextNonEmptyColumnOverloaded.  Returns the next nonempty column index for the specified column.  
Public MethodNextNonEmptyRowOverloaded.  Returns the next nonempty row index for the specified column.  
Public MethodOpenCsvAsyncOverloaded.  Loads the CSV (comma-separated values) file asynchronously.  
Public MethodOpenTextFileAsyncOverloaded.  Loads the CSV file with the specified separator asynchronously.  
Public MethodOpenXml Loads the XML stream to build a new worksheet.  
Public MethodOpenXmlAsyncOverloaded.  Loads the XML stream to build a new worksheet asynchronously.  
Public Methodstatic (Shared in Visual Basic)ParseCsv Parses the string to a two dimensional array.  
Public MethodPreviousActualVisibleColumn Gets the index of the previous visible column from the current column.  
Public MethodPreviousActualVisibleRow Gets the index of the previous visible row from the current row.  
Public MethodRecalculateOverloaded.  Evaluates all the cell formulas on the sheet that have changed since the last calculation cycle.  
Public MethodReloadBindingData Reloads the binding data.  
Public MethodRemoveChart Removes the chart with specified name.  
Public MethodRemoveColumnsOverloaded.  Removes the column or columns on this sheet at the specified index.  
Public MethodRemoveColumnViewport Removes the column viewport.  
Public MethodRemoveCustomFunctions Removes the specified user-defined custom function.  
Public MethodRemoveFloatingObject Removes the floating object with the specified name.  
Public MethodRemovePicture Removes the picture with the specified name.  
Public MethodRemoveRowsOverloaded.  Removes the row or rows on this sheet at the specified index.  
Public MethodRemoveRowViewport Removes the row viewport.  
Public MethodRemoveSpanCellOverloaded.  Removes the span that contains a specified anchor cell from a range of cells in the specified sheet area.  
Public MethodRemoveSparkline Removes the sparkline of the specified cell.  
Public MethodRemoveTableOverloaded.  Removes a specified table.  
Public MethodResetTouchSelectionGripperBackgroundColor Resets the color of the touch selection gripper background.  
Public MethodResetTouchSelectionGripperBackgroundThemeColor Resets the theme color of the touch selection gripper background.  
Public MethodResizeTableOverloaded.  Changes the table size.  
Public MethodResumeCalcService Resumes the calculation service.  
Public MethodResumeSpanModelEvent Resumes the SpanModel, RowHeaderSpanModel, and ColumnHeaderSpanModel events.  
Public MethodSaveCsvAsyncOverloaded.  Saves the CSV (comma-separated values) file asynchronously.  
Public MethodSaveHtmlAsync Saves the data on the sheet to the specified stream asynchronously.  
Public MethodSavePdfAsyncOverloaded.  Saves the sheet to the specified stream asynchronously.  
Public MethodSaveTextFileRangeAsyncOverloaded.  Saves the range of cells in the sheet as delimited text and saves to a stream with the specified delimiters asynchronously.  
Public MethodSaveXmlAsyncOverloaded.  Saves the worksheet to an XML stream asynchronously.  
Public MethodSearchOverloaded.  Searches the text in the cells in the specified sheet for the specified string with the specified criteria and start and end location, and whether to search notes and tags as well.  
Public MethodSetActiveCellOverloaded.  Sets the active cell on this sheet.  
Public MethodSetActiveViewport Sets the active viewport.  
Public MethodSetArrayOverloaded.  Sets the values in the specified two-dimensional array of objects into the specified range of cells on this sheet.  
Public MethodSetArrayFormula Sets an array formula in a specified cell area in the specified sheet area.  
Public MethodSetBorderOverloaded.  Sets the border for the specified area.  
Public MethodSetColumnLabel Sets the value for a specified cell in a column header on this sheet.  
Public MethodSetColumnResizableOverloaded.  Sets whether users can resize individual columns in the specified sheet area.  
Public MethodSetColumnVisible Sets whether a column in the specified sheet area is displayed.  
Public MethodSetColumnWidth Sets the width using the specified unit type for the specified columns in this sheet.  
Public MethodSetCsvOverloaded.  Sets CSV text in the sheet.  
Public MethodSetCustomNameOverloaded.  Sets a custom name using the specified formula.  
Public MethodSetDataSource Sets the data source that populates the sheet.  
Public MethodSetExcelReadService  
Public MethodSetFormulaOverloaded.  Sets a formula in a specified cell in the specified sheet area.  
Public MethodSetRowHeight Sets the height using the specified unit type for the specified row in the specified sheet area.  
Public MethodSetRowLabel Sets the value for a specified cell in a row header on this sheet.  
Public MethodSetRowResizableOverloaded.  Sets whether users can resize the specified row in the specified sheet area.  
Public MethodSetRowVisible Sets whether the control displays the specified row in the specified sheet area.  
Public MethodSetSelectionOverloaded.  Selects the specified cells.  
Public MethodSetSparklineOverloaded.  Sets the sparkline to a cell.  
Public MethodSetStyleInfoOverloaded.  Sets the style for the specified cell, row, or column.  
Public MethodSetStyleNameOverloaded.  Sets the style for the specified cell, column, row, or default model to the specified style name.  
Public MethodSetTagOverloaded.  Sets the application-defined tag value for the specified cell, column, row, or entire sheet for the specified sheet area.  
Public MethodSetTextOverloaded. Sets the formatted text in the cell in the specified sheet area using the IFormatter object for the cell.  
Public MethodSetValueOverloaded.  Sets the value for the specified cell in the specified sheet area.  
Public MethodSetViewportHeight Sets the height of the viewport.  
Public MethodSetViewportInfo Sets the viewport information to the current sheet.  
Public MethodSetViewportWidth Sets the width of the viewport.  
Public MethodSortRange Sorts a range of cells in this sheet in the data model.  
Public MethodSuspendCalcService Suspends the calculation service.  
Public MethodSuspendSpanModelEvent Suspends the SpanModel, RowHeaderSpanModel, and ColumnHeaderSpanModel events.  
Public MethodUngroupSparkline Ungroups the sparklines in the group.  
Top
Public Events
 NameDescription
Public EventCellChanged Occurs when a change is made to a cell or range of cells in this sheet that may require the cell or range of cells to be repainted.  
Public EventChartChanged Occurs when the chart has changed.  
Public EventChartSelectionChanged Occurs when the chart selection has changed.  
Public EventColumnChanged Occurs when a change is made to a column or range of columns in this sheet that may require the column or range of columns to be repainted.  
Public EventColumnsSwapped Occurs when two columns are swapped during sorting.  
Public EventFloatingObjectChanged Occurs when the floating object has changed.  
Public EventFloatingObjectSelectionChanged Occurs when the floating object selection has changed.  
Public EventPictureChanged Occurs when the picture has changed.  
Public EventPictureSelectionChanged Occurs when the picture selection has changed.  
Public EventPropertyChanged Occurs when the user changes a sheet property.  
Public EventRowChanged Occurs when a change is made to a row or range of rows in this sheet that may require the row or range of rows to be repainted.  
Public EventRowsSwapped Occurs when two rows are swapped during sorting.  
Public EventSelectionChanged Occurs when selections are changed that may require the selection area to be repainted.  
Top
See Also

Reference

Worksheet Class
GrapeCity.Xaml.SpreadSheet.Data Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options