Devart Excel Add-ins allow using powerful Excel capabilities for processing and analysis of data from cloud applications and relational databases, editing external data as usual excel spreadsheets and saving data changes back to the data source
Version: 1.8Devart Excel Add-ins allow you to use powerful Excel capabilities for processing and analysis of data from cloud applications and relational databases, edit external data as usual excel spreadsheets and save data changes back to the data source you have imported them from.
License: Free To Try $99.95
Operating System: Windows
Key Features:Powerful Data Import
With Devart Excel Add-ins you can precisely configure what data to load into the document. Select objects and columns and set complex data filters.
If this is not enough, all the power of SQL is to your service, not only for relational databases, but for cloud applications too.
Quick Data Refresh
The main Devart Excel Add-ins benefit is an ability to periodically get the actual data from different data sources to Excel with a single click without repeating the whole import operation each time. Refresh data in your workbook easily whenever you want.
Easy Data Modification You can edit data in Excel just like you usually do it, add or delete rows, modify cell values, etc.
Use full power of Excel to perform mass data update, insert, and delete operations against your data source. After you finished editing, just click Commit and the changes will be posted back to the data source.
List of supported data sources:
- Oracle Database
- SQL Server
- Dynamics CRM
- Zoho CRM
Version 1.8: *New FreshBooks API (alpha) is supported *The API v2 for Zoho CRM is supported *The PaymentPayouts object is added to Shopify *The default value for the "API Version" connection parameter for MailChimp is changed from v2 to v3