Skip to content

Add a workbook to the collection of source workbooks to create external references in the current document.

License

Notifications You must be signed in to change notification settings

DevExpress-Examples/spreadsheet-document-api-external-workbook

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

19 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Spreadsheet Document API - Insert a Reference to an External Workbook

This example demonstrates how to insert an external reference link from a workbook to another workbook.

An external workbook is created and populated with random data by importing a data table at runtime. Subsequently, the workbook is added to the ExternalWorkbookCollection. A cell formula with a reference to an external workbook is inserted in the current worksheet. The worksheet is saved to .XLSX file and opened with an application registered for that file format.

Important

The Universal Subscription or an additional Office File API Subscription is required to use this example in production code. Please refer to the DevExpress Subscription page for pricing information.

Files to Review

Documentation