Loading Data from Excel

This article is for Excel Add-ins.

Excel Add-ins can be used to work with external data sources and update data directly in Excel. A common question is whether it is possible to load arbitrary data from an Excel worksheet into a connected database or cloud storage.

Solution

Devart Excel Add-ins operate only with data that was initially retrieved from the corresponding data source using the add-ins. Any changes to this data can be stored back in the source.

Importing standalone worksheet data into a data source is not supported. New records can be added, but only within the dataset that was originally obtained through the add-ins.