Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 11.6.0.0 (11.6.0.5020)

Syntax

            
 C#  Visual Basic  Visual C++  F# 
public interface IWorksheet : ITabSheet, 
	IExcelApplication
Public Interface IWorksheet
	Inherits ITabSheet, IExcelApplication
public interface class IWorksheet : ITabSheet, 
	IExcelApplication
type IWorksheet =  
    interface
        interface ITabSheet
        interface IExcelApplication
    end

Members

            
 All Members  Properties   Methods   Events  
 Public

 Protected
 Instance

 Static 
 Declared

 Inherited
 XNA Framework Only 

 .NET Compact Framework Only 

 MemberDescription
Activate()()()() (Inherited from ITabSheet.)
ActivePane
AllocatedRange
AutoFilters
AutoFitColumn(Int32)
AutoFitRow(Int32)
Cells
CellValueChanged
CheckBoxes (Inherited from ITabSheet.)
CheckExistence(Int32, Int32)
Clear()()()()
ClearData()()()()
CodeName (Inherited from ITabSheet.)
CodeName
Columns
ColumnWidthToPixels(Double)
ComboBoxes (Inherited from ITabSheet.)
Comments
CopyToClipboard()()()()
CreateNamedRanges(String, String, Boolean)
DefaultColumnWidth
DefaultRowHeight
DeleteColumn(Int32)
DeleteRow(Int32)
DisplayPageBreaks
FirstVisibleColumn
FirstVisibleRow
FormulasVisible
GetBoolean(Int32, Int32)
GetColumnWidthPixels(Int32)
GetDefaultColumnStyle(Int32)
GetDefaultRowStyle(Int32)
GetError(Int32, Int32)
GetFormula(Int32, Int32, Boolean)
GetFormulaBoolValue(Int32, Int32)
GetFormulaErrorValue(Int32, Int32)
GetFormulaNumberValue(Int32, Int32)
GetFormulaStringValue(Int32, Int32)
GetNumber(Int32, Int32)
GetRowHeightPixels(Int32)
GetText(Int32, Int32)
GridLineColor
GridLinesVisible
HasOleObjects
HorizontalSplit
HPageBreaks
HyperLinks
Index
InsertArray(array<Object,2>[,](,)[,][,], 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)
InsertArray(array<String>[]()[][], Int32, Int32, Boolean)
InsertDataColumn(DataColumn, Boolean, Int32, Int32)
InsertDataTable(DataTable, Boolean, Int32, Int32)
InsertDataTable(DataTable, Boolean, Int32, Int32, Boolean)
InsertDataTable(DataTable, Boolean, Int32, Int32, Int32, Int32)
InsertDataTable(DataTable, Boolean, Int32, Int32, Int32, Int32, Boolean)
InsertDataView(DataView, Boolean, Int32, Int32)
InsertDataView(DataView, Boolean, Int32, Int32, Boolean)
InsertDataView(DataView, Boolean, Int32, Int32, Int32, Int32)
InsertDataView(DataView, Boolean, Int32, Int32, Int32, Int32, Boolean)
IsColumnVisible(Int32)
IsDisplayZeros
IsPasswordProtected (Inherited from ITabSheet.)
IsRightToLeft (Inherited from ITabSheet.)
IsRowVisible(Int32)
IsSelected (Inherited from ITabSheet.)
IsStringsPreserved
Item[([( String])])
Item[([( Int32, Int32])])
Item[([( Int32, Int32, Int32, Int32])])
LeftVisibleColumn
ListObjects
MergedCells
MoveWorksheet(Int32)
Name (Inherited from ITabSheet.)
Names
OleObjects
PageSetup
Parent (Inherited from IExcelApplication.)
Pictures (Inherited from ITabSheet.)
PivotTables
PixelsToColumnWidth(Double)
Protect(String) (Inherited from ITabSheet.)
Protect(String)
Protect(String, SheetProtectionType) (Inherited from ITabSheet.)
ProtectContents (Inherited from ITabSheet.)
ProtectDrawingObjects (Inherited from ITabSheet.)
Protection (Inherited from ITabSheet.)
ProtectScenarios (Inherited from ITabSheet.)
RadioButtons (Inherited from ITabSheet.)
Range
Remove()()()()
RemovePanes()()()()
Replace(String, DateTime)
Replace(String, Double)
Replace(String, String)
Replace(String, DataColumn, Boolean)
Replace(String, DataTable, Boolean)
Replace(String, array<Double>[]()[][], Boolean)
Replace(String, array<Int32>[]()[][], Boolean)
Replace(String, array<String>[]()[][], Boolean)
RowColumnHeadersVisible
Rows
SaveToFile(String, String)
SaveToHtml(Stream)
SaveToHtml(String)
SaveToHtml(Stream, HTMLOptions)
SaveToHtml(String, HTMLOptions)
SaveToImage(Int32, Int32, Int32, Int32)
SaveToImage(Stream, Int32, Int32, Int32, Int32, ImageType)
SaveToImage(Stream, Int32, Int32, Int32, Int32, EmfType)
SaveToImage(Stream, Int32, Int32, Int32, Int32, ImageType, EmfType)
SaveToStream(Stream, String)
Select()()()() (Inherited from ITabSheet.)
SetBlank(Int32, Int32)
SetBoolean(Int32, Int32, Boolean)
SetColumnWidthInPixels(Int32, Int32)
SetDefaultColumnStyle(Int32, IStyle)
SetDefaultColumnStyle(Int32, Int32, IStyle)
SetDefaultRowStyle(Int32, IStyle)
SetDefaultRowStyle(Int32, Int32, IStyle)
SetError(Int32, Int32, String)
SetFormula(Int32, Int32, String)
SetFormulaBoolValue(Int32, Int32, Boolean)
SetFormulaErrorValue(Int32, Int32, String)
SetFormulaNumberValue(Int32, Int32, Double)
SetFormulaStringValue(Int32, Int32, String)
SetNumber(Int32, Int32, Double)
SetRowHeightPixels(Int32, Double)
SetText(Int32, Int32, String)
SetValue(Int32, Int32, String)
TabColor (Inherited from ITabSheet.)
TabIndex (Inherited from ITabSheet.)
TabKnownColor (Inherited from ITabSheet.)
TextBoxes (Inherited from ITabSheet.)
TopVisibleRow
Type
Unprotect(String) (Inherited from ITabSheet.)
Unprotect(String)
Unselect()()()() (Inherited from ITabSheet.)
UseRangesCache
VerticalSplit
Visibility (Inherited from ITabSheet.)
VPageBreaks
Workbook (Inherited from ITabSheet.)
Zoom

See Also