Devart Excel Add-ins is a package of add-ins for Excel that allows for importing of data from various data sources into Excel worksheets. Many of the Excel features can then be used to process this data, create charts and so on. In addition, data can be also edited and exported back to data source.
When installing add-ins you can choose from a number of databases and cloud data sources from which you would like to extract the data. These include various popular accounting apps, e-commerce solutions, databases and similar data sources.
For importing the data to Excel, you must click on 'Get Data'. Here you must choose data source and specify login credentials. In the next step of import process, after the connection has been successfully established, you can use SQL or query builder to specify the data you want to import, and you also get to preview the data before finalizing the import.
Data can be refreshed arbitrarily from the data source, and you can also modify cells, and add or delete rows, by enabling 'Edit Mode'. After you have finished editing process, all the modifications can be easily saved back to data source, by clicking on 'Commit' button. Changed or added data also gets checked for errors in real time, ensuring all the values are compatible with data source field types.
Reviewed by Tony Hill (editor rating 4 out of 5 stars)
on
Additional info
Minimum requirements
• .NET Framework 4.0 or higher • Visual Studio 2010 Tools for Office Runtime