Namespace: Spire.Xls.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 RangesCollection : XlsRangesCollection
Public Class RangesCollection
	Inherits XlsRangesCollection
public ref class RangesCollection : public XlsRangesCollection
type RangesCollection =  
    class
        inherit XlsRangesCollection
    end

Members

            
 All Members  Properties   Methods   Events  
 Public

 Protected
 Instance

 Static 
 Declared

 Inherited
 XNA Framework Only 

 .NET Compact Framework Only 

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

Inheritance Hierarchy

See Also