Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / Worksheet Class
Properties Methods Events

In This Topic
    Worksheet Class Members
    In This Topic

    The following tables list the members exposed by Worksheet.

    Public Constructors
     NameDescription
    Public ConstructorOverloaded.   
    Top
    Public Properties
     NameDescription
    Public PropertyGets the active cell in the sheet.  
    Public PropertyGets the active column in the sheet.  
    Public PropertyGets or sets the column index of the active cell in the sheet.  
    Public PropertyGets the active row in the sheet.  
    Public PropertyGets or sets the row index of the active cell in the sheet.  
    Public PropertyGets or sets whether to automatically generate the columns for a sheet based on the data source.  
    Public Property  
    Public PropertyGets the two-dimensional collection of Cell objects.  
    Public PropertyGets the charts.  
    Public PropertyGets or sets the number of columns in the sheet.  
    Public PropertyGets the column header area of the sheet.  
    Public PropertyGets the column header span model.  
    Public PropertyGets the column range group.  
    Public PropertyGets the one-dimensional collection of Column objects.  
    Public PropertyGets the conditional format for the sheet.  
    Public PropertyGets the name of all custom functions.  
    Public PropertyGets all custom names.  
    Public PropertyGets or sets whether to automatically generate column names for a sheet based on the data source.  
    Public PropertyGets or sets the data source that populates the sheet.  
    Public PropertyGets or sets the default column width.  
    Public PropertyGets or sets the default row height.  
    Public PropertyGets or sets default style information for the workbook.  
    Public PropertyGets the floating objects.  
    Public PropertyGets or sets the number of nonscrolling columns on the leading edge of this sheet.  
    Public PropertyGets or sets the number of nonscrolling rows on the leading edge of this sheet.  
    Public PropertyGets or sets the number of nonscrolling columns on the trailing edge of this sheet.  
    Public PropertyGets or sets the number of nonscrolling rows on the trailing edge of this sheet.  
    Public PropertyGets 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 PropertyGets the last nonempty bound row index on the sheet.  
    Public PropertyGets or sets the name of the sheet.  
    Public PropertyGets or sets a collection of StyleInfo objects for this sheet.  
    Public PropertyGets the number of rows in cell blocks that contain data, styles, tags, or sparklines.  
    Public PropertyGets the pictures.  
    Public PropertyGets or sets the print information for printing to PDF.  
    Public PropertyGets or sets whether cells on this sheet that are marked as protected are uneditable.  
    Public PropertyGets or sets the style for cell and range references in cell formulas on this sheet.  
    Public PropertyGets or sets the number of rows in the sheet.  
    Public PropertyGets or sets the row filter for the sheet.  
    Public PropertyGets the row header area of the sheet.  
    Public PropertyGets the row header span model.  
    Public PropertyGets the row range group.  
    Public PropertyGets the one-dimensional collection of Row objects.  
    Public PropertyGets or sets a Brush object for the selection style.  
    Public PropertyGets or sets a Color object for the selection style.  
    Public PropertyGets or sets a string object for the selection style.  
    Public PropertyGets or sets whether users can select ranges of items.  
    Public PropertyReturns a collection of selected cell ranges.  
    Public PropertyGets or sets whether users can select cells, rows, or columns.  
    Public PropertyA color object used to represent the sheet tab color.  
    Public PropertyA theme color used to represent the sheet tab color.  
    Public PropertyDetermines whether to show gridlines.  
    Public PropertyGets the sheet span model.  
    Public PropertyGets or sets the number or letter displayed in the first column header in this sheet.  
    Public PropertyGets or sets the number or letter displayed in the first row header in this sheet.  
    Public PropertyGets the surface charts.  
    Public PropertyGets or sets the tag.  
    Public PropertyGets or sets a Color object for the selection style.  
    Public PropertyGets or sets a string object for the selection style.  
    Public PropertyGets or sets a value that indicates whether to display the sheet.  
    Public PropertyGets the parent workbook for this sheet.  
    Public PropertyGets 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 MethodAdds the column viewport.  
    Public MethodAdds the specified user-defined custom function to the collection.  
    Public MethodOverloaded. Adds the picture.  
    Public MethodOverloaded. Adds rows in this sheet.  
    Public MethodAdds 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 the surface chart.  
    Public MethodOverloaded. Adds a range table with a specified size to the sheet.  
    Public MethodBinds the column to the data source column for a sheet.  
    Public MethodOverloaded. Clears the specified area.  
    Public MethodRemoves all user-defined custom functions (FunctionInfo object) on this sheet.  
    Public MethodClears the specified name in the name collection.  
    Public MethodRemoves all custom names on this sheet.  
    Public MethodOverloaded. Clears the specified selection range from the selection list, if one exists.  
    Public MethodClears the selections.  
    Public MethodClears the span that contains a specified anchor cell from a range of cells in the specified sheet area.  
    Public MethodCopies data from one range to another.  
    Public MethodSpecifies 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 MethodFinds the chart with specified name.  
    Public MethodFinds the floating object with specified name.  
    Public MethodGets formulas in the specified area.  
    Public MethodFinds the picture with specified name.  
    Public MethodFinds the surface chart with specified name.  
    Public MethodOverloaded. Gets the table of the specified cell.  
    Public MethodGets the index of the active column viewport.  
    Public MethodGets the index of the active row viewport.  
    Public MethodGets 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 MethodGets 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 MethodGets the formula in the specified area in this sheet.  
    Public MethodGets the automatic text displayed in the column header for the specified column.  
    Public MethodGets 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 MethodGets 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 MethodGets the specified user-defined custom function.  
    Public MethodFinds the specified custom name.  
    Public MethodGets the column name at the specified position.  
    Public MethodGets the data bar object or icon object of the current sheet in the specified range.  
    Public Method  
    Public MethodGets the formula in the specified cell in this sheet.  
    Public MethodGets the control gridline; the gridline color is based on the ShowGridLine property.  
    Public MethodGets the last dirty column index.  
    Public MethodGets the last dirty row index.  
    Public MethodReturns a list of nonempty column indexes.  
    Public MethodReturns a list of nonempty row indexes.  
    Public MethodGets 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 MethodGets 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 MethodGets 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 MethodGets 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 MethodGets the height of the viewport.  
    Public MethodGets the viewport information of the current sheet.  
    Public MethodGets the viewport left column.  
    Public MethodGets the viewport top row.  
    Public MethodGets the width of the viewport.  
    Public MethodGroups the sparklines.  
    Public MethodInvalidates all formulas that are intersected with a specified range.  
    Public MethodDetermines whether any cell in the specified column is in the selection.  
    Public MethodDetermines whether any cell in the specified row is in the selection.  
    Public MethodGets whether the specified column is bound to a data source.  
    Public MethodGets whether the specified row is bound to a data source.  
    Public MethodDetermines whether the specified cell is in the selection.  
    Public MethodDetermines whether the specified cell value is valid.  
    Public MethodOverloaded. Changes the table location.  
    Public MethodMoves data from one range to another.  
    Public MethodGets the index of the next visible column from the current column.  
    Public MethodGets 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.  
    Public MethodOverloaded. Loads the CSV file with the specified separator.  
    Public MethodOverloaded. Loads the XML stream to build a new worksheet.  
    Public Methodstatic (Shared in Visual Basic)Parses the string to a two dimensional array.  
    Public MethodGets the index of the previous visible column from the current column.  
    Public MethodGets 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 MethodReloads the binding data.  
    Public MethodRemoves the chart with specified name.  
    Public MethodOverloaded. Removes the column or columns on this sheet at the specified index.  
    Public MethodRemoves the column viewport.  
    Public MethodRemoves the specified user-defined custom function.  
    Public MethodRemoves the floating object with the specified name.  
    Public MethodRemoves the picture with the specified name.  
    Public MethodOverloaded. Removes the row or rows on this sheet at the specified index.  
    Public MethodRemoves 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 MethodRemoves the sparkline of the specified cell.  
    Public MethodRemoves the surface chart with the specified name.  
    Public MethodOverloaded. Removes a specified table.  
    Public MethodResets the color of the touch selection gripper background.  
    Public MethodResets the theme color of the touch selection gripper background.  
    Public MethodOverloaded. Changes the table size.  
    Public MethodResumes the calculation service.  
    Public MethodResumes the SpanModel, RowHeaderSpanModel, and ColumnHeaderSpanModel events.  
    Public MethodOverloaded. Saves the CSV (comma-separated values) file.  
    Public MethodOverloaded. Saves the data on the sheet to the HTML file.  
    Public MethodOverloaded. Saves the sheet to the specified PDF file.  
    Public MethodOverloaded. Saves the range of cells in the sheet as delimited text and saves to a stream with the specified delimiters.  
    Public MethodOverloaded. Saves the worksheet to an XML stream.  
    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 MethodSets 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 MethodSets an array formula in a specified cell area in the specified sheet area.  
    Public MethodOverloaded. Sets the border for the specified area.  
    Public MethodSets 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 MethodSets whether a column in the specified sheet area is displayed.  
    Public MethodSets 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 Methoda  
    Public Method  
    Public MethodOverloaded. Sets a formula in a specified cell in the specified sheet area.  
    Public MethodSets the height using the specified unit type for the specified row in the specified sheet area.  
    Public MethodSets 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 MethodSets 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 MethodSets the height of the viewport.  
    Public MethodSets the viewport information to the current sheet.  
    Public MethodSets the width of the viewport.  
    Public MethodSorts a range of cells in this sheet in the data model.  
    Public MethodSuspends the calculation service.  
    Public MethodSuspends the SpanModel, RowHeaderSpanModel, and ColumnHeaderSpanModel events.  
    Public MethodUngroups the sparklines in the group.  
    Top
    Public Events
     NameDescription
    Public EventOccurs 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 EventOccurs when the chart has changed.  
    Public EventOccurs when the chart selection has changed.  
    Public EventOccurs 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 EventOccurs when two columns are swapped during sorting.  
    Public EventOccurs when the floating object has changed.  
    Public EventOccurs when the floating object selection has changed.  
    Public EventOccurs when the picture has changed.  
    Public EventOccurs when the picture selection has changed.  
    Public EventOccurs when the user changes a sheet property.  
    Public EventOccurs 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 EventOccurs when two rows are swapped during sorting.  
    Public EventOccurs when selections are changed that may require the selection area to be repainted.  
    Public EventOccurs when the chart has changed.  
    Public EventOccurs when the chart selection has changed.  
    Top
    See Also