Devart Excel Add-ins allow you to work with database and cloud data in Microsoft Excel in the same way that you work with usual Excel spreadsheets.
With Devart Excel Add-ins you can obtain precisely the data you need with visual Query Builder or with SQL, and then refresh the queried external data in a workbook with a single click. The external data can be edited in Excel, and then saved back into the data source.
Key Features include:
- Connect Microsoft Excel to a variety of data sources.
- Work with live data directly in Excel.
- Modify external data easily.
Devart Excel Add-ins allow you to configure what data to load into the document. They allow you to select objects and columns and set complex data filters.
Devart Excel Add-ins is a very useful utility and can be beneficial for numerous applications, however the main benefit is that it allows you to periodically obtain the data from various data sources and push it to Excel with a single click, without having to repeat the whole import process every time. It lets you refresh the data in your workbook whenever you need to.
Supported databases include Oracle, MySQL, SQL Server, PostgreSQL, SQLite, and DB2.
Supported cloud apps inlcude: Salesforce, Dynamics CRM, Zoho CRM, Sugar, QuickBooks, FreshBooks, MailChimp, Bigcommerce, Magento, and Salesforce Marketing Cloud.
Data refresh is significantly improved:
Refresh now preserves user's data on the same worksheet outside of the table with imported data.
Data sorting in the table with imported data is now preserved if Keep table if exists and Keep table sorting check boxes are selected in Refresh Options.
Table style the table with imported data is now preserved if Keep table if exists check box is selected in Refresh Options.
Excel Add-ins now display the progress of Refresh and Refresh All operations and allow canceling them.
Refresh Options are added:
Confirm 'Refresh' action - determines whether to display the confirmation dialog box when refreshing data on the current worksheet.
Confirm 'Refresh All' action - determines whether to display the confirmation dialog box when refreshing data on all the worksheets.
Keep table if exists - determines whether to re-create an Excel table with imported data or to keep an existing one when refreshing data.
Keep table sorting - Determines whether to keep sorting settings in an Excel table with imported data when refreshing data.
Refresh now preserves references to imported table cells in Excel formulas if there is no user data under the table with imported data.
The behaviour is changed: now Refresh is not allowed if there is a user's table below the table with imported data.
The behaviour is changed: now Refresh preserves the number of empty rows between the table with imported data and user's data below it.
Edit Mode is greatly improved:
Edit Mode now allows using AutoFill using the fill handle.
Edit Mode now allows using formulas, scripts, comments, etc.
Edit Mode now allows editing data on the same worksheet outside of the table with imported data.
Edit Mode now allows copying/pasting data from the same workbook with the table with imported data.
Edit Mode now allows copying/pasting of multiple rows.
Edit Mode now allows and preserves sorting and filtering (AutoFilter) of the table with imported data.
Edit Mode now preserves comments for the cells of the table with imported data.
Edit Mode now allows and preserves hiding and unhiding columns.
For cloud sources, if a field accepts only a value from a fixed list of allowed values, Devart Excel Add-ins support selecting a value from a drop-down list of allowed values both when editing a cell and in table filters.
Optional underlining is now used instead of the popup comments when inserting a new row and moving focus out of it without filling all the required columns.
The Advanced edit mode check box (selected by default) is added to the Edit - General options for reverting back to pre-1.7 Edit Mode.
Options for selecting underlining color for cells of a new row are added.
Excel Add-ins now check if a value is set for relational database columns that are declared as NOT NULL in the database and have no default value when the "Validate required (not null without default value) columns for RDBMS" check box is selected in the Edit - General options.
Excel Add-ins now display the progress of committing changes to the data source.
The table with the imported data now can be moved to any place on the worksheet, and after this can be correctly refreshed or edited in the Edit Mode.
Windows scaling for high-DPI devices is supported.
The RegionId field is added to CustomerAddresses for Magento 2 (Magento).
The Magento connection editor is improved for Ver2 servers (Magento).
The "Use Custom Fields" parameter is added to Zendesk connections to determine whether to read custom fields for Ticket, Request, View, User, Organization objects (Zendesk).
The possibility to connect to Salesforce Sandbox is implemented (Salesforce).
INSERT and UPDATE operations support for AccountUser in Salesforce Marketing Cloud is added (Salesforce Marketing Cloud).
The behaviour is changed: now date values for filters are generated with the time 00:00 by default. This behaviour can be changed with the Options > Import > Filter > "DateTime picker editor default value" option.
Now Excel Add-ins do not try to load more then 65536 records for the Excel 97-2003 file format and more than 16384 records for the Excel 5.0 and Excel 95 file format and display the corresponding warning message.