Namespace: Spire.Spreadsheet.Forms
Assembly: Spire.Spreadsheet (in Spire.Spreadsheet.dll) Version: 5.6.1.0 (5.6.1.7020)

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 

 MemberDescription
ActiveCellAdressInfo
AddSelectedRange(CellRangeInfo)
AppendColumn(Int32)
AppendRows(Int32)
AutoFitColumn()()()()
AutoFitColumn(Int32)
AutoFitColumn(Int32, Int32)
AutoFitColumn(Int32, Int32, Int32)
AutoFitRow()()()()
AutoFitRow(Int32)
AutoFitRow(Int32, Int32)
AutoFitRow(Int32, Int32, Int32)
CaculateSelectedValue()()()()
Cells
CheckInSelection(CellAdressInfo)
CheckInSelectionByRow(Int32)
CheckInSelectionsByColumn(Int32)
ClearCell(String)
ClearCell(ISpreadCell)
ClearCell(Int32, Int32)
ClearSelection()()()()
ColumnCount
Columns
Comments
ConditionalFormattings
Controls
CreateRowFilter(Int32, Int32, String)
CreateRowFilter(Int32, Int32, Int32, String)
DefaultColumnWidth
DefaultRowHeight
DisableRowFilter()()()()
EnableRowFilter()()()()
ExportDataTable(Int32, Int32, Int32, Int32, Boolean)
ExportDataTable(Int32, Int32, Int32, Int32, Boolean, Boolean)
FirstVisibleColumn
FirstVisibleRow
FreezeColumn(Int32)
FreezeRow(Int32)
FromRange(String, String)
FromRange(Int32, Int32, Int32, Int32)
FrozenColumns
FrozenRows
GetActiveCell()()()()
GetAllSelectedRanges()()()()
GetCell(Point)
GetMerge(Int32)
GetNumber(Int32, Int32)
GetRowHeightPixels(Int32)
GetSelectedRange()()()()
GetText(Int32, Int32)
GridLinesVisible
GroupColumns(Int32, Int32)
GroupColumns(Int32, Int32, Boolean)
GroupColumns(Int32, Int32, Int32, Boolean)
GroupRows(Int32, Int32)
GroupRows(Int32, Int32, Boolean)
GroupRows(Int32, Int32, Int32, Boolean)
HasActiveCell()()()()
Hyperlinks
ImportDataSet(DataSet, String, Int32, Int32)
ImportDataTable(DataTable, Boolean, Int32, Int32)
ImportDataView(DataView, Int32, Int32)
InsertArray(array<DateTime>[]()[][], Int32, Int32)
InsertArray(array<Double>[]()[][], Int32, Int32)
InsertArray(array<Int32>[]()[][], Int32, Int32)
InsertArray(array<Object,2>[,](,)[,][,], Int32, Int32)
InsertArray(array<Object>[]()[][], Int32, Int32)
InsertArray(array<String>[]()[][], Int32, Int32)
InsertArray(array<DateTime>[]()[][], Int32, Int32, Boolean)
InsertArray(array<Double>[]()[][], Int32, Int32, Boolean)
InsertArray(array<Int32>[]()[][], Int32, Int32, Boolean)
InsertArray(array<Object>[]()[][], Int32, Int32, Boolean)
InsertColumn(Int32)
InsertDataColumn(DataColumn, Int32, Int32)
InsertDataTable(DataTable, Int32, Int32)
InsertDataView(DataView, Int32, Int32)
InsertRow(Int32)
IsColumnVisible(Int32)
IsProtected
IsRowVisible(Int32)
IsVisible
Item[([( String])])
Item[([( Int32, Int32])])
Item[([( String, String])])
Item[([( Int32, Int32, Int32, Int32])])
Merge(CellRangeInfo)
Merge(Int32, Int32, Int32, Int32)
MergeRangesCount
Pictures
Protect()()()()
RemoveAllMerges()()()()
RemoveColumn(Int32)
RemoveRow(Int32)
RemoveRowFilter()()()()
Resize(Int32, Int32)
RowCount
Rows
SetActiveCell(CellAdressInfo)
SetActiveCell(Int32, Int32)
SetColumns(Int32)
SetColumnWidthInPixels(Int32, Int32)
SetDefaultColumnStyle(Int32, CellStyle)
SetDefaultRowStyle(Int32, CellStyle)
SetFirstVisibleColumn(Int32)
SetFormula(Int32, Int32, String)
SetNumber(Int32, Int32, Double)
SetRangeFont(CellRangeInfo, Font)
SetRangeFontColor(CellRangeInfo, Color)
SetRowHeightPixels(Int32, Double)
SetRows(Int32)
SetText(Int32, Int32, String)
SetValue(Int32, Int32, Object)
SheetName
SortColumn(Int32)
SortColumn(Int32, SortOrder, Boolean)
SortColumns(Int32, Int32)
SortColumns(array<Int32>[]()[][], array<SortOrder>[]()[][], Boolean)
SortColumns(Int32, Int32, SortOrder, Boolean)
Spreadsheet
UnfreezeColumn()()()()
UnfreezeRow()()()()
UngroupColumns(Int32, Int32)
UngroupRows(Int32, Int32)
Unmerge(CellRangeInfo)
Unprotect()()()()
WorksheetCustomProperties

See Also