Namespace: Spire.Spreadsheet.Forms
Assembly: Spire.Spreadsheet (in Spire.Spreadsheet.dll) Version: 3.7.1.8020
Send comments on this topic to [email protected]Send comments on this topic to
Copyright 2016-2019 e-iceblue. All Rights Reservedhttp://www.e-iceblue.com/
Assembly: Spire.Spreadsheet (in Spire.Spreadsheet.dll) Version: 3.7.1.8020
Syntax
| C# | Visual Basic | Visual C++ | F# |
public interface IWorksheet
Public Interface IWorksheet
public interface class IWorksheet
type IWorksheet = interface end
Members
| All Members | Properties  | Methods  |
 Public Protected | Instance Static  | Declared Inherited | XNA Framework Only  .NET Compact Framework Only  |
| Member | Description | |
|---|---|---|
| ActiveCellAdressInfo |
Gets the active cell.
|
| AddSelectedRange(CellRangeInfo) |
Add a new selected range to the worksheet.
|
| AppendColumn(Int32) |
Append specified columns to worksheet.
|
| AppendRows(Int32) |
Append specified rows to spreadsheet.
|
| AutoFitColumn()()()() |
Autofits all columns width.
|
| AutoFitColumn(Int32) |
Autofits the column width.
|
| AutoFitColumn(Int32, Int32) |
Autofits the column width.
|
| AutoFitColumn(Int32, Int32, Int32) |
Autofits column.
|
| AutoFitRow()()()() |
Autofits all rows height
|
| AutoFitRow(Int32) |
Autofits the row height.
|
| AutoFitRow(Int32, Int32) |
Autofits the row height.
|
| AutoFitRow(Int32, Int32, Int32) |
Autofits the row height.
|
| CaculateSelectedValue()()()() |
Calculates the sum of selected ranges of the worksheet.
|
| Cells |
Gets the collection of cells that belong to this worksheet.
|
| CheckInSelection(CellAdressInfo) |
Determines whether the specified cell location is in selected.
|
| CheckInSelectionByRow(Int32) |
Check whether the specified row at index is in selected.
|
| CheckInSelectionsByColumn(Int32) |
Check whether the specified column at index is in selected.
|
| ClearCell(String) |
Clears cell.
|
| ClearCell(ISpreadCell) |
Clears cell.
|
| ClearCell(Int32, Int32) |
Clears cell.
|
| ClearSelection()()()() |
Clear the selection in Worksheet.
|
| ColumnCount |
Gets or sets the column count of the Worksheet.
|
| Columns |
Gets the collection of columns that belong to this Worksheet.
|
| Comments |
Gets the comment collection.
|
| ConditionalFormattings |
ConditionalFormattings of worksheet
|
| Controls |
Gets the cell control collection.
|
| CreateRowFilter(Int32, Int32, String) | |
| CreateRowFilter(Int32, Int32, Int32, String) | |
| DefaultColumnWidth | |
| DefaultRowHeight | |
| DisableRowFilter()()()() |
Disable row filter.
|
| EnableRowFilter()()()() |
Enable row filter.
|
| ExportDataTable(Int32, Int32, Int32, Int32, Boolean) |
Exports worksheet data into a DataTable
|
| ExportDataTable(Int32, Int32, Int32, Int32, Boolean, Boolean) |
Exports worksheet data into a DataTable
|
| FirstVisibleColumn |
Gets or sets the first visible column of the worksheet.
|
| FirstVisibleRow |
Get the first visible row of the worksheet.
|
| FreezeColumn(Int32) |
Freeze grid at specified column.
|
| FreezeRow(Int32) |
Freeze grid at specified row.
|
| FromRange(String, String) |
Gets CellRangeInfo from a range of worksheet.
|
| FromRange(Int32, Int32, Int32, Int32) |
Gets CellRangeInfo from a range of worksheet.
|
| FrozenColumns |
Gets or sets Worksheet's frozen column count.
|
| FrozenRows |
Gets or sets Worksheet's frozen row count.
|
| GetActiveCell()()()() |
Gets the active cell.
|
| GetAllSelectedRanges()()()() |
Gets all selected ranges of this worksheet.
|
| GetCell(Point) | |
| GetMerge(Int32) |
Gets the cell range of the merge at the specified index.
|
| GetNumber(Int32, Int32) |
Gets number value from specific cell.
|
| GetRowHeightPixels(Int32) |
Get row height.
|
| GetSelectedRange()()()() |
Gets the selected cell range.
|
| GetText(Int32, Int32) |
Gets string value from specific cell.
|
| GridLinesVisible |
Indicates whether the gridlines is visible.
|
| GroupColumns(Int32, Int32) |
Group columns from specified number of columns
|
| GroupColumns(Int32, Int32, Boolean) |
Group columns from specified number of columns
|
| GroupColumns(Int32, Int32, Int32, Boolean) |
Group columns from specified number of columns.
|
| GroupRows(Int32, Int32) |
Group rows from specified number of rows
|
| GroupRows(Int32, Int32, Boolean) |
Group rows from specified number of rows
|
| GroupRows(Int32, Int32, Int32, Boolean) |
Group rows from specified number of rows
|
| HasActiveCell()()()() |
Determines whether the cell is actived.
|
| Hyperlinks |
Gets the hyperlink collection.
|
| ImportDataSet(DataSet, String, Int32, Int32) |
Imports data from a dataset to worksheet.
|
| ImportDataTable(DataTable, Boolean, Int32, Int32) |
Imports data from a DataTable into worksheet
|
| ImportDataView(DataView, Int32, Int32) |
Import data from data view to worksheet.
|
| InsertArray(array<DateTime>[]()[][], Int32, Int32) |
Insert array value to worksheet.
|
| InsertArray(array<Double>[]()[][], Int32, Int32) |
Insert array value to worksheet.
|
| InsertArray(array<Int32>[]()[][], Int32, Int32) |
Insert array value to worksheet.
|
| InsertArray(array<Object,2>[,](,)[,][,], Int32, Int32) |
Insert array value to worksheet.
|
| InsertArray(array<Object>[]()[][], Int32, Int32) |
Insert array value to worksheet.
|
| InsertArray(array<String>[]()[][], Int32, Int32) |
Insert array value to worksheet.
|
| InsertArray(array<DateTime>[]()[][], Int32, Int32, Boolean) |
Insert array value to worksheet.
|
| InsertArray(array<Double>[]()[][], Int32, Int32, Boolean) |
Insert array value to worksheet.
|
| InsertArray(array<Int32>[]()[][], Int32, Int32, Boolean) |
Insert array value to worksheet.
|
| InsertArray(array<Object>[]()[][], Int32, Int32, Boolean) |
Insert array value to worksheet.
|
| InsertColumn(Int32) |
Inserts a new column.
|
| InsertDataColumn(DataColumn, Int32, Int32) |
Insert data column to worksheet.
|
| InsertDataTable(DataTable, Int32, Int32) |
Insert datatable to workhseet.
|
| InsertDataView(DataView, Int32, Int32) |
Insert dataview to workhseet.
|
| InsertRow(Int32) |
Inserts a new row.
|
| IsColumnVisible(Int32) |
Checks whether the column is visible.
|
| IsProtected |
Indicates whether worksheet object is protected.
|
| IsRowVisible(Int32) |
Checks whether the row is visible.
|
| IsVisible |
Represents if the worksheet is visible.
|
| Item[([( String])]) |
Gets spread cell by cell name.
|
| Item[([( Int32, Int32])]) |
Gets spread cell at specific row and colum.
|
| Item[([( String, String])]) |
Gets cell range.
|
| Item[([( Int32, Int32, Int32, Int32])]) |
Gets cell range.
|
| Merge(CellRangeInfo) |
Merges a specified range.
|
| Merge(Int32, Int32, Int32, Int32) |
Merges a specified range.
|
| MergeRangesCount |
Gets the count of the merges
|
| Pictures |
Gets the picture collection.
|
| Protect()()()() |
Protect the worksheet.
|
| RemoveAllMerges()()()() |
Removes all merges.
|
| RemoveColumn(Int32) |
Removes a column at the specified index.
|
| RemoveRow(Int32) |
Removes a row at the specified index.
|
| RemoveRowFilter()()()() |
Remove row filter.
|
| Resize(Int32, Int32) |
Resets row count and column count.
|
| RowCount |
Gets or sets the row count of the Worksheet.
|
| Rows |
Gets the collection of rows that belong to this Worksheet.
|
| SetActiveCell(CellAdressInfo) |
Sets the active cell at the specified location.
|
| SetActiveCell(Int32, Int32) |
Sets the active cell at the specified column and row.
|
| SetColumns(Int32) |
Set columns count.
|
| SetColumnWidthInPixels(Int32, Int32) |
Sets column with.
|
| SetDefaultColumnStyle(Int32, CellStyle) |
Sets column style.
|
| SetDefaultRowStyle(Int32, CellStyle) |
Set row style.
|
| SetFirstVisibleColumn(Int32) |
Set the first visible column index of sheet view.
|
| SetFormula(Int32, Int32, String) |
Sets formula value to specific cell.
|
| SetNumber(Int32, Int32, Double) |
Sets number value to specific cell.
|
| SetRangeFont(CellRangeInfo, Font) | |
| SetRangeFontColor(CellRangeInfo, Color) | |
| SetRowHeightPixels(Int32, Double) |
Sets row height.
|
| SetRows(Int32) |
Sets rows count.
|
| SetText(Int32, Int32, String) |
Sets string value to specific cell.
|
| SetValue(Int32, Int32, Object) |
Sets value to specific cell.
|
| SheetName |
Gets or sets the name of the sheet.
|
| SortColumn(Int32) |
Sort data on specified column.
|
| SortColumn(Int32, SortOrder, Boolean) |
Sort data on specified column.
|
| SortColumns(Int32, Int32) |
Sort data on specified column.
|
| SortColumns(array<Int32>[]()[][], array<SortOrder>[]()[][], Boolean) |
Sort data on specified columns.
|
| SortColumns(Int32, Int32, SortOrder, Boolean) |
Sort data on specified column.
|
| Spreadsheet |
Gets Spreadsheet object.
|
| UnfreezeColumn()()()() |
UnFreeze grid.
|
| UnfreezeRow()()()() |
UnFreeze grid.
|
| UngroupColumns(Int32, Int32) |
Ungroups columns.
|
| UngroupRows(Int32, Int32) |
Ungroups rows.
|
| Unmerge(CellRangeInfo) |
Unmerges a specified range of merged cells.
|
| Unprotect()()()() |
Unprotect the worksheet.
|
| WorksheetCustomProperties |
Gets the CustomProperties.
|
See Also