Devart Excel Add-in Lançamentos

DevartFerramentas de Acesso a Dados
Versão 3.1.49 (13 de ago. de 2026)

Veja o que há de novo em cada versão, com detalhes sobre recursos, melhorias e problemas solucionados.

jan.
fev.
mar.
abr.
mai.
jun.
jul.
ago.
set.
out.
nov.
dez.
Devart Excel Add-in 3.1.4913 de ago. de 2026
Recursos

Dynamics 365

  • Improved the display of error messages for invalid or unsupported data types when reading data from Dynamics 365.

FreshBooks

  • Added the TeamMember, TeamMemberRate, and ProjectTeamMemberRate objects to the FreshBooks connector.

HubSpot

  • Added support for OAuth v3 API endpoints.
  • Added support for custom unique identifier properties that can be used as unique IDs.
  • Added support for labeled associations. The connector represents labeled associations as objects with the _labels suffix.

MySQL

  • Added support for PuTTY SSH PPK3 keys.

Netsuite

  • Added support for the TransactionAccountingLines object in NetSuite API v2.

Oracle

  • Added support for PuTTY SSH PPK3 keys.

PostgreSQL

  • Added support for the SCRAM-SHA-256-PLUS authentication mechanism.
  • Added support for PuTTY SSH PPK3 keys.

QuickBooks Online

  • Added the PrefVendorRefId and PrefVendorRefName fields to the Item object.

Zoho CRM

  • Added support for the IMAGEUPLOAD, LAYOUT, LINETAX, MODULE, MULTIUSERLOOKUP, ROLLUP_SUMMARY, and TERRITORIES native types in Zoho CRM API v2.
  • Added support for China domain in the Connection Editor for Zoho CRM connections.
Correções
  • Fixed an issue that caused the Help button to be disabled.

BigCommerce

  • Corrected the maximum length metadata for the CartId field in the CartCustomItems, CartGiftCertificateItems, CartLineItems, and CartMetafields objects.

Dynamics 365

  • Fixed an issue with OAuth login for accounts requiring administrator confirmation.
  • Fixed an issue that occurred when retrieving data from the Account table.
  • Fixed an issue that caused the "Unable to cast object of type 'System.Guid' to type 'System.IConvertible'" error.

FreshBooks

  • Fixed an issue with inserting or updating datetime fields in the TeamMembers table.
  • Fixed an issue that caused the "Duplicate entry" error when performing CRUD operations on the ProjectTeamMemberRate table.

HubSpot

  • Fixed an issue with the AssociationLabels table.
  • Fixed an issue that caused the "Rate limit exceeded for client" error.
  • Fixed an issue that caused the "Cannot access child value on Newtonsoft.Json.Linq.JValue" error.

Marketo

  • Fixed an issue that caused the "The remote server returned an error: (404) Not Found" error when retrieving data from the Files table.
  • Fixed an issue that caused the "An item with the same key has already been added" error when working with the Emails table.

QuickBooks Online

  • Fixed an issue that caused the "An application error has occurred while processing your request" error.
  • Fixed an issue that caused the "Input string was not in a correct format" error when reading numeric data types.

Salesforce

  • Fixed an issue with loading data into the ContentVersion table.

Zendesk

  • Fixed an issue that caused the "Unable to cast object" error when executing a SELECT query with an OR condition in the WHERE clause.
Devart Excel Add-in 3.0.0Versão principal12 de jun. de 2026
Recursos
  • 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.
Correções
  • 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.