Loading Data from Excel

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.

    • Related Articles

    • Excel Add-ins. Slow Data Extraction (Database Providers)

      This article is for Excel Add-ins (Databases). Navigation: Supported Data Sources → Supported databases: Data loading into Excel may work noticeably slower compared to executing the same query in other tools. Performance can be improved by adjusting ...

    • Excel Add-ins. Slow Data Extraction (Cloud Providers)

      This article is for Excel Add-ins (Clouds). Navigation: Supported Data Sources → Supported cloud applications: When working with Excel Add-ins connected to cloud sources such as Salesforce or QuickBooks, data loading may be noticeably slower than ...

    • Excel Automation

      This article is for Excel Add-ins. The scenario involves building an automation system based on Devart Excel Add-ins, with data transfer between different sources, synchronization, and automatic data updates. Solution Devart Excel Add-ins are ...

    • Devart tab disappears in Microsoft Excel

      Microsoft Excel may disable Add-ins automatically if errors occur or if they take too long to finish their operations. However, you can re-enable the Add-ins without needing to restart your operating system. For this, follow the steps below: Open ...

    • Accessing Server Response Data with TScHttpWebRequest

      When working with TScHttpWebRequest, it's crucial to properly handle potential server errors to access any data returned by the server, even in error scenarios. The HttpException provides valuable information about the server's response in case of an ...