IWorkbook.ExternalWorkbooks Property

Provides access to the collection of source workbooks used for creating external references in the current workbook.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

ExternalWorkbookCollection ExternalWorkbooks { get; }

VB.NET

ReadOnly Property ExternalWorkbooks As ExternalWorkbookCollection

Property Value

Type	Description
ExternalWorkbookCollection	An ExternalWorkbookCollection object.

Remarks

Add a workbook to the ExternalWorkbooks collection to use references to its cells and defined names in the current workbook.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ExternalWorkbooks property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-reference-an-external-workbook-t144947/CS/ExternalWorkbookSample/Form1.cs#L21

externalWorkbook.Options.Save.CurrentFileName = "ExternalDocument.xlsx";
foreach (IWorkbook item in spreadsheetControl1.Document.ExternalWorkbooks)
{

VB.NET

how-to-reference-an-external-workbook-t144947/VB/ExternalWorkbookSample/Form1.vb#L19

externalWorkbook.Options.Save.CurrentFileName = "ExternalDocument.xlsx"
For Each item As IWorkbook In spreadsheetControl1.Document.ExternalWorkbooks
    If item.Options.Save.CurrentFileName = externalWorkbook.Options.Save.CurrentFileName Then