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 XlsRange : XlsObject, IXLSRange, 
	IExcelApplication, IEnumerable, ICombinedRange, IEnumerable<IXLSRange>, 
	IDisposable
Public Class XlsRange
	Inherits XlsObject
	Implements IXLSRange, IExcelApplication, IEnumerable, ICombinedRange, 
	IEnumerable(Of IXLSRange), IDisposable
public ref class XlsRange : public XlsObject, 
	IXLSRange, IExcelApplication, IEnumerable, ICombinedRange, IEnumerable<IXLSRange^>, 
	IDisposable
type XlsRange =  
    class
        inherit XlsObject
        interface IXLSRange
        interface IExcelApplication
        interface IEnumerable
        interface ICombinedRange
        interface IEnumerable<IXLSRange>
        interface IDisposable
    end

Members

            
 All Members  Fields   Properties   Methods  
 Public

 Protected
 Instance

 Static 
 Declared

 Inherited
 XNA Framework Only 

 .NET Compact Framework Only 

 MemberDescription
Activate()()()()
Activate(Boolean)
AddCombinedRange(CellRange)
AddComment()()()()
AddComment(Boolean)
AddComment(ICommentShape)
AddReference()()()() (Inherited from XlsObject.)
ApplyStyle(IStyle, CellStyleFlag)
AutoFitColumns()()()()
AutoFitRows()()()()
BooleanValue
BorderAround()()()()
BorderAround(LineStyleType)
BorderAround(LineStyleType, ExcelColors)
BorderAround(LineStyleType, Color)
BorderInside()()()()
BorderInside(LineStyleType)
BorderInside(LineStyleType, ExcelColors)
BorderInside(LineStyleType, Color)
BorderNone()()()()
Borders
BuiltInStyle
CellList
Cells Obsolete.
CellsCount
CellStyleName
CheckDisposed()()()() (Inherited from XlsObject.)
CheckRange(Int32, Int32)
Clear(Boolean)
Clear(ExcelClearOptions)
ClearAll()()()()
ClearConditionalFormats()()()()
ClearContents()()()()
Clone(Object, Dictionary<(Of <<'(String, String>)>>), XlsWorkbook)
CollapseGroup(GroupByType)
Column
ColumnCount
ColumnGroupLevel
Columns
ColumnWidth
CombinedCells
Comment
ConditionalFormats Obsolete.
ConvertToNumber()()()()
CopyToClipboard()()()() Obsolete.
Count
DataValidation
DateTimeValue
DEF_MAX_HEIGHT
DisplayedText
Dispose()()()()
Releases all resources used by the XlsRange
EndCell
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)
ExtendedFormatIndex
Finalize()()()() (Inherited from XlsObject.)
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 XlsObject.)
FindParent(array<Type>[]()[][]) (Inherited from XlsObject.)
FindParent(Type, Boolean) (Inherited from XlsObject.)
FindParents(array<Type>[]()[][]) (Inherited from XlsObject.)
FindWorksheet(String)
FirstColumn
FirstRow
Formula
FormulaArray
FormulaArrayR1C1
FormulaBoolValue
FormulaDateTime
FormulaErrorValue
FormulaNumberValue
FormulaR1C1
FormulaStringValue
FormulaValue
FreezePanes()()()()
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.)
GroupByColumns(Boolean)
GroupByRows(Boolean)
HasBoolean
HasComment
HasConditionFormats
HasDataValidation
HasDateTime
HasError
HasExternalFormula
HasFormula
HasFormulaArray
HasFormulaBoolValue
HasFormulaDateTime
HasFormulaErrorValue
HasFormulaNumberValue
HasFormulaStringValue
HasMerged
HasNumber
HasPictures
HasRichText
HasString
HasStyle
HorizontalAlignment
HtmlString
Hyperlinks
IgnoreErrorOptions
IndentLevel
InfillCells()()()()
Intersect(IXLSRange)
IsAllNumber
IsBlank
IsFormulaHidden
IsGroupedByColumn
IsGroupedByRow
IsInitialized
IsIntersect(IXLSRange)
IsSingleCell
IsStringsPreserved
IsWrapText
Item[([( String])])
Item[([( Int32, Int32])])
Item[([( String, Boolean])])
Item[([( Int32, Int32, Int32, Int32])])
LastColumn
LastRow
m_bIsDisposed (Inherited from XlsObject.)
m_book
m_iBottomRow
m_iLeftColumn
m_iRightColumn
m_iTopRow
m_style
MeasureString(String)
MemberwiseClone()()()()
Creates a shallow copy of the current Object.
(Inherited from Object.)
Merge()()()()
Merge(Boolean)
Merge(IXLSRange)
MergeArea
MoveTo(IXLSRange)
MoveTo(IXLSRange, Boolean)
NumberFormat
NumberText
NumberValue
OnDispose()()()() (Inherited from XlsObject.)
Parent
PartialClear()()()()
RangeAddress
RangeAddressLocal
RangeGlobalAddress
RangeGlobalAddress2007
RangeGlobalAddressWithoutSheetName
RangeR1C1Address
RangeR1C1AddressLocal
ReferenceCount (Inherited from XlsObject.)
ReleaseReference()()()() (Inherited from XlsObject.)
RemoveCombinedRange(CellRange)
ReparseFormulaString()()()()
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)
RichText
Row
RowCount
RowGroupLevel
RowHeight
Rows
SetAutoFormat(AutoFormatType) Obsolete.
SetAutoFormat(AutoFormatType, AutoFormatOptions) Obsolete.
SetBorderToSingleCell(BordersLineType, LineStyleType, ExcelColors)
SetDataValidation(XlsValidation)
SetExtendedFormatIndex(Int32)
SetParent(Object) (Inherited from XlsObject.)
SetRowHeight(Double, Boolean)
SetSharedFormula(String, Int32, Int32)
Style
Text
TextPartReplace(String, String)
TimeSpanValue
ToString()()()()
Returns a String that represents the current Object.
(Inherited from Object.)
UngroupByColumns()()()()
UngroupByRows()()()()
Union(CellRange)
UnMerge()()()()
UpdateRange(Int32, Int32, Int32, Int32)
Value
Value2
VerticalAlignment
Workbook
Worksheet
WorksheetName

Inheritance Hierarchy

System..::..Object
  Spire.Xls.Core.Spreadsheet..::..XlsObject
    Spire.Xls.Core.Spreadsheet..::..XlsRange
      Spire.Xls..::..CellRange

See Also