Namespace: Spire.Xls.Core.Spreadsheet.Collections
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 XlsRangesCollection : CollectionExtended<IXLSRange>, 
	IEnumerable<IXLSRange>, IEnumerable, IXLSRanges, IExcelApplication, 
	IXLSRange, ICombinedRange
Public Class XlsRangesCollection
	Inherits CollectionExtended(Of IXLSRange)
	Implements IEnumerable(Of IXLSRange), IEnumerable, 
	IXLSRanges, IExcelApplication, IXLSRange, ICombinedRange
public ref class XlsRangesCollection : public CollectionExtended<IXLSRange^>, 
	IEnumerable<IXLSRange^>, IEnumerable, IXLSRanges, IExcelApplication, 
	IXLSRange, ICombinedRange
type XlsRangesCollection =  
    class
        inherit CollectionExtended<IXLSRange>
        interface IEnumerable<IXLSRange>
        interface IEnumerable
        interface IXLSRanges
        interface IExcelApplication
        interface IXLSRange
        interface ICombinedRange
    end

Members

            
 All Members  Properties   Methods   Events  
 Public

 Protected
 Instance

 Static 
 Declared

 Inherited
 XNA Framework Only 

 .NET Compact Framework Only 

 MemberDescription
Activate(Boolean)
Add(IXLSRange)
AddComment()()()()
AddRange(IXLSRange)
AutoFitColumns()()()()
AutoFitRows()()()()
BooleanValue
BorderAround()()()()
BorderAround(LineStyleType)
BorderAround(LineStyleType, ExcelColors)
BorderAround(LineStyleType, Color)
BorderInside()()()()
BorderInside(LineStyleType)
BorderInside(LineStyleType, ExcelColors)
BorderInside(LineStyleType, Color)
BorderNone()()()()
Borders
BuiltInStyle
Capacity (Inherited from CollectionBase<(Of <(<'T>)>)>.)
CellList
Cells Obsolete.
CellsCount
CellStyleName
Changed (Inherited from CollectionExtended<(Of <(<'T>)>)>.)
Clear()()()() (Inherited from CollectionBase<(Of <(<'T>)>)>.)
ClearConditionalFormats()()()()
Clone(Object) (Inherited from CollectionExtended<(Of <(<'T>)>)>.)
Clone(Object, Dictionary<(Of <<'(String, String>)>>), XlsWorkbook)
CollapseGroup(GroupByType)
Column
ColumnGroupLevel
Columns
ColumnWidth
Comment
ConditionalFormats
Contains(T) (Inherited from CollectionBase<(Of <(<'T>)>)>.)
CopyTo(array<T>[]()[][], Int32) (Inherited from CollectionBase<(Of <(<'T>)>)>.)
Count (Inherited from CollectionBase<(Of <(<'T>)>)>.)
DataValidation
DateTimeValue
EndCell
EnsureCapacity(Int32) (Inherited from CollectionExtended<(Of <(<'T>)>)>.)
EntireColumn
EntireRow
EnvalutedValue
Equals(Object)
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
ErrorValue
ExpandGroup(GroupByType)
ExpandGroup(GroupByType, ExpandCollapseFlags)
ExportDataTable(ExportTableOptions)
Finalize()()()()
Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
(Inherited from Object.)
FindAll(Boolean)
FindAll(DateTime)
FindAll(TimeSpan)
FindAll(Double, FindType)
FindAll(String, FindType)
FindFirst(Boolean)
FindFirst(DateTime)
FindFirst(TimeSpan)
FindFirst(Double, FindType)
FindFirst(String, FindType)
FindParent(Type) (Inherited from CollectionExtended<(Of <(<'T>)>)>.)
FindParent(Type, Boolean) (Inherited from CollectionExtended<(Of <(<'T>)>)>.)
Formula
FormulaArray
FormulaArrayR1C1
FormulaBoolValue
FormulaDateTime
FormulaErrorValue
FormulaNumberValue
FormulaR1C1
FormulaStringValue
FreezePanes()()()()
GetColumnRows(Boolean)
GetEnumerator()()()()
GetHashCode()()()()
Serves as a hash function for a particular type.
(Inherited from Object.)
GetNewRangeLocation(Dictionary<(Of <<'(String, String>)>>), String%)
GetRectangles()()()()
GetRectanglesCount()()()()
GetType()()()()
Gets the Type of the current instance.
(Inherited from Object.)
HasBoolean
HasDataValidation
HasDateTime
HasError
HasExternalFormula
HasFormula
HasFormulaArray
HasFormulaBoolValue
HasFormulaDateTime
HasFormulaErrorValue
HasFormulaNumberValue
HasFormulaStringValue
HasMerged
HasNumber
HasRichText
HasString
HasStyle
HorizontalAlignment
HtmlString
Hyperlinks
IgnoreErrorOptions
IndentLevel
IndexOf(T) (Inherited from CollectionBase<(Of <(<'T>)>)>.)
InnerList (Inherited from CollectionBase<(Of <(<'T>)>)>.)
Insert(Int32, T) (Inherited from CollectionBase<(Of <(<'T>)>)>.)
Intersect(IXLSRange)
IsBlank
IsFormulaHidden
IsGroupedByColumn
IsGroupedByRow
IsInitialized
IsReadOnly (Inherited from CollectionBase<(Of <(<'T>)>)>.)
IsStringsPreserved
IsWrapText
Item[([( Int32])])
Item[([( String])])
Item[([( Int32, Int32])])
Item[([( String, Boolean])])
Item[([( Int32, Int32, Int32, Int32])])
LastColumn
LastRow
List (Inherited from CollectionBase<(Of <(<'T>)>)>.)
MemberwiseClone()()()()
Creates a shallow copy of the current Object.
(Inherited from Object.)
Merge()()()()
Merge(Boolean)
Merge(IXLSRange)
MergeArea
MoveTo(IXLSRange)
NumberFormat
NumberText
NumberValue
OnClear()()()() (Inherited from CollectionExtended<(Of <(<'T>)>)>.)
OnClearComplete()()()() (Inherited from CollectionExtended<(Of <(<'T>)>)>.)
OnInsert(Int32, T) (Inherited from CollectionExtended<(Of <(<'T>)>)>.)
OnInsertComplete(Int32, T) (Inherited from CollectionExtended<(Of <(<'T>)>)>.)
OnRemove(Int32, T) (Inherited from CollectionExtended<(Of <(<'T>)>)>.)
OnRemoveComplete(Int32, T) (Inherited from CollectionExtended<(Of <(<'T>)>)>.)
OnSet(Int32, T, T) (Inherited from CollectionExtended<(Of <(<'T>)>)>.)
OnSetComplete(Int32, T, T) (Inherited from CollectionExtended<(Of <(<'T>)>)>.)
Parent (Inherited from CollectionExtended<(Of <(<'T>)>)>.)
RangeAddress
RangeAddressLocal
RangeGlobalAddress
RangeGlobalAddress2007
RangeR1C1Address
RangeR1C1AddressLocal
Remove(IXLSRange)
RemoveAt(Int32) (Inherited from CollectionBase<(Of <(<'T>)>)>.)
RichText
Row
RowGroupLevel
RowHeight
Rows
SetParent(Object) (Inherited from CollectionExtended<(Of <(<'T>)>)>.)
Style
Text
TimeSpanValue
ToString()()()()
Returns a String that represents the current Object.
(Inherited from Object.)
UnMerge()()()()
Value
Value2
VerticalAlignment
Worksheet
WorksheetName

Inheritance Hierarchy

See Also