menu

ASP.NET Core

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Interface IRanges

    Show / Hide Table of Contents

    Interface IRanges

    Represents a collection of ranges.

    Inherited Members
    IRange.Activate()
    IRange.Activate(Boolean)
    IRange.Group(ExcelGroupBy)
    IRange.Group(ExcelGroupBy, Boolean)
    IRange.SubTotal(Int32, ConsolidationFunction, Int32[])
    IRange.SubTotal(Int32, ConsolidationFunction, Int32[], Boolean, Boolean, Boolean)
    IRange.SubTotal(Int32[], ConsolidationFunction, Int32[], Boolean, Boolean, Boolean)
    IRange.Sum()
    IRange.Sum(Boolean)
    IRange.Average()
    IRange.Average(Boolean)
    IRange.Min()
    IRange.Min(Boolean)
    IRange.Max()
    IRange.Max(Boolean)
    IRange.Trim()
    IRange.Merge()
    IRange.Merge(Boolean)
    IRange.Ungroup(ExcelGroupBy)
    IRange.UnMerge()
    IRange.FreezePanes()
    IRange.Clear()
    IRange.Clear(Boolean)
    IRange.Clear(ExcelClearOptions)
    IRange.Clear(ExcelMoveDirection)
    IRange.Clear(ExcelMoveDirection, ExcelCopyRangeOptions)
    IRange.MoveTo(IRange)
    IRange.CopyTo(IRange)
    IRange.CopyTo(IRange, ExcelCopyRangeOptions)
    IRange.CopyTo(IRange, Boolean)
    IRange.CopyTo(IRange, ExcelCopyRangeOptions, Boolean)
    IRange.IntersectWith(IRange)
    IRange.MergeWith(IRange)
    IRange.AutofitRows()
    IRange.AutofitColumns()
    IRange.AddComment()
    IRange.FindFirst(String, ExcelFindType)
    IRange.FindFirst(Double, ExcelFindType)
    IRange.FindFirst(Boolean)
    IRange.FindFirst(DateTime)
    IRange.FindFirst(TimeSpan)
    IRange.FindAll(String, ExcelFindType)
    IRange.FindAll(Double, ExcelFindType)
    IRange.FindAll(Boolean)
    IRange.FindAll(DateTime)
    IRange.FindAll(TimeSpan)
    IRange.Replace(String, String)
    IRange.Replace(String, String, ExcelFindOptions)
    IRange.Replace(String, Double)
    IRange.Replace(String, DateTime)
    IRange.Replace(String, String[], Boolean)
    IRange.Replace(String, Int32[], Boolean)
    IRange.Replace(String, Double[], Boolean)
    IRange.Replace(String, DataTable, Boolean)
    IRange.Replace(String, DataColumn, Boolean)
    IRange.BorderAround()
    IRange.BorderAround(ExcelLineStyle)
    IRange.BorderAround(ExcelLineStyle, Color)
    IRange.BorderAround(ExcelLineStyle, ExcelKnownColors)
    IRange.BorderInside()
    IRange.BorderInside(ExcelLineStyle)
    IRange.BorderInside(ExcelLineStyle, Color)
    IRange.BorderInside(ExcelLineStyle, ExcelKnownColors)
    IRange.BorderNone()
    IRange.CollapseGroup(ExcelGroupBy)
    IRange.ExpandGroup(ExcelGroupBy)
    IRange.ExpandGroup(ExcelGroupBy, ExpandCollapseFlags)
    IRange.GetDependents()
    IRange.GetDependents(Boolean)
    IRange.GetDirectDependents()
    IRange.GetDirectDependents(Boolean)
    IRange.GetPrecedents()
    IRange.GetPrecedents(Boolean)
    IRange.GetDirectPrecedents()
    IRange.GetDirectPrecedents(Boolean)
    IRange.Offset(Int32, Int32)
    IRange.Resize(Int32, Int32)
    IRange.Address
    IRange.AddressLocal
    IRange.AddressGlobal
    IRange.AddressR1C1
    IRange.AddressR1C1Local
    IRange.Boolean
    IRange.Borders
    IRange.Cells
    IRange.Column
    IRange.ColumnGroupLevel
    IRange.ColumnWidth
    IRange.Count
    IRange.DateTime
    IRange.DisplayText
    IRange.End
    IRange.EntireColumn
    IRange.EntireRow
    IRange.Error
    IRange.Formula
    IRange.FormulaArray
    IRange.FormulaArrayR1C1
    IRange.FormulaHidden
    IRange.FormulaDateTime
    IRange.FormulaR1C1
    IRange.FormulaBoolValue
    IRange.FormulaErrorValue
    IRange.HasDataValidation
    IRange.HasBoolean
    IRange.HasDateTime
    IRange.HasFormula
    IRange.HasFormulaArray
    IRange.HasNumber
    IRange.HasRichText
    IRange.HasString
    IRange.HasStyle
    IRange.HorizontalAlignment
    IRange.Hyperlinks
    IRange.IndentLevel
    IRange.IsBlank
    IRange.IsBoolean
    IRange.IsError
    IRange.IsGroupedByColumn
    IRange.IsGroupedByRow
    IRange.IsInitialized
    IRange.LastColumn
    IRange.LastRow
    IRange.Number
    IRange.NumberFormat
    IRange.Row
    IRange.RowGroupLevel
    IRange.RowHeight
    IRange.Rows
    IRange.Columns
    IRange.CellStyle
    IRange.CellStyleName
    IRange.Text
    IRange.TimeSpan
    IRange.Value
    IRange.CalculatedValue
    IRange.Value2
    IRange.VerticalAlignment
    IRange.Worksheet
    IRange.Item[Int32, Int32]
    IRange.Item[Int32, Int32, Int32, Int32]
    IRange.Item[String]
    IRange.Item[String, Boolean]
    IRange.ConditionalFormats
    IRange.DataValidation
    IRange.FormulaStringValue
    IRange.FormulaNumberValue
    IRange.HasFormulaBoolValue
    IRange.HasFormulaErrorValue
    IRange.HasFormulaDateTime
    IRange.HasFormulaNumberValue
    IRange.HasFormulaStringValue
    IRange.Comment
    IRange.RichText
    IRange.IsMerged
    IRange.MergeArea
    IRange.WrapText
    IRange.HasExternalFormula
    IRange.IgnoreErrorOptions
    IRange.IsStringsPreserved
    IRange.BuiltInStyle
    IRange.HtmlString
    IParentApplication.Application
    IParentApplication.Parent
    System.Collections.Generic.IEnumerable<Syncfusion.XlsIO.IRange>.GetEnumerator()
    Namespace: Syncfusion.XlsIO
    Assembly: Syncfusion.XlsIO.Base.dll
    Syntax
    public interface IRanges : IRange, IParentApplication, IEnumerable<IRange>, IEnumerable

    Properties

    Item[Int32]

    Returns the Range by index from the collection.

    Declaration
    IRange this[int index] { get; }
    Parameters
    Type Name Description
    System.Int32 index
    Property Value
    Type Description
    IRange

    Methods

    Add(IRange)

    Adds new range to the collection.

    Declaration
    void Add(IRange range)
    Parameters
    Type Name Description
    IRange range

    Range to add.

    Remove(IRange)

    Removes range from the collection.

    Declaration
    void Remove(IRange range)
    Parameters
    Type Name Description
    IRange range

    Range to remove.

    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved