Devart Excel Add-in Universal Pack 3.0.0
Released: Jun 12, 2026
Actualizaciones en 3.0.0
Características
- Added support for Excel 2024.
BigCommerce
- Added the new CustomerMetafields object.
- Added the new ProductImageContents object for working with binary content of product images in BigCommerce.
FreshBooks
- Added new objects: Account, AdjustmentJournalEntry, AdjustmentJournalEntryLine, ChartOfAccountsReport, CreditNote, CreditNoteLine, Estimate, EstimateLine, and JournalEntriesByAccountReport.
- Added new report objects: AccountAgingReport, BalanceSheetReport, CashFlowReport, CashFlowSummaryReport, ChartOfAccountsReport, ExpenseDetailsReport, GeneralLedgerReport, GeneralLedgerSummaryReport, InvoicesReport, InvoiceDetailsReport, JournalEntriesByAccountReport, ManualJournalEntryReport, ManualJournalEntrySummaryReport, PaymentsCollectedReport, ProfitAndLossReport, TaxSummaryReport, and TrialBalanceReport.
Freshdesk
- Added support for INSERT, UPDATE, and DELETE DML operations for the TicketFields object.
HubSpot
- Added support for HubSpot reports.
- Added the Sensitive Data connection string parameter for accessing Sensitive Data fields.
- Added new objects: Appointments, Courses, FormSubmissions, FeedbackSubmissions, Leads, Listings, Services, and Subscriptions.
Mailchimp
- Added new objects: CartLines, Carts, Customers, OrderLines, Orders, ProductVariants, Products, PromoCodes, PromoRules, Stores.
Marketo
- Improved support for the Leads object, which now supports native filtering by the CreatedAt field in Bulk Extract mode.
MySQL
- Added support for MariaDB 12.
- Added support for the INET6 data type in MariaDB.
- Added support for the UUID data type in MariaDB.
- Added support for SingleStore (formerly MemSQL).
- Added support for modern SSH encryption and key exchange algorithms.
NetSuite
- Added support for NetSuite API v2.
- Added support for the NetSuite 2024.2 release of API v1.
- Added support for OAuth login by NetSuite Connection Manager.
Oracle
- Added support for the Oracle Database 26ai.
- Added support for the JSON data type in Oracle Database 21c, 23ai, and 26ai.
- Added support for the BOOLEAN data type in Oracle Database 23ai and 26ai.
- Added support for long passwords in Oracle 23ai and 26ai.
- Added support for modern SSH encryption and key exchange algorithms.
PostgreSQL
- Added support for PostgreSQL 17 and 18.
- Added the Use Session Timezone connection string parameter to control whether PostgreSQL date/time values are converted using the current session time zone.
- Added support for modern SSH encryption and key exchange algorithms.
QuickBooks
- Added the TaxExemptionReasonId field to the Customer object.
- Added 50 new QuickBooks report objects.
Salesforce
- Added support for version 64.0 of the Salesforce Web Services API.
- Added support for the Server-to-Server authentication.
- Added the Preserve Names connection string parameter to preserve the original names of custom objects and fields, including the __c suffix.
SQL Server
- Added support for Microsoft SQL Server 2025.
SugarCRM
- Added the RowsAndColumns, Summation, and SummationWithDetails reports.
Zendesk
- Added the SectionId and AuthorId fields to the Article object.
- Added the CategoryId field to the Section object.
Zoho CRM
- Added support for Zoho CRM API v8.
- Changed the behavior: The API Version connection option now has only two supported elements - Preferred (currently API v8, but subject to change) and Deprecated (currently API v2).
- Added the BulkRead option to the connection string. It enables the Bulk Read API of Zoho CRM for querying large data volumes.
- Added support for Canada, Japan, Saudi Arabia, and UK domains in the Connection Editor for Zoho CRM connections.
Zoho Books
- Added the SalesReceipts object.
- Added support for nested objects within the LineItems field of the Bills object.
- Added support for the Saudi Arabia domain in the Connection Editor for Zoho Books connections.
- Improved selection of BankTransactions records for all available statuses.
- Improved filtering records by the Status field.
- Improved support for the CustomFields and CustomFieldHash fields in the SalesOrders, Bills, CreditNotes, and CustomerPayments objects.
Correcciones
- Fixed multiple issues related to API support for cloud data sources.
- Fixed an issue with displaying Unicode characters during installation.
Dynamics 365
- Fixed an issue that caused the 'Could not load file' error when opening a connection.
MySQL
- Fixed an issue with reading large Int64 values.
- Fixed an issue that caused the 'Bad handshake' error when opening a connection.
- Fixed an issue that caused the error: 'SSL connection error: Cannot load client private key.'.
Oracle
- Resolved a memory leak issue occurring when repeatedly establishing connections in the OCI mode.
- Fixed an issue that caused an AccessViolationException when reading CLOB/NCLOB data in the OCI mode.
- Fixed an issue causing the "Offset must be within plus or minus 14 hours" error when reading TIMESTAMP WITH TIMEZONE values.
- Fixed an issue with XMLTYPE handling in Direct mode when Unicode=False.
PostgreSQL
- Fixed an issue that caused the 'SSL connection error: Cannot load client private key.' error.
- Fixed an issue that caused the 'Authentication failed in ssl mode' error when opening a connection.
- Fixed an issue that caused the 'Unsupported frontend protocol' error when connecting to PostgreSQL 8.0.
- Fixed an issue with saving MONEY data type values.
- Fixed an issue with negative MONEY values displayed in accounting format when using protocol 2.
- Fixed an issue with trailing zeros in the fractional part of NUMERIC data type.
- Fixed incorrect handling of TIMESTAMPTZ values when the Use Session Timezone connection string parameter was set to True.
QuickBooks
- Fixed an issue that caused the 'Required param missing' error when performing DELETE operations on the TimeActivity table.
SQLite
- Fixed an issue with using the URI format in the Data Source connection string parameter.