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


GrapeCity.Xaml.SpreadSheet.Data Namespace : Worksheet Class

The following tables list the members exposed by Worksheet.

Public Constructors
 NameDescription
Public ConstructorOverloaded.   
Top
Public Properties
 NameDescription
Public Property Gets the active cell in the sheet.  
Public Property Gets the active column in the sheet.  
Public Property Gets or sets the column index of the active cell in the sheet.  
Public Property Gets the active row in the sheet.  
Public Property Gets or sets the row index of the active cell in the sheet.  
Public Property Gets or sets whether to automatically generate the columns for a sheet based on the data source.  
Public Property  
Public Property Gets the two-dimensional collection of Cell objects.  
Public Property Gets the charts.  
Public Property Gets or sets the number of columns in the sheet.  
Public Property Gets the column header area of the sheet.  
Public Property Gets the column header span model.  
Public Property Gets the column range group.  
Public Property Gets the one-dimensional collection of Column objects.  
Public Property Gets the conditional format for the sheet.  
Public Property Gets the name of all custom functions.  
Public Property Gets all custom names.  
Public Property Gets or sets whether to automatically generate column names for a sheet based on the data source.  
Public Property Gets or sets the data source that populates the sheet.  
Public Property Gets or sets the default column width.  
Public Property Gets or sets the default row height.  
Public Property Gets or sets default style information for the workbook.  
Public Property Gets the floating objects.  
Public Property Gets or sets the number of nonscrolling columns on the leading edge of this sheet.  
Public Property Gets or sets the number of nonscrolling rows on the leading edge of this sheet.  
Public Property Gets or sets the number of nonscrolling columns on the trailing edge of this sheet.  
Public Property Gets or sets the number of nonscrolling rows on the trailing edge of this sheet.  
Public Property Gets or sets the gridline color.  
Public PropertyOverloaded.  Gets a new cell with a specified tag, or returns null if there is no cell with the specified tag.  
Public Property Gets the last nonempty bound row index on the sheet.  
Public Property Gets or sets the name of the sheet.  
Public Property Gets or sets a collection of StyleInfo objects for this sheet.  
Public Property Gets the number of rows in cell blocks that contain data, styles, tags, or sparklines.  
Public Property Gets the pictures.  
Public Property Gets or sets the print information for printing to PDF.  
Public Property Gets or sets whether cells on this sheet that are marked as protected are uneditable.  
Public Property Gets or sets the style for cell and range references in cell formulas on this sheet.  
Public Property Gets or sets the number of rows in the sheet.  
Public Property Gets or sets the row filter for the sheet.  
Public Property Gets the row header area of the sheet.  
Public Property Gets the row header span model.  
Public Property Gets the row range group.  
Public Property Gets the one-dimensional collection of Row objects.  
Public Property Gets or sets a Brush object for the selection style.  
Public Property Gets or sets a Color object for the selection style.  
Public Property Gets or sets a string object for the selection style.  
Public Property Gets or sets whether users can select ranges of items.  
Public Property Returns a collection of selected cell ranges.  
Public Property Gets or sets whether users can select cells, rows, or columns.  
Public Property A color object used to represent the sheet tab color.  
Public Property A theme color used to represent the sheet tab color.  
Public Property Determines whether to show gridlines.  
Public Property Gets the sheet span model.  
Public Property Gets or sets the number or letter displayed in the first column header in this sheet.  
Public Property Gets or sets the number or letter displayed in the first row header in this sheet.  
Public Property Gets or sets the tag.  
Public Property Gets or sets a Color object for the selection style.  
Public Property Gets or sets a string object for the selection style.  
Public Property Gets or sets a value that indicates whether to display the sheet.  
Public Property Gets the parent workbook for this sheet.  
Public Property Gets or sets the scaling factor for displaying this sheet.  
Top
Public Methods
 NameDescription
Public MethodOverloaded.  Adds the chart in the sheet.  
Public MethodOverloaded.  Adds the column or columns to the data model at the specified index.  
Public Method Adds the column viewport.  
Public Method Adds the specified user-defined custom function to the collection.  
Public MethodOverloaded.  Adds the picture.  
Public MethodOverloaded.  Adds rows in this sheet.  
Public Method Adds the row viewport.  
Public MethodOverloaded.  Adds a cell range to the selection.  
Public MethodOverloaded.  Adds a span of cells in this sheet in the specified sheet area.  
Public MethodOverloaded.  Adds a range table with a specified size to the sheet.  
Public Method Binds the column to the data source column for a sheet.  
Public MethodOverloaded.  Clears the specified area.  
Public Method Removes all user-defined custom functions (FunctionInfo object) on this sheet.  
Public Method Clears the specified name in the name collection.  
Public Method Removes all custom names on this sheet.  
Public MethodOverloaded.  Clears the specified selection range from the selection list, if one exists.  
Public Method Clears the selections.  
Public Method Clears the span that contains a specified anchor cell from a range of cells in the specified sheet area.  
Public Method Copies data from one range to another.  
Public Method Specifies the last cell in the selection of cells.  
Public MethodOverloaded.  Fills the specified range in the specified direction.  
Public MethodOverloaded.  Fills the specified range when the source value type is date.  
Public MethodOverloaded.  Fills the specified range growth trend when the source value type is number.  
Public MethodOverloaded.  Fills the specified range linear trend when the source value type is number.  
Public Method Finds the chart with specified name.  
Public Method Finds the floating object with specified name.  
Public Method Gets formulas in the specified area.  
Public Method Finds the picture with specified name.  
Public MethodOverloaded.  Gets the table of the specified cell.  
Public Method Gets the index of the active column viewport.  
Public Method Gets the index of the active row viewport.  
Public Method Gets whether a column in the specified sheet area is displayed.  
Public MethodOverloaded.  Gets the width in pixels for the specified column in the specified sheet area.  
Public MethodOverloaded.  Gets the height in pixels for the specified row in the specified sheet area.  
Public Method Gets whether the control displays the specified row in the specified sheet area.  
Public MethodOverloaded.  Gets the actual style information for a specified cell in the specified sheet area.  
Public MethodOverloaded.  Gets an object array from a specified range of cells.  
Public Method Gets the formula in the specified area in this sheet.  
Public Method Gets the automatic text displayed in the column header for the specified column.  
Public Method Gets the column data type at the specified position.  
Public MethodOverloaded.  Gets the text in the specified column header cell.  
Public MethodOverloaded.  Gets a value that indicates whether the user can resize a specified column in the specified sheet area.  
Public Method Gets the column viewport count.  
Public MethodOverloaded.  Gets whether a column in this sheet is displayed.  
Public MethodOverloaded.  Gets the width in pixels for the specified column in the specified sheet area.  
Public MethodOverloaded.  Gets the CSV text from a range.  
Public Method Gets the specified user-defined custom function.  
Public Method Finds the specified custom name.  
Public Method Gets the column name at the specified position.  
Public Method Gets the data bar object or icon object of the current sheet in the specified range.  
Public Method  
Public Method Gets the formula in the specified cell in this sheet.  
Public Method Gets the control gridline; the gridline color is based on the ShowGridLine property.  
Public Method Gets the last dirty column index.  
Public Method Gets the last dirty row index.  
Public Method Returns a list of nonempty column indexes.  
Public Method Returns a list of nonempty row indexes.  
Public Method Gets the automatic text displayed in the row header for the specified row.  
Public MethodOverloaded.  Gets the height using the specified unit type for the specified row in the specified sheet area.  
Public MethodOverloaded.  Gets the text in the specified row header cell.  
Public MethodOverloaded.  Gets a value that indicates whether users can resize the specified row in the specified sheet area.  
Public Method Gets the row viewport count.  
Public MethodOverloaded.  Gets whether the control displays the specified row.  
Public MethodOverloaded.  Gets the range of cells that are spanned at a specified cell in this sheet.  
Public Method Gets the sparkline for the specified cell.  
Public MethodOverloaded.  Gets the style information of the specified cell, row, or column.  
Public MethodOverloaded.  Gets the name of the style assigned to a cell, column, row, or default model in the specified sheet area.  
Public Method Gets the sheet tables.  
Public MethodOverloaded.  Gets the application-defined tag value for the specified cell, column, row, or entire sheet in the specified sheet area.  
Public MethodOverloaded. Gets the formatted text in the cell in the specified sheet area using the IFormatter object for the cell.  
Public MethodOverloaded.  Gets unformatted data from the specified cell.  
Public Method Gets the height of the viewport.  
Public Method Gets the viewport information of the current sheet.  
Public Method Gets the viewport left column.  
Public Method Gets the viewport top row.  
Public Method Gets the width of the viewport.  
Public Method Groups the sparklines.  
Public Method Invalidates all formulas that are intersected with a specified range.  
Public Method Determines whether any cell in the specified column is in the selection.  
Public Method Determines whether any cell in the specified row is in the selection.  
Public Method Gets whether the specified column is bound to a data source.  
Public Method Gets whether the specified row is bound to a data source.  
Public Method Determines whether the specified cell is in the selection.  
Public Method Determines whether the specified cell value is valid.  
Public MethodOverloaded.  Changes the table location.  
Public Method Moves data from one range to another.  
Public Method Gets the index of the next visible column from the current column.  
Public Method Gets the index of the next visible row from the current row.  
Public MethodOverloaded.  Returns the next nonempty column index for the specified column.  
Public MethodOverloaded.  Returns the next nonempty row index for the specified column.  
Public MethodOverloaded.  Loads the CSV (comma-separated values) file asynchronously.  
Public MethodOverloaded.  Loads the CSV file with the specified separator asynchronously.  
Public Method Loads the XML stream to build a new worksheet.  
Public MethodOverloaded.  Loads the XML stream to build a new worksheet asynchronously.  
Public Methodstatic (Shared in Visual Basic) Parses the string to a two dimensional array.  
Public Method Gets the index of the previous visible column from the current column.  
Public Method Gets the index of the previous visible row from the current row.  
Public MethodOverloaded.  Evaluates all the cell formulas on the sheet that have changed since the last calculation cycle.  
Public Method Reloads the binding data.  
Public Method Removes the chart with specified name.  
Public MethodOverloaded.  Removes the column or columns on this sheet at the specified index.  
Public Method Removes the column viewport.  
Public Method Removes the specified user-defined custom function.  
Public Method Removes the floating object with the specified name.  
Public Method Removes the picture with the specified name.  
Public MethodOverloaded.  Removes the row or rows on this sheet at the specified index.  
Public Method Removes the row viewport.  
Public MethodOverloaded.  Removes the span that contains a specified anchor cell from a range of cells in the specified sheet area.  
Public Method Removes the sparkline of the specified cell.  
Public MethodOverloaded.  Removes a specified table.  
Public Method Resets the color of the touch selection gripper background.  
Public Method Resets the theme color of the touch selection gripper background.  
Public MethodOverloaded.  Changes the table size.  
Public Method Resumes the calculation service.  
Public Method Resumes the SpanModel, RowHeaderSpanModel, and ColumnHeaderSpanModel events.  
Public MethodOverloaded.  Saves the CSV (comma-separated values) file asynchronously.  
Public Method Saves the data on the sheet to the specified stream asynchronously.  
Public MethodOverloaded.  Saves the sheet to the specified stream asynchronously.  
Public MethodOverloaded.  Saves the range of cells in the sheet as delimited text and saves to a stream with the specified delimiters asynchronously.  
Public MethodOverloaded.  Saves the worksheet to an XML stream asynchronously.  
Public MethodOverloaded.  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 MethodOverloaded.  Sets the active cell on this sheet.  
Public Method Sets the active viewport.  
Public MethodOverloaded.  Sets the values in the specified two-dimensional array of objects into the specified range of cells on this sheet.  
Public Method Sets an array formula in a specified cell area in the specified sheet area.  
Public MethodOverloaded.  Sets the border for the specified area.  
Public Method Sets the value for a specified cell in a column header on this sheet.  
Public MethodOverloaded.  Sets whether users can resize individual columns in the specified sheet area.  
Public Method Sets whether a column in the specified sheet area is displayed.  
Public Method Sets the width using the specified unit type for the specified columns in this sheet.  
Public MethodOverloaded.  Sets CSV text in the sheet.  
Public MethodOverloaded.  Sets a custom name using the specified formula.  
Public Method Sets the data source that populates the sheet.  
Public Method  
Public MethodOverloaded.  Sets a formula in a specified cell in the specified sheet area.  
Public Method Sets the height using the specified unit type for the specified row in the specified sheet area.  
Public Method Sets the value for a specified cell in a row header on this sheet.  
Public MethodOverloaded.  Sets whether users can resize the specified row in the specified sheet area.  
Public Method Sets whether the control displays the specified row in the specified sheet area.  
Public MethodOverloaded.  Selects the specified cells.  
Public MethodOverloaded.  Sets the sparkline to a cell.  
Public MethodOverloaded.  Sets the style for the specified cell, row, or column.  
Public MethodOverloaded.  Sets the style for the specified cell, column, row, or default model to the specified style name.  
Public MethodOverloaded.  Sets the application-defined tag value for the specified cell, column, row, or entire sheet for the specified sheet area.  
Public MethodOverloaded. Sets the formatted text in the cell in the specified sheet area using the IFormatter object for the cell.  
Public MethodOverloaded.  Sets the value for the specified cell in the specified sheet area.  
Public Method Sets the height of the viewport.  
Public Method Sets the viewport information to the current sheet.  
Public Method Sets the width of the viewport.  
Public Method Sorts a range of cells in this sheet in the data model.  
Public Method Suspends the calculation service.  
Public Method Suspends the SpanModel, RowHeaderSpanModel, and ColumnHeaderSpanModel events.  
Public Method Ungroups the sparklines in the group.  
Top
Public Events
 NameDescription
Public Event 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 Event Occurs when the chart has changed.  
Public Event Occurs when the chart selection has changed.  
Public Event 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 Event Occurs when two columns are swapped during sorting.  
Public Event Occurs when the floating object has changed.  
Public Event Occurs when the floating object selection has changed.  
Public Event Occurs when the picture has changed.  
Public Event Occurs when the picture selection has changed.  
Public Event Occurs when the user changes a sheet property.  
Public Event 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 Event Occurs when two rows are swapped during sorting.  
Public Event 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