For a list of all members of this type, see Worksheet members.
Public Methods
| Name | Description | |
|---|---|---|
 | AddChart | Overloaded. Adds the chart. |
| AddColumns | Overloaded. Adds the column or columns to the data model at the specified index. |
| AddColumnViewport | Adds the column viewport. |
| AddCustomFunction | Adds the specified user-defined custom function to the collection. |
| AddPicture | Overloaded. Adds the picture. |
| AddRows | Overloaded. Adds rows in this sheet. |
| AddRowViewport | Adds the row viewport. |
| AddSelection | Overloaded. Adds a cell range to the selection. |
| AddSpanCell | Overloaded. Adds a span of cells in this sheet in the specified sheet area. |
| AddSurfaceChart | Overloaded. Adds the surface chart. |
| AddTable | Overloaded. Adds a range table with a specified size to the sheet. |
| BindDataColumn | Binds the column to the data source column for a sheet. |
| Clear | Overloaded. Clears the specified area. |
| ClearCustomFunctions | Removes all user-defined custom functions (FunctionInfo object) on this sheet. |
| ClearCustomName | Clears the specified name in the name collection. |
| ClearCustomNames | Removes all custom names on this sheet. |
| ClearSelection | Overloaded. Clears the specified selection range from the selection list, if one exists. |
| ClearSelections | Clears the selections. |
| ClearSpanCells | Clears the span that contains a specified anchor cell from a range of cells in the specified sheet area. |
| CopyTo | Copies data from one range to another. |
| ExtendSelection | Specifies the last cell in the selection of cells. |
| FillAuto | Overloaded. Fills the specified range in the specified direction. |
| FillDate | Overloaded. Fills the specified range when the source value type is date. |
| FillGrowth | Overloaded. Fills the specified range growth trend when the source value type is number. |
| FillLinear | Overloaded. Fills the specified range linear trend when the source value type is number. |
| FindChart | Finds the chart with specified name. |
| FindFloatingObject | Finds the floating object with specified name. |
| FindFormulas | Gets formulas in the specified area. |
| FindPicture | Finds the picture with specified name. |
| FindSurfaceChart | Finds the surface chart with specified name. |
| FindTable | Overloaded. Gets the table of the specified cell. |
| GetActiveColumnViewportIndex | Gets the index of the active column viewport. |
| GetActiveRowViewportIndex | Gets the index of the active row viewport. |
| GetActualColumnVisible | Gets whether a column in the specified sheet area is displayed. |
| GetActualColumnWidth | Overloaded. Gets the width in pixels for the specified column in the specified sheet area. |
| GetActualRowHeight | Overloaded. Gets the height in pixels for the specified row in the specified sheet area. |
| GetActualRowVisible | Gets whether the control displays the specified row in the specified sheet area. |
| GetActualStyleInfo | Overloaded. Gets the actual style information for a specified cell in the specified sheet area. |
| GetArray | Overloaded. Gets an object array from a specified range of cells. |
| GetArrayFormula | Gets the formula in the specified area in this sheet. |
| GetColumnAutoText | Gets the automatic text displayed in the column header for the specified column. |
| GetColumnDataType | Gets the column data type at the specified position. |
| GetColumnLabel | Overloaded. Gets the text in the specified column header cell. |
| GetColumnResizable | Overloaded. Gets a value that indicates whether the user can resize a specified column in the specified sheet area. |
| GetColumnViewportCount | Gets the column viewport count. |
| GetColumnVisible | Overloaded. Gets whether a column in this sheet is displayed. |
| GetColumnWidth | Overloaded. Gets the width in pixels for the specified column in the specified sheet area. |
| GetCsv | Overloaded. Gets the CSV text from a range. |
| GetCustomFunction | Gets the specified user-defined custom function. |
| GetCustomName | Finds the specified custom name. |
| GetDataColumnName | Gets the column name at the specified position. |
| GetDrawingObject | Gets the data bar object or icon object of the current sheet in the specified range. |
| GetFillText | |
| GetFormula | Gets the formula in the specified cell in this sheet. |
| GetGridLine | Gets the control gridline; the gridline color is based on the ShowGridLine property. |
| GetLastDirtyColumn | Gets the last dirty column index. |
| GetLastDirtyRow | Gets the last dirty row index. |
| GetNonEmptyColumns | Returns a list of nonempty column indexes. |
| GetNonEmptyRows | Returns a list of nonempty row indexes. |
| GetRowAutoText | Gets the automatic text displayed in the row header for the specified row. |
| GetRowHeight | Overloaded. Gets the height using the specified unit type for the specified row in the specified sheet area. |
| GetRowLabel | Overloaded. Gets the text in the specified row header cell. |
| GetRowResizable | Overloaded. Gets a value that indicates whether users can resize the specified row in the specified sheet area. |
| GetRowViewportCount | Gets the row viewport count. |
| GetRowVisible | Overloaded. Gets whether the control displays the specified row. |
| GetSpanCell | Overloaded. Gets the range of cells that are spanned at a specified cell in this sheet. |
| GetSparkline | Gets the sparkline for the specified cell. |
| GetStyleInfo | Overloaded. Gets the style information of the specified cell, row, or column. |
| GetStyleName | Overloaded. Gets the name of the style assigned to a cell, column, row, or default model in the specified sheet area. |
| GetTables | Gets the sheet tables. |
| GetTag | Overloaded. Gets the application-defined tag value for the specified cell, column, row, or entire sheet in the specified sheet area. |
| GetText | Overloaded. Gets the formatted text in the cell in the specified sheet area using the IFormatter object for the cell. |
| GetValue | Overloaded. Gets unformatted data from the specified cell. |
| GetViewportHeight | Gets the height of the viewport. |
| GetViewportInfo | Gets the viewport information of the current sheet. |
| GetViewportLeftColumn | Gets the viewport left column. |
| GetViewportTopRow | Gets the viewport top row. |
| GetViewportWidth | Gets the width of the viewport. |
| GroupSparkline | Groups the sparklines. |
| InvalidateFormulas | Invalidates all formulas that are intersected with a specified range. |
| IsAnyCellInColumnSelected | Determines whether any cell in the specified column is in the selection. |
| IsAnyCellInRowSelected | Determines whether any cell in the specified row is in the selection. |
| IsColumnBound | Gets whether the specified column is bound to a data source. |
| IsRowBound | Gets whether the specified row is bound to a data source. |
| IsSelected | Determines whether the specified cell is in the selection. |
| IsValid | Determines whether the specified cell value is valid. |
| MoveTable | Overloaded. Changes the table location. |
| MoveTo | Moves data from one range to another. |
| NextActualVisibleColumn | Gets the index of the next visible column from the current column. |
| NextActualVisibleRow | Gets the index of the next visible row from the current row. |
| NextNonEmptyColumn | Overloaded. Returns the next nonempty column index for the specified column. |
| NextNonEmptyRow | Overloaded. Returns the next nonempty row index for the specified column. |
| OpenCsv | Overloaded. Loads the CSV (comma-separated values) file. |
| OpenTextFile | Overloaded. Loads the CSV file with the specified separator. |
| OpenXml | Overloaded. Loads the XML stream to build a new worksheet. |
 | ParseCsv | Parses the string to a two dimensional array. |
| PreviousActualVisibleColumn | Gets the index of the previous visible column from the current column. |
| PreviousActualVisibleRow | Gets the index of the previous visible row from the current row. |
| Recalculate | Overloaded. Evaluates all the cell formulas on the sheet that have changed since the last calculation cycle. |
| ReloadBindingData | Reloads the binding data. |
| RemoveChart | Removes the chart with specified name. |
| RemoveColumns | Overloaded. Removes the column or columns on this sheet at the specified index. |
| RemoveColumnViewport | Removes the column viewport. |
| RemoveCustomFunctions | Removes the specified user-defined custom function. |
| RemoveFloatingObject | Removes the floating object with the specified name. |
| RemovePicture | Removes the picture with the specified name. |
| RemoveRows | Overloaded. Removes the row or rows on this sheet at the specified index. |
| RemoveRowViewport | Removes the row viewport. |
| RemoveSpanCell | Overloaded. Removes the span that contains a specified anchor cell from a range of cells in the specified sheet area. |
| RemoveSparkline | Removes the sparkline of the specified cell. |
| RemoveSurfaceChart | Removes the surface chart with the specified name. |
| RemoveTable | Overloaded. Removes a specified table. |
| ResetTouchSelectionGripperBackgroundColor | Resets the color of the touch selection gripper background. |
| ResetTouchSelectionGripperBackgroundThemeColor | Resets the theme color of the touch selection gripper background. |
| ResizeTable | Overloaded. Changes the table size. |
| ResumeCalcService | Resumes the calculation service. |
| ResumeSpanModelEvent | Resumes the SpanModel, RowHeaderSpanModel, and ColumnHeaderSpanModel events. |
| SaveCsv | Overloaded. Saves the CSV (comma-separated values) file. |
| SaveHtml | Overloaded. Saves the data on the sheet to the HTML file. |
| SavePdf | Overloaded. Saves the sheet to the specified PDF file. |
| SaveTextFileRange | Overloaded. Saves the range of cells in the sheet as delimited text and saves to a stream with the specified delimiters. |
| SaveXml | Overloaded. Saves the worksheet to an XML stream. |
| Search | Overloaded. 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. |
| SetActiveCell | Overloaded. Sets the active cell on this sheet. |
| SetActiveViewport | Sets the active viewport. |
| SetArray | Overloaded. Sets the values in the specified two-dimensional array of objects into the specified range of cells on this sheet. |
| SetArrayFormula | Sets an array formula in a specified cell area in the specified sheet area. |
| SetBorder | Overloaded. Sets the border for the specified area. |
| SetColumnLabel | Sets the value for a specified cell in a column header on this sheet. |
| SetColumnResizable | Overloaded. Sets whether users can resize individual columns in the specified sheet area. |
| SetColumnVisible | Sets whether a column in the specified sheet area is displayed. |
| SetColumnWidth | Sets the width using the specified unit type for the specified columns in this sheet. |
| SetCsv | Overloaded. Sets CSV text in the sheet. |
| SetCustomName | Overloaded. Sets a custom name using the specified formula. |
| SetDataSource | Sets the data source that populates the sheet. a |
| SetExcelReadService | |
| SetFormula | Overloaded. Sets a formula in a specified cell in the specified sheet area. |
| SetRowHeight | Sets the height using the specified unit type for the specified row in the specified sheet area. |
| SetRowLabel | Sets the value for a specified cell in a row header on this sheet. |
| SetRowResizable | Overloaded. Sets whether users can resize the specified row in the specified sheet area. |
| SetRowVisible | Sets whether the control displays the specified row in the specified sheet area. |
| SetSelection | Overloaded. Selects the specified cells. |
| SetSparkline | Overloaded. Sets the sparkline to a cell. |
| SetStyleInfo | Overloaded. Sets the style for the specified cell, row, or column. |
| SetStyleName | Overloaded. Sets the style for the specified cell, column, row, or default model to the specified style name. |
| SetTag | Overloaded. Sets the application-defined tag value for the specified cell, column, row, or entire sheet for the specified sheet area. |
| SetText | Overloaded. Sets the formatted text in the cell in the specified sheet area using the IFormatter object for the cell. |
| SetValue | Overloaded. Sets the value for the specified cell in the specified sheet area. |
| SetViewportHeight | Sets the height of the viewport. |
| SetViewportInfo | Sets the viewport information to the current sheet. |
| SetViewportWidth | Sets the width of the viewport. |
| SortRange | Sorts a range of cells in this sheet in the data model. |
| SuspendCalcService | Suspends the calculation service. |
| SuspendSpanModelEvent | Suspends the SpanModel, RowHeaderSpanModel, and ColumnHeaderSpanModel events. |
| UngroupSparkline | Ungroups the sparklines in the group. |
See Also