Worksheet Members - Aspose.Grid for .NET

CellIndexToName	Gets cell name according to its row and column indexes.
CellIndexToR1C1	Gets cell r1c1 style name according to its row and column indexes.
CellNameToIndex	Gets the cell row and column indexes according to its name
ColumnIndexToName	Gets column name according to column index.
ColumnNameToIndex	Gets column index according to column name.
R1C1ToIndex	Gets the cell row and column indexes according to its R1C1 style name.

Public Instance Properties

Cells	Gets the collection of cells that belong to this worksheet.
Columns	Gets the collection of columns that belong to this Worksheet.
ColumnsCount	Gets or sets the columns count of the Worksheet.
Comments	Gets the comment collection.
Controls	Gets the cell control collection.
DataMember	Gets the data source that the Worksheet object is displaying data for.
DataSource	Gets the specific list in a DataSource for Worksheet object.
FocusedCellLocation	Gets the cell location which is focused.
FrozenCols	Gets or sets Worksheet's frozen column count. Frozen will start at first column.
FrozenRows	Gets or sets Worksheet's frozen row count. Frozen will start at first row.
GridDesktop	Gets Sheet's GridDesktop object.
Hyperlinks	Gets the hyperlink collection.
MergesCount	Gets the count of the merges
Name	Gets or sets the name of the sheet.
Pictures	Gets the picture collection.
Protected	Gets or sets whether worksheet object is protected.
Rows	Gets the collection of rows that belong to this Worksheet.
RowsCount	Gets or sets the rows count of the Worksheet.
Validations	Gets the validation collection.

Public Instance Methods

AddColumn	Adds a new column.
AddRow	Adds a new row.
AutoFitColumn	Overloaded. Autofits the column width. This method autofits a column based on content in a range of cells within the column from startRow to endRow. AutoFitColumn is an imprecise function.
AutoFitColumns	Overloaded. Autofits columns width in a rectangle range. AutoFitColumns is an imprecise function.
AutoFitRow	Overloaded. Autofits the row height. This method autofits a row based on content in a range of cells within the row from startColumn to endColumn. AutoFitRow is an imprecise function.
AutoFitRows	Overloaded. Autofits rows height in a rectangle range. AutoFitRows is an imprecise function.
CellInMerged	Gets a value whether the specified cell location is in merges.
CellRangeInMerge	Gets a value that indicates whether the specified cell range in merges.
ClearCell	Overloaded. Clears cell's value, style, hyperlink, picture, comment etc at specified row, column.
ClearMerges	Clear all merges.
ClearSelection	Clear the selection in Worksheet.
ColInMerged	Gets a value that indicates whether the specified column in merges.
ColInSelection	Determines whether the specified column at index is in selected.
CreateRange	Overloaded. Creates a CellRange object from a range of worksheet.
DataBind	Binds data from data source object with Worksheet object.
DataUnbind	Unbind data from data source object with Worksheet object.
Equals (inherited from Object)	Determines whether the specified Object is equal to the current Object.
ExportDataTable	Overloaded. Exports data in the Cells collection of a Worksheet to a specifed DataTable object.
GetFocusedCell	Gets the focused cell.
GetFocusedCellLocation	Gets a cell location which is focused.
GetHashCode (inherited from Object)	Serves as a hash function for a particular type. GetHashCode is suitable for use in hashing algorithms and data structures like a hash table.
GetLastSelection	Gets the cell range of last selected.
GetMerge	Gets the cell range of the merge at the specified index.
GetType (inherited from Object)	Gets the Type of the current instance.
GroupColumns	Overloaded. Groups columns.
GroupRows	Overloaded. Groups rows.
ImportDataTable	Imports a DataTable object into a worksheet.
InSelection	Determines whether the specified cell location is in selected.
InsertColumn	Inserts a new column.
InsertRow	Inserts a new row.
IsCellFocused	Determines whether the cell is focused.
Merge	Overloaded. Merges a specified range of cells into a single cell.
MergeFocused	Gets the index of the focused merge.
RemoveColumn	Removes a column at the specified index.
RemoveRow	Removes a row at the specified index.
RowInMerged	Gets a value that indicates whether the specified row in merges.
RowInSelection	Determines whether the specified row at index is in selected.
SetFirstVisibleColumn	Set the first visible column index of sheet view.
SetFirstVisibleRow	Set the first visible row index of sheet view.
SetFocusedCell	Overloaded. Sets the cell focus at the specified location.
SetFont	Sets font object to cellRange.
SetFontColor	Sets font color to cellRange.
SetStyle	Overloaded. Sets style object to cellRange.
ToString (inherited from Object)	Returns a String that represents the current Object.
UngroupColumns	Ungroups columns.
UngroupRows	Ungroups rows.
Unmerge	Overloaded. Unmerges a specified range of merged cells.

Protected Instance Methods

Finalize (inherited from Object)	Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
MemberwiseClone (inherited from Object)	Creates a shallow copy of the current Object.

Public Static Fields

Public Static Methods

Public Instance Properties

Public Instance Methods

Protected Instance Methods

See Also