Back to Devexpress

ExternalWorkbookCollection Interface

officefileapi-devexpress-dot-spreadsheet-99b065cd.md

latest2.6 KB
Original Source

ExternalWorkbookCollection Interface

A collection of external workbooks.

Namespace : DevExpress.Spreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
public interface ExternalWorkbookCollection :
    ISimpleCollection<ExternalWorkbook>,
    IEnumerable<ExternalWorkbook>,
    IEnumerable,
    ICollection,
    ICollection<ExternalWorkbook>
vb
Public Interface ExternalWorkbookCollection
    Inherits ISimpleCollection(Of ExternalWorkbook),
             IEnumerable(Of ExternalWorkbook),
             IEnumerable,
             ICollection,
             ICollection(Of ExternalWorkbook)

The following members return ExternalWorkbookCollection objects:

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.).

See Also

ExternalWorkbookCollection Members

Cell Referencing

How to: Update External References in the Loaded Workbook

DevExpress.Spreadsheet Namespace