ExternalWorkbookCollection Interface

A collection of external workbooks.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v18.2.Core.dll

Declaration

C#

public interface ExternalWorkbookCollection :
    ISimpleCollection<ExternalWorkbook>,
    IEnumerable<ExternalWorkbook>,
    IEnumerable,
    ICollection,
    ICollection<ExternalWorkbook>

VB.NET

Public Interface ExternalWorkbookCollection
    Inherits ISimpleCollection(Of ExternalWorkbook),
             IEnumerable(Of ExternalWorkbook),
             IEnumerable,
             ICollection,
             ICollection(Of ExternalWorkbook)

Related API Members

The following members return ExternalWorkbookCollection objects:

• IWorkbook.ExternalWorkbooks
• Workbook.ExternalWorkbooks

Remarks

The ExternalWorkbookCollection object is accessible by using the IWorkbook.ExternalWorkbooks property. The collection contains ExternalWorkbook objects.

To add an ExternalWorkbook to the collection, use the collection’s Add method. When a workbook is loaded in a collection of external workbooks, you can revise and update external references to that workbook contained in worksheets within a base workbook.

Subscribe to the ExternalWorkbook.SchemaChanged event to be notified when the external workbook structure changes (worksheets added/removed/renamed, defined names changed etc.).