We recognize how crucial Excel Add-ins are for businesses, enabling them to streamline processes, enhance data analysis, and integrate seamlessly with other essential tools. That’s why we are excited to announce that a new release of our Excel Add-ins is planned for October 8, 2024.
The Devart Excel Add-ins 2.10 release is focused on improving performance, ensuring compatibility with the latest APIs from Salesforce and Shopify, expanding data integration from Shopify, HubSpot and FreshBooks, and adding new safeguards for data integrity, helping businesses streamline operations and improve reporting.
New features and improvements
- Significantly improved the performance of data import to Excel from relational databases and some fast cloud services.
- Added support for Salesforce Web Services API version 59.0.
- Added support for Shopify API version 2024-04.
- Introduced a new parameter—”Warn about tables without columns that uniquely identify rows” now available under Options > Edit > General.
- Introduced a new parameter—the “Show connection string” option (default value: True), now available under Options > Edit > Error Handling.
- Introduced a new parameter—the “Show sensitive info in connection string” option (default value: False), now available under Options > Edit > Error Handling.
- Added a new “Copy Log” button in the Execution window.
- For Shopify, added the GiftCards table.
- For HubSpot, added new read-only tables: Invoices, InvoiceLineItems, LineItemInvoices, Teams, and Users.
- For FreshBooks, added new tables: BillVendor, Bill, BillLine, and BillPayment.
