alexa
menu

MAUI

  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Search Results for

    Show / Hide Table of Contents

    Interface IWorksheets

    A collection of all the Worksheet objects in the specified or active workbook. Each Worksheet object represents a worksheet.

    Inherited Members
    IEnumerable<IWorksheet>.GetEnumerator()
    Namespace: Syncfusion.XlsIO
    Assembly: Syncfusion.XlsIO.NET.dll
    Syntax
    public interface IWorksheets : IEnumerable<IWorksheet>, IEnumerable

    Properties

    Application

    Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application.

    Declaration
    IApplication Application { get; }
    Property Value
    Type
    IApplication

    Count

    Gets the number of objects in the collection. Read-only Long.

    Declaration
    int Count { get; }
    Property Value
    Type
    int

    this[int]

    Gets a single object from a collection based on specified int value. Read-only.

    Declaration
    IWorksheet this[int Index] { get; }
    Parameters
    Type Name Description
    int Index
    Property Value
    Type
    IWorksheet

    this[string]

    Gets a single object from a collection based on specified string value. Read-only.

    Declaration
    IWorksheet this[string sheetName] { get; }
    Parameters
    Type Name Description
    string sheetName
    Property Value
    Type
    IWorksheet

    Parent

    Gets the parent object for the specified object.

    Declaration
    object Parent { get; }
    Property Value
    Type
    object

    UseRangesCache

    Indicates whether all created range objects should be cached or not.

    Declaration
    bool UseRangesCache { get; set; }
    Property Value
    Type
    bool

    Methods

    AddCopy(IWorksheet)

    Add a copy of the specified worksheet to the worksheet collection.

    Declaration
    IWorksheet AddCopy(IWorksheet sourceSheet)
    Parameters
    Type Name Description
    IWorksheet sourceSheet

    Worksheet to add. It is not necessary; should be worksheet from this collection.

    Returns
    Type Description
    IWorksheet

    Added worksheet.

    AddCopy(IWorksheet, ExcelWorksheetCopyFlags)

    Adds copy of worksheet.

    Declaration
    IWorksheet AddCopy(IWorksheet sheet, ExcelWorksheetCopyFlags flags)
    Parameters
    Type Name Description
    IWorksheet sheet

    Worksheet to copy.

    ExcelWorksheetCopyFlags flags

    Represents copy flags.

    Returns
    Type Description
    IWorksheet

    Copy of worksheet that was added.

    AddCopy(IWorksheets)

    Add a copy of the specified worksheets to the worksheet collection.

    Declaration
    void AddCopy(IWorksheets worksheets)
    Parameters
    Type Name Description
    IWorksheets worksheets

    Worksheets to add.

    AddCopy(IWorksheets, ExcelWorksheetCopyFlags)

    Adding worksheets collection to current workbook.

    Declaration
    void AddCopy(IWorksheets worksheets, ExcelWorksheetCopyFlags flags)
    Parameters
    Type Name Description
    IWorksheets worksheets

    Source worksheets collection.

    ExcelWorksheetCopyFlags flags

    Represents copy option flags.

    AddCopy(int)

    Add a copy of the specified worksheet to the worksheet collection.

    Declaration
    IWorksheet AddCopy(int sheetIndex)
    Parameters
    Type Name Description
    int sheetIndex

    Index of the workbook that should be copied

    Returns
    Type Description
    IWorksheet

    Returns newly added Worksheet object

    AddCopy(int, ExcelWorksheetCopyFlags)

    Add a copy of the specified worksheet to the worksheet collection.

    Declaration
    IWorksheet AddCopy(int sheetIndex, ExcelWorksheetCopyFlags flags)
    Parameters
    Type Name Description
    int sheetIndex

    Index of the workbook that should be copied

    ExcelWorksheetCopyFlags flags

    Represents copy options flags.

    Returns
    Type Description
    IWorksheet

    Returns copied sheet.

    AddCopyAfter(IWorksheet)

    Adds copy of sheet to collection after chosen sheet.

    Declaration
    IWorksheet AddCopyAfter(IWorksheet toCopy)
    Parameters
    Type Name Description
    IWorksheet toCopy

    Represents worksheet to copy.

    Returns
    Type Description
    IWorksheet

    Returns copied sheet.

    AddCopyAfter(IWorksheet, IWorksheet)

    Adds copy of sheet to collection before chosen sheet.

    Declaration
    IWorksheet AddCopyAfter(IWorksheet toCopy, IWorksheet sheetBefore)
    Parameters
    Type Name Description
    IWorksheet toCopy

    Represents worksheet to copy.

    IWorksheet sheetBefore

    Represents sheet that, in collection must be before copied sheet.

    Returns
    Type Description
    IWorksheet

    Returns copied sheet.

    AddCopyBefore(IWorksheet)

    Adds copy of sheet to collection before chosen sheet.

    Declaration
    IWorksheet AddCopyBefore(IWorksheet toCopy)
    Parameters
    Type Name Description
    IWorksheet toCopy

    Represents worksheet to copy.

    Returns
    Type Description
    IWorksheet

    Returns copied sheet.

    AddCopyBefore(IWorksheet, IWorksheet)

    Adds copy of sheet to collection before chosen sheet.

    Declaration
    IWorksheet AddCopyBefore(IWorksheet toCopy, IWorksheet sheetAfter)
    Parameters
    Type Name Description
    IWorksheet toCopy

    Represents worksheet to copy.

    IWorksheet sheetAfter

    Represents sheet that, in collection must be after copied sheet.

    Returns
    Type Description
    IWorksheet

    Returns copied sheet.

    Create()

    Create a new worksheet.

    Declaration
    IWorksheet Create()
    Returns
    Type Description
    IWorksheet

    Reference on created worksheet.

    Create(string)

    Create worksheet with specified name.

    Declaration
    IWorksheet Create(string name)
    Parameters
    Type Name Description
    string name

    New name of worksheet. Must be unique for collection.

    Returns
    Type Description
    IWorksheet

    Reference on created worksheet.

    FindAll(bool)

    Returns the cells of the specified bool value.

    Declaration
    IRange[] FindAll(bool findValue)
    Parameters
    Type Name Description
    bool findValue

    Value to search.

    Returns
    Type Description
    IRange[]

    Returns the cells with a specified bool value, or null if value was not found.

    FindAll(DateTime)

    Returns the cells of the specified DateTime value.

    Declaration
    IRange[] FindAll(DateTime findValue)
    Parameters
    Type Name Description
    DateTime findValue

    Value to search.

    Returns
    Type Description
    IRange[]

    Returns the cells with a specified DateTime value, or null if value was not found.

    FindAll(double, ExcelFindType)

    Returns the cells of the specified double value with the specified ExcelFindType.

    Declaration
    IRange[] FindAll(double findValue, ExcelFindType flags)
    Parameters
    Type Name Description
    double findValue

    Value to search.

    ExcelFindType flags

    Type of value to search.

    Returns
    Type Description
    IRange[]

    All found cells, or Null if value was not found.

    FindAll(string, ExcelFindType)

    Returns the cells of the specified string value with the specified ExcelFindType.

    Declaration
    IRange[] FindAll(string findValue, ExcelFindType flags)
    Parameters
    Type Name Description
    string findValue

    Value to search.

    ExcelFindType flags

    Type of value to search.

    Returns
    Type Description
    IRange[]

    Returns the cells with a specified string value, or null if value was not found.

    FindAll(string, ExcelFindType, ExcelFindOptions)

    Returns the cells of the specified string value with the specified ExcelFindType and ExcelFindOptions.

    Declaration
    IRange[] FindAll(string findValue, ExcelFindType flags, ExcelFindOptions findOptions)
    Parameters
    Type Name Description
    string findValue

    Value to search.

    ExcelFindType flags

    Type of value to search.

    ExcelFindOptions findOptions

    Way to search.

    Returns
    Type Description
    IRange[]

    Returns the cells with a specified string value and specified find options , or null if value was not found.

    FindAll(TimeSpan)

    Returns the cells of the specified TimeSpan value.

    Declaration
    IRange[] FindAll(TimeSpan findValue)
    Parameters
    Type Name Description
    TimeSpan findValue

    Value to search.

    Returns
    Type Description
    IRange[]

    Returns the cells with a specified TimeSpan value, or null if value was not found.

    FindFirst(bool)

    Returns the first occurrence of the specified bool value.

    Declaration
    IRange FindFirst(bool findValue)
    Parameters
    Type Name Description
    bool findValue

    Value to search.

    Returns
    Type Description
    IRange

    Returns the first cell with a specified bool value, or null if value was not found.

    FindFirst(DateTime)

    Returns the first occurrence of the specified DateTime value.

    Declaration
    IRange FindFirst(DateTime findValue)
    Parameters
    Type Name Description
    DateTime findValue

    Value to search.

    Returns
    Type Description
    IRange

    Returns the first cell with a specified DateTime value, or null if value was not found.

    FindFirst(double, ExcelFindType)

    Returns the first occurrence of the specified double value with the specified ExcelFindType.

    Declaration
    IRange FindFirst(double findValue, ExcelFindType flags)
    Parameters
    Type Name Description
    double findValue

    Value to search.

    ExcelFindType flags

    Type of value to search.

    Returns
    Type Description
    IRange

    Returns the first cell with a specified double value, or null if value was not found.

    FindFirst(string, ExcelFindType)

    Returns the first occurrence of the specified string value with the specified ExcelFindType.

    Declaration
    IRange FindFirst(string findValue, ExcelFindType flags)
    Parameters
    Type Name Description
    string findValue

    Value to search.

    ExcelFindType flags

    Type of value to search.

    Returns
    Type Description
    IRange

    Returns the first cell with a specified string value, or null if value was not found.

    FindFirst(string, ExcelFindType, ExcelFindOptions)

    Returns the first occurrence of the specified string value with the specified ExcelFindType and ExcelFindOptions.

    Declaration
    IRange FindFirst(string findValue, ExcelFindType flags, ExcelFindOptions findOptions)
    Parameters
    Type Name Description
    string findValue

    Value to search.

    ExcelFindType flags

    Type of value to search.

    ExcelFindOptions findOptions

    Way to search the value.

    Returns
    Type Description
    IRange

    Returns the first cell with a specified string value and specified find options , or null if value was not found.

    FindFirst(TimeSpan)

    Returns the first occurrence of the specified TimeSpan value.

    Declaration
    IRange FindFirst(TimeSpan findValue)
    Parameters
    Type Name Description
    TimeSpan findValue

    Value to search.

    Returns
    Type Description
    IRange

    Returns the first cell with a specified TimeSpan value, or null if value was not found.

    Remove(IWorksheet)

    Remove worksheet from collection.

    Declaration
    void Remove(IWorksheet sheet)
    Parameters
    Type Name Description
    IWorksheet sheet

    Reference on worksheet to remove.

    Remove(int)

    Removes specified worksheet from the collection.

    Declaration
    void Remove(int index)
    Parameters
    Type Name Description
    int index

    Index of the sheet to remove.

    Remove(string)

    Removes specified worksheet from the collection.

    Declaration
    void Remove(string sheetName)
    Parameters
    Type Name Description
    string sheetName

    Name of the sheet to remove.

    Extension Methods

    CalcEngineHelper.ToArray<T>(IEnumerable<T>)
    In this article
    Back to top Generated by DocFX
    Copyright © 2001 - 2026 Syncfusion Inc. All Rights Reserved