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

Syntax

            
 C#  Visual Basic  Visual C++  F# 
public class XlsWorksheet : XlsWorksheetBase, 
	IWorksheet, ITabSheet, IExcelApplication, INamedObject, ICloneParent, 
	IInternalWorksheet
Public Class XlsWorksheet
	Inherits XlsWorksheetBase
	Implements IWorksheet, ITabSheet, IExcelApplication, INamedObject, 
	ICloneParent, IInternalWorksheet
public ref class XlsWorksheet : public XlsWorksheetBase, 
	IWorksheet, ITabSheet, IExcelApplication, INamedObject, ICloneParent, 
	IInternalWorksheet
type XlsWorksheet =  
    class
        inherit XlsWorksheetBase
        interface IWorksheet
        interface ITabSheet
        interface IExcelApplication
        interface INamedObject
        interface ICloneParent
        interface IInternalWorksheet
    end

Members

               
 All Members  Fields   Properties   Methods   Events  
 Public

 Protected
 Instance

 Static 
 Declared

 Inherited
 XNA Framework Only 

 .NET Compact Framework Only 

 MemberDescription
AccessColumn(Int32)
AccessRow(Int32)
Activate()()()() (Inherited from XlsWorksheetBase.)
ActivePane
AddAllowEditRange(String, CellRange)
AddAllowEditRange(String, CellRange, String)
AddReference()()()() (Inherited from XlsObject.)
AddTextEffectShape(PresetTextEffect, String, Int32, Int32, Int32, Int32, Int32, Int32) (Inherited from XlsWorksheetBase.)
AllocatedRange
AllocatedRangeIncludesFormatting
ApplyStyle(CellStyle)
ArcShapes (Inherited from XlsWorksheetBase.)
AutoFilters
AutoFitColumn(Int32)
AutoFitColumn(Int32, Int32, Int32)
AutoFitRow(Int32)
AutoFitRow(Int32, Int32, Int32, Boolean)
ButtonShapes (Inherited from XlsWorksheetBase.)
CellList
Cells Obsolete.
CellValueChanged
Charts (Inherited from XlsWorksheetBase.)
CheckBoxes (Inherited from XlsWorksheetBase.)
CheckDisposed()()()() (Inherited from XlsObject.)
CheckExistence(Int32, Int32)
Clear()()()()
ClearData()()()()
Clone(Object) Obsolete. (Inherited from XlsWorksheetBase.)
CodeName (Inherited from XlsWorksheetBase.)
Columns
ColumnWidthToPixels(Double)
ComboBoxes (Inherited from XlsWorksheetBase.)
Comments (Inherited from XlsWorksheetBase.)
ConditionalFormats
CopyFrom(XlsWorksheet, Dictionary<(Of <<'(String, String>)>>), Dictionary<(Of <<'(String, String>)>>), Dictionary<(Of <<'(Int32, Int32>)>>), WorksheetCopyType, Dictionary<(Of <<'(Int32, Int32>)>>), Dictionary<(Of <<'(Int32, Int32>)>>), Dictionary<(Of <<'(Int32, Int32>)>>)) Obsolete.
Copying
CopyToClipboard()()()() Obsolete.
CreateNamedRanges(String, String, Boolean)
CreateRanges(array<CellRange>[]()[][])
DefaultColumnWidth
DefaultGridlineColor (Inherited from XlsWorksheetBase.)
DefaultPrintRowHeight
DefaultRowHeight
DeleteColumn(Int32)
DeleteColumn(Int32, Int32)
DeleteRange(CellRange, DeleteOption)
DeleteRow(Int32)
DeleteRow(Int32, Int32)
DisplayPageBreaks
Dispose()()()() (Inherited from XlsObject.)
DVTable
Equals(Object)
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
ExportDataTable()()()()
Finalize()()()() (Inherited from XlsObject.)
FindParent(Type) (Inherited from XlsObject.)
FindParent(array<Type>[]()[][]) (Inherited from XlsObject.)
FindParent(Type, Boolean) (Inherited from XlsObject.)
FindParents(array<Type>[]()[][]) (Inherited from XlsObject.)
FirstColumn (Inherited from XlsWorksheetBase.)
FirstRow (Inherited from XlsWorksheetBase.)
FirstVisibleColumn
FirstVisibleRow
FormulasVisible
FreeRange(CellRange)
GetBoolean(Int32, Int32)
GetCaculateValue(Int32, Int32)
GetCellType(Int32, Int32, Boolean)
GetClonedObject(Dictionary<(Of <<'(String, String>)>>), XlsWorkbook)
GetColumnIsAutoFit(Int32)
GetColumnIsHide(Int32)
GetColumnWidth(Int32)
GetColumnWidthPixels(Int32)
GetDefaultColumnStyle(Int32)
GetDefaultRowStyle(Int32)
GetError(Int32, Int32)
GetFormula(Int32, Int32, Boolean)
GetFormula(Int32, Int32, Boolean, Boolean)
GetFormulaBoolValue(Int32, Int32)
GetFormulaErrorValue(Int32, Int32)
GetFormulaNumberValue(Int32, Int32)
GetFormulaStringValue(Int32, Int32)
GetHashCode()()()()
Serves as a hash function for a particular type.
(Inherited from Object.)
GetNumber(Int32, Int32)
GetRowHeight(Int32)
GetRowHeightPixels(Int32)
GetRowIsAutoFit(Int32)
GetRowIsHide(Int32)
GetStringValue(Int64)
GetText(Int32, Int32)
GetTextObject(Int64)
GetType()()()()
Gets the Type of the current instance.
(Inherited from Object.)
GridLineColor (Inherited from XlsWorksheetBase.)
GridLinesVisible
GroupBoxes (Inherited from XlsWorksheetBase.)
GroupByColumns(Int32, Int32, Boolean)
GroupByRows(Int32, Int32, Boolean)
HasArrayFormula(Int64)
HasArrayFormulaRecord(Int32, Int32)
HasMergedCells
HasOleObjects
HasPictures (Inherited from XlsWorksheetBase.)
HasVmlShapes (Inherited from XlsWorksheetBase.)
HeaderFooterShapes (Inherited from XlsWorksheetBase.)
HideColumn(Int32)
HideColumns(Int32, Int32)
HideRow(Int32)
HideRows(Int32, Int32)
HorizontalSplit
HPageBreaks
HyperLinks
ImportCustomObjects(ICollection, Int32, Int32, ImportObjectOptions)
ImportCustomObjects(ICollection, array<String>[]()[][], Boolean, Int32, Int32, Int32, Boolean, String, Boolean)
Index (Inherited from XlsWorksheetBase.)
InitializeCollections()()()() (Overrides XlsWorksheetBase..::..InitializeCollections()()()().)
InnerHyperLinks
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)
InsertArray<(Of <<'(T>)>>)(array<T>[]()[][], Int32, Int32, Boolean)
InsertArrayList(ArrayList, Int32, Int32, Boolean)
InsertColumn(Int32)
InsertColumn(Int32, Int32)
InsertColumn(Int32, Int32, InsertOptionsType)
InsertCutRange(IXLSRange, Int32, Int32, InsertMoveOption)
InsertDataColumn(DataColumn, Boolean, Int32, Int32)
InsertDataColumns(array<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)
InsertDataTable(DataTable, Boolean, Int32, Int32, Int32, Int32, array<DataColumn>[]()[][], 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)
InsertRange(Int32, Int32, Int32, Int32, InsertMoveOption, InsertOptionsType)
InsertRow(Int32)
InsertRow(Int32, Int32)
InsertRow(Int32, Int32, InsertOptionsType)
IntersectRanges(IXLSRange, IXLSRange)
IsArrayFormula(Int64)
IsColumnVisible(Int32)
IsDisplayZeros
IsEmpty
IsExternalFormula(Int32, Int32)
IsFreezePanes
IsPasswordProtected (Inherited from XlsWorksheetBase.)
IsRightToLeft (Inherited from XlsWorksheetBase.)
IsRowColHeadersVisible (Inherited from XlsWorksheetBase.)
IsRowVisible(Int32)
IsSelected (Inherited from XlsWorksheetBase.)
IsStringsPreserved
IsTransitionEvaluation (Inherited from XlsWorksheetBase.)
Item[([( String])])
Item[([( Int32, Int32])])
Item[([( Int32, Int32, Int32, Int32])])
LabelShapes (Inherited from XlsWorksheetBase.)
LastColumn (Inherited from XlsWorksheetBase.)
LastRow (Inherited from XlsWorksheetBase.)
LeftVisibleColumn (Inherited from XlsWorksheetBase.)
Lines (Inherited from XlsWorksheetBase.)
ListBoxes (Inherited from XlsWorksheetBase.)
ListObjects
m_bIsDisposed (Inherited from XlsObject.)
m_book (Inherited from XlsWorksheetBase.)
m_iFirstColumn (Inherited from XlsWorksheetBase.)
m_iFirstRow (Inherited from XlsWorksheetBase.)
m_iLastColumn (Inherited from XlsWorksheetBase.)
m_iLastRow (Inherited from XlsWorksheetBase.)
MaxDisplayRange
MemberwiseClone()()()()
Creates a shallow copy of the current Object.
(Inherited from Object.)
MergedCells
MergeRanges(IXLSRange, IXLSRange)
MoveWorksheet(Int32)
Name (Inherited from XlsWorksheetBase.)
Names
OleObjects
OnDispose()()()() (Inherited from XlsObject.)
OvalShapes (Inherited from XlsWorksheetBase.)
PageSetup
Parent (Inherited from XlsObject.)
ParentWorkbook (Inherited from XlsWorksheetBase.)
Pictures (Inherited from XlsWorksheetBase.)
PivotTables
PixelsToColumnWidth(Double)
Protect(String) (Inherited from XlsWorksheetBase.)
Protect(String, SheetProtectionType) (Inherited from XlsWorksheetBase.)
ProtectContents (Overrides XlsWorksheetBase..::..ProtectContents.)
ProtectDrawingObjects (Inherited from XlsWorksheetBase.)
Protection (Inherited from XlsWorksheetBase.)
ProtectScenarios (Inherited from XlsWorksheetBase.)
PrstGeomShapes (Inherited from XlsWorksheetBase.)
QueryTables (Inherited from XlsWorksheetBase.)
QuotedName
RadioButtons (Inherited from XlsWorksheetBase.)
Range
RealIndex (Inherited from XlsWorksheetBase.)
RectangleShapes (Inherited from XlsWorksheetBase.)
ReferenceCount (Inherited from XlsObject.)
ReleaseReference()()()() (Inherited from XlsObject.)
Remove()()()()
RemoveMergedCells(IXLSRange)
RemovePanes()()()()
ReparseFormula()()()()
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
SaveToEMFImage(String, Int32, Int32, Int32, Int32, EmfType) Obsolete.
SaveToFile(String, String)
SaveToFile(String, String, Boolean)
SaveToFile(String, String, Encoding)
SaveToHtml(Stream)
SaveToHtml(String)
SaveToHtml(Stream, HTMLOptions)
SaveToHtml(String, HTMLOptions)
SaveToImage(String)
SaveToImage(String, ImageFormat)
SaveToImage(Int32, Int32, Int32, Int32) Obsolete.
SaveToImage(String, Int32, Int32, Int32, Int32)
SaveToImage(Stream, Int32, Int32, Int32, Int32, ImageType)
SaveToImage(Stream, Int32, Int32, Int32, Int32, EmfType) Obsolete.
SaveToImage(Stream, Int32, Int32, Int32, Int32, ImageType, EmfType) Obsolete.
SaveToPdf(String)
SaveToPdf(String, FileFormat) Obsolete.
SaveToPdfStream(Stream)
SaveToPdfStream(Stream, FileFormat) Obsolete.
SaveToStream(Stream, String)
SaveToStream(Stream, String, Boolean)
SaveToStream(Stream, String, Encoding)
ScrollBarShapes (Inherited from XlsWorksheetBase.)
Select()()()() (Inherited from XlsWorksheetBase.)
SelectionCount
SelectTab()()()() (Inherited from XlsWorksheetBase.)
SetActiveCell(IXLSRange)
SetActiveCell(IXLSRange, Boolean)
SetBlank(Int32, Int32)
SetBoolean(Int32, Int32, Boolean)
SetCaculateValue(Object, Int32, Int32)
SetCellValue(Int32, Int32, Boolean)
SetCellValue(Int32, Int32, String)
SetChanged()()()() (Inherited from XlsWorksheetBase.)
SetColumnWidth(Int32, Double)
SetColumnWidthInPixels(Int32, Int32)
SetColumnWidthInPixels(Int32, Int32, Int32)
SetDefaultColumnStyle(Int32, IStyle)
SetDefaultColumnStyle(Int32, Int32, IStyle)
SetDefaultRowStyle(Int32, IStyle)
SetDefaultRowStyle(Int32, Int32, IStyle)
SetError(Int32, Int32, String)
SetError(Int32, Int32, String, Boolean)
SetFirstColumn(Int32)
SetFirstRow(Int32)
SetFormula(Int32, Int32, String)
SetFormula(Int32, Int32, String, Boolean)
SetFormulaBoolValue(Int32, Int32, Boolean)
SetFormulaErrorValue(Int32, Int32, String)
SetFormulaNumberValue(Int32, Int32, Double)
SetFormulaStringValue(Int32, Int32, String)
SetLastColumn(Int32)
SetLastRow(Int32)
SetNumber(Int32, Int32, Double)
SetParent(Object) (Inherited from XlsObject.)
SetRowHeight(Int32, Double)
SetRowHeightInPixels(Int32, Int32, Double)
SetRowHeightPixels(Int32, Double)
SetText(Int32, Int32, String)
SetValue(Int32, Int32, String)
Shapes (Inherited from XlsWorksheetBase.)
SheetId (Inherited from XlsWorksheetBase.)
ShowColumn(Int32)
ShowRow(Int32)
SparklineGroups
SpinnerShapes (Inherited from XlsWorksheetBase.)
StandardHeightFlag
Subtotal(IXLSRange, Int32, array<Int32>[]()[][], SubtotalTypes)
Subtotal(IXLSRange, Int32, array<Int32>[]()[][], SubtotalTypes, Boolean, Boolean, Boolean)
TabColor (Inherited from XlsWorksheetBase.)
TabColorObject (Inherited from XlsWorksheetBase.)
TabKnownColor (Inherited from XlsWorksheetBase.)
TextBoxes (Inherited from XlsWorksheetBase.)
ToEMFStream(Stream, Int32, Int32, Int32, Int32)
ToEMFStream(Stream, Int32, Int32, Int32, Int32, EmfType)
ToImage(Int32, Int32, Int32, Int32)
TopLeftCell
TopVisibleRow (Inherited from XlsWorksheetBase.)
ToString()()()()
Returns a String that represents the current Object.
(Inherited from Object.)
ToSVGStream(Stream, Int32, Int32, Int32, Int32)
Type
TypedArcs (Inherited from XlsWorksheetBase.)
TypedButtons (Inherited from XlsWorksheetBase.)
TypedCheckBoxes (Inherited from XlsWorksheetBase.)
TypedComboBoxes (Inherited from XlsWorksheetBase.)
TypedGroupBoxes (Inherited from XlsWorksheetBase.)
TypedLabels (Inherited from XlsWorksheetBase.)
TypedLines (Inherited from XlsWorksheetBase.)
TypedListBoxes (Inherited from XlsWorksheetBase.)
TypedOvals (Inherited from XlsWorksheetBase.)
TypedPictures (Inherited from XlsWorksheetBase.)
TypedRadioButtons (Inherited from XlsWorksheetBase.)
TypedRects (Inherited from XlsWorksheetBase.)
TypedScollBars (Inherited from XlsWorksheetBase.)
TypedSpinners (Inherited from XlsWorksheetBase.)
TypedTextBoxes (Inherited from XlsWorksheetBase.)
UngroupByColumns(Int32, Int32)
UngroupByRows(Int32, Int32)
UnknownVmlShapes (Inherited from XlsWorksheetBase.)
Unprotect()()()() (Inherited from XlsWorksheetBase.)
Unprotect(String) (Inherited from XlsWorksheetBase.)
Unselect()()()() (Inherited from XlsWorksheetBase.)
Unselect(Boolean) (Inherited from XlsWorksheetBase.)
UseRangesCache
Version
VerticalSplit
ViewMode
Visibility (Inherited from XlsWorksheetBase.)
VmlShapesCount (Inherited from XlsWorksheetBase.)
VPageBreaks
Workbook (Inherited from XlsWorksheetBase.)
Zoom
ZoomScaleNormal
ZoomScalePageBreakView
ZoomScalePageLayoutView

Inheritance Hierarchy

See Also