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

Members

            
 All Members  Fields   Properties   Methods  
 Public

 Protected
 Instance

 Static 
 Declared

 Inherited
 XNA Framework Only 

 .NET Compact Framework Only 

 MemberDescription
Activate()()()()
Activate(Boolean) (Inherited from XlsRange.)
AddCombinedRange(CellRange) (Inherited from XlsRange.)
AddComment()()()()
AddComment(Boolean) (Inherited from XlsRange.)
AddComment(ExcelComment)
AddComment(ICommentShape) (Inherited from XlsRange.)
AddReference()()()() (Inherited from XlsObject.)
ApplyStyle(IStyle, CellStyleFlag) (Inherited from XlsRange.)
AutoFitColumns()()()() (Inherited from XlsRange.)
AutoFitRows()()()() (Inherited from XlsRange.)
BooleanValue (Inherited from XlsRange.)
BorderAround()()()() (Inherited from XlsRange.)
BorderAround(LineStyleType) (Inherited from XlsRange.)
BorderAround(LineStyleType, ExcelColors) (Inherited from XlsRange.)
BorderAround(LineStyleType, Color) (Inherited from XlsRange.)
BorderInside()()()() (Inherited from XlsRange.)
BorderInside(LineStyleType) (Inherited from XlsRange.)
BorderInside(LineStyleType, ExcelColors) (Inherited from XlsRange.)
BorderInside(LineStyleType, Color) (Inherited from XlsRange.)
BorderNone()()()() (Inherited from XlsRange.)
Borders
BuiltInStyle (Inherited from XlsRange.)
CellList
Cells Obsolete.
CellsCount (Inherited from XlsRange.)
CellStyleName (Inherited from XlsRange.)
CheckDisposed()()()() (Inherited from XlsObject.)
CheckRange(Int32, Int32) (Inherited from XlsRange.)
Clear(Boolean) (Inherited from XlsRange.)
Clear(ExcelClearOptions) (Inherited from XlsRange.)
ClearAll()()()() (Inherited from XlsRange.)
ClearConditionalFormats()()()() (Inherited from XlsRange.)
ClearContents()()()() (Inherited from XlsRange.)
Clone(Object, Dictionary<(Of <<'(String, String>)>>), Workbook)
Clone(Object, Dictionary<(Of <<'(String, String>)>>), XlsWorkbook) (Inherited from XlsRange.)
CollapseGroup(GroupByType) (Inherited from XlsRange.)
Column (Inherited from XlsRange.)
ColumnCount (Inherited from XlsRange.)
ColumnGroupLevel (Inherited from XlsRange.)
Columns
ColumnWidth (Inherited from XlsRange.)
CombinedCells (Inherited from XlsRange.)
Comment
ConditionalFormats Obsolete. (Inherited from XlsRange.)
ConvertToNumber()()()() (Inherited from XlsRange.)
Copy(CellRange)
Copy(CellRange, CopyRangeOptions)
Copy(CellRange, Boolean)
Copy(CellRange, Boolean, Boolean)
CopyToClipboard()()()() Obsolete. (Inherited from XlsRange.)
Count (Inherited from XlsRange.)
DataValidation (Inherited from XlsRange.)
DateTimeValue (Inherited from XlsRange.)
DisplayedText (Inherited from XlsRange.)
Dispose()()()() (Inherited from XlsRange.)
EndCell
EntireColumn
EntireRow
EnvalutedValue (Inherited from XlsRange.)
Equals(Object)
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
ErrorValue (Inherited from XlsRange.)
ExpandGroup(GroupByType) (Inherited from XlsRange.)
ExpandGroup(GroupByType, ExpandCollapseFlags) (Inherited from XlsRange.)
ExportDataTable(ExportTableOptions) (Inherited from XlsRange.)
ExtendedFormatIndex (Inherited from XlsRange.)
Finalize()()()() (Inherited from XlsObject.)
FindAll(Boolean) (Inherited from XlsRange.)
FindAll(DateTime) (Inherited from XlsRange.)
FindAll(TimeSpan) (Inherited from XlsRange.)
FindAll(Double, FindType) (Inherited from XlsRange.)
FindAll(String, FindType) (Inherited from XlsRange.)
FindAllBool(Boolean)
FindAllDateTime(DateTime)
FindAllNumber(Double, Boolean)
FindAllString(String, Boolean, Boolean)
FindAllTimeSpan(TimeSpan)
FindBool(Boolean)
FindDateTime(DateTime)
FindFirst(Boolean) (Inherited from XlsRange.)
FindFirst(DateTime) (Inherited from XlsRange.)
FindFirst(TimeSpan) (Inherited from XlsRange.)
FindFirst(Double, FindType) (Inherited from XlsRange.)
FindFirst(String, FindType) (Inherited from XlsRange.)
FindNumber(Double, Boolean)
FindParent(Type) (Inherited from XlsObject.)
FindParent(array<Type>[]()[][]) (Inherited from XlsObject.)
FindParent(Type, Boolean) (Inherited from XlsObject.)
FindParents(array<Type>[]()[][]) (Inherited from XlsObject.)
FindString(String, Boolean, Boolean)
FindTimeSpan(TimeSpan)
FindWorksheet(String) (Inherited from XlsRange.)
FirstColumn (Inherited from XlsRange.)
FirstRow (Inherited from XlsRange.)
Formula (Inherited from XlsRange.)
FormulaArray (Inherited from XlsRange.)
FormulaArrayR1C1 (Inherited from XlsRange.)
FormulaBoolValue (Inherited from XlsRange.)
FormulaDateTime (Inherited from XlsRange.)
FormulaErrorValue (Inherited from XlsRange.)
FormulaNumberValue (Inherited from XlsRange.)
FormulaR1C1 (Inherited from XlsRange.)
FormulaStringValue (Inherited from XlsRange.)
FormulaValue (Inherited from XlsRange.)
FreezePanes()()()() (Inherited from XlsRange.)
GetDependentRanges(Boolean)
GetEnumerator()()()() (Inherited from XlsRange.)
GetHashCode()()()()
Serves as a hash function for a particular type.
(Inherited from Object.)
GetNewRangeLocation(Dictionary<(Of <<'(String, String>)>>), String%) (Inherited from XlsRange.)
GetRectangles()()()() (Inherited from XlsRange.)
GetRectanglesCount()()()() (Inherited from XlsRange.)
GetReferRanges()()()()
GetType()()()()
Gets the Type of the current instance.
(Inherited from Object.)
GroupByColumns(Boolean) (Inherited from XlsRange.)
GroupByRows(Boolean) (Inherited from XlsRange.)
HasBoolean (Inherited from XlsRange.)
HasComment (Inherited from XlsRange.)
HasConditionFormats (Inherited from XlsRange.)
HasDataValidation (Inherited from XlsRange.)
HasDateTime (Inherited from XlsRange.)
HasError (Inherited from XlsRange.)
HasExternalFormula (Inherited from XlsRange.)
HasFormula (Inherited from XlsRange.)
HasFormulaArray (Inherited from XlsRange.)
HasFormulaBoolValue (Inherited from XlsRange.)
HasFormulaDateTime (Inherited from XlsRange.)
HasFormulaErrorValue (Inherited from XlsRange.)
HasFormulaNumberValue (Inherited from XlsRange.)
HasFormulaStringValue (Inherited from XlsRange.)
HasMerged (Inherited from XlsRange.)
HasNumber (Inherited from XlsRange.)
HasPictures (Inherited from XlsRange.)
HasRichText (Inherited from XlsRange.)
HasString (Inherited from XlsRange.)
HasStyle (Inherited from XlsRange.)
HorizontalAlignment (Inherited from XlsRange.)
HtmlString (Inherited from XlsRange.)
Hyperlinks (Inherited from XlsRange.)
IgnoreErrorOptions (Inherited from XlsRange.)
IndentLevel (Inherited from XlsRange.)
InfillCells()()()() (Inherited from XlsRange.)
Intersect(CellRange)
Intersect(IXLSRange) (Inherited from XlsRange.)
IsAllNumber (Inherited from XlsRange.)
IsBlank (Inherited from XlsRange.)
IsFormulaHidden (Inherited from XlsRange.)
IsGroupedByColumn (Inherited from XlsRange.)
IsGroupedByRow (Inherited from XlsRange.)
IsInitialized (Inherited from XlsRange.)
IsIntersect(IXLSRange) (Inherited from XlsRange.)
IsSingleCell (Inherited from XlsRange.)
IsStringsPreserved (Inherited from XlsRange.)
IsWrapText (Inherited from XlsRange.)
Item[([( String])])
Item[([( Int32, Int32])])
Item[([( String, Boolean])])
Item[([( Int32, Int32, Int32, Int32])])
LastColumn (Inherited from XlsRange.)
LastRow (Inherited from XlsRange.)
m_bIsDisposed (Inherited from XlsObject.)
m_book (Inherited from XlsRange.)
m_iBottomRow (Inherited from XlsRange.)
m_iLeftColumn (Inherited from XlsRange.)
m_iRightColumn (Inherited from XlsRange.)
m_iTopRow (Inherited from XlsRange.)
m_style (Inherited from XlsRange.)
MeasureString(String) (Inherited from XlsRange.)
MemberwiseClone()()()()
Creates a shallow copy of the current Object.
(Inherited from Object.)
Merge()()()() (Inherited from XlsRange.)
Merge(Boolean) (Inherited from XlsRange.)
Merge(CellRange)
Merge(IXLSRange) (Inherited from XlsRange.)
MergeArea
Move(CellRange)
Move(CellRange, Boolean, Boolean)
MoveTo(IXLSRange) (Inherited from XlsRange.)
MoveTo(IXLSRange, Boolean) (Inherited from XlsRange.)
NumberFormat (Inherited from XlsRange.)
NumberText (Inherited from XlsRange.)
NumberValue (Inherited from XlsRange.)
OnDispose()()()() (Inherited from XlsObject.)
Parent (Inherited from XlsRange.)
PartialClear()()()() (Inherited from XlsRange.)
RangeAddress (Inherited from XlsRange.)
RangeAddressLocal (Inherited from XlsRange.)
RangeGlobalAddress (Inherited from XlsRange.)
RangeGlobalAddress2007 (Inherited from XlsRange.)
RangeGlobalAddressWithoutSheetName (Inherited from XlsRange.)
RangeR1C1Address (Inherited from XlsRange.)
RangeR1C1AddressLocal (Inherited from XlsRange.)
ReferenceCount (Inherited from XlsObject.)
ReleaseReference()()()() (Inherited from XlsObject.)
RemoveCombinedRange(CellRange) (Inherited from XlsRange.)
ReparseFormulaString()()()() (Inherited from XlsRange.)
Replace(String, DateTime) (Inherited from XlsRange.)
Replace(String, Double) (Inherited from XlsRange.)
Replace(String, String) (Inherited from XlsRange.)
Replace(String, DataColumn, Boolean) (Inherited from XlsRange.)
Replace(String, DataTable, Boolean) (Inherited from XlsRange.)
Replace(String, array<Double>[]()[][], Boolean) (Inherited from XlsRange.)
Replace(String, array<Int32>[]()[][], Boolean) (Inherited from XlsRange.)
Replace(String, array<String>[]()[][], Boolean) (Inherited from XlsRange.)
RichText
Row (Inherited from XlsRange.)
RowCount (Inherited from XlsRange.)
RowGroupLevel (Inherited from XlsRange.)
RowHeight (Inherited from XlsRange.)
Rows
SetAutoFormat(AutoFormatType) Obsolete. (Inherited from XlsRange.)
SetAutoFormat(AutoFormatType, AutoFormatOptions) Obsolete. (Inherited from XlsRange.)
SetBorderToSingleCell(BordersLineType, LineStyleType, ExcelColors) (Inherited from XlsRange.)
SetDataValidation(Validation)
SetDataValidation(XlsValidation) (Inherited from XlsRange.)
SetExtendedFormatIndex(Int32) (Inherited from XlsRange.)
SetParent(Object) (Inherited from XlsObject.)
SetRowHeight(Double, Boolean) (Inherited from XlsRange.)
SetSharedFormula(String, Int32, Int32) (Inherited from XlsRange.)
Style
Text (Inherited from XlsRange.)
TextPartReplace(String, String) (Inherited from XlsRange.)
TimeSpanValue (Inherited from XlsRange.)
ToString()()()()
Returns a String that represents the current Object.
(Inherited from Object.)
UngroupByColumns()()()() (Inherited from XlsRange.)
UngroupByRows()()()() (Inherited from XlsRange.)
Union(CellRange) (Inherited from XlsRange.)
UnMerge()()()() (Inherited from XlsRange.)
UpdateRange(Int32, Int32, Int32, Int32) (Inherited from XlsRange.)
Value (Inherited from XlsRange.)
Value2 (Inherited from XlsRange.)
VerticalAlignment (Inherited from XlsRange.)
Workbook (Inherited from XlsRange.)
Worksheet
WorksheetName (Inherited from XlsRange.)

Inheritance Hierarchy

See Also