RequirementsMicrosoft Windows (All Versions)
Date addedMar 21, 2018
Devart Excel Add-ins permit you to utilize cloud and database information in Microsoft Excel in precisely the exact same way that you utilize normal Excel spreadsheets.
Using Devart Excel Add-ins you'll be able to obtain exactly the information you desire using visual Query Builder or with SQL, then refresh the queried external information in a workbook using one click. The external information could be edited in Excel, then stored back to the data source.
- Connect Microsoft Excel into Many Different data sources.
- Change external information readily.
Devart Excel Add-ins permit you to configure what information to load in the document. They permit you to choose columns and objects and place complex data filters.
Devart Excel Add-ins is a really handy utility and can be good for numerous applications, however the principal advantage is that it permits you to periodically acquire the information from several data sources and drive it into Excel with one click, without needing to replicate the entire import process each moment. It permits you to refresh the information in your workbook when you want to.
Supported databases include Oracle, MySQL, SQL Server, PostgreSQL, SQLite, and DB2.
Supported cloud programs inlcude: Salesforce, Dynamics CRM, Zoho CRM, Sugar, QuickBooks, FreshBooks, MailChimp, Bigcommerce, Magento, and Salesforce Advertising 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.