Excel add-ins package for importing of data from various data sources
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.
What's new in this version
• Data refresh and Edit Mode are significantly improved
• Microsoft Excel
.NET Framework 4.0 or higher
Visual Studio 2010 Tools for Office Runtime
• 30-day trial
Operating system: Win 2000, Win XP, Win Vista, Win Vista 64 bit, Win Server 2008, Win 7, Win 7 64 bit, Win 8, Win 10, Win Other, Win Server
Supported languages: English
Release date: 2018-03-19
Downloads last week: 0