Microsoft Excel component release notes

This page lists the main features added to the Microsoft Excel component.

Changelog

Version 2024.2.0

Bug fixes

  • DI-6250: Fixed an issue which prevented UNC paths from working in JDBC URLs.

  • DI-9463: Fixed an issue which prevented Excel metadata from loading in NORMALIZE and FLAT modes.

  • DI-9485: Fixed an issue which caused duplicate columns, and which reversed row_count and row_number.

Version 2024.1.0

Bug fixes

  • DI-7762: Fix integration of Excel files that lack optional Microsoft metadata.

Version 2023.1.6

Bug fixes

  • DI-7762: Integrating an Excel file modified in OnlyOffice fails with an error.

Version 2023.1.0

Features

  • DI-5652: Log4j version 1 has been removed from the dependencies.

Version 5.3.9

Bug fixes

  • DI-6369: The Delete All Target Table and the Truncate Target Table parameters of the integration template as well as the truncate/insert mode using the definedName parameter fail to overwrite the contents of the target Microsoft Excel file.

Version 5.3.8

Features

  • DI-6262: The technology definition has been updated to mention that indexes are not supported. Thus, the generic templates do not try to create indexes on this database.

Version 3.0.0

Features

  • DI-2123: Improve the Excel wizard with new steps helping to properly define the Metadata

  • DI-3411: Excel driver - ability to choose the path type the driver should use (folder / file)

  • DI-3754: Ability to get the row number and row count when reading an Excel File

  • DI-4157: Excel - Add the possibility to reverse and write in defined tables

  • DI-4508: Update Components and Designer to take into account dedicated license permissions

  • DI-4727: Rebranding: Templates and sample projects

  • DI-4813: Rebranding: Drivers classes and URLs

  • DI-4962: Improved component dependencies and requirements management

Bug fixes

  • DI-754: JDBC URL parameter "forceDatatypeAsString" should not be mandatory

Version 2.2.0

Features

  • DI-3996: Internal change on how some libraries are built to ease maintenance

Version 2.1.1

Features

  • DI-3951: Third-party component libraries - update some third-party libraries

Bug fixes

  • DI-3952: Excel Driver - A "nullPointerException" error was thrown when mapping a field with the expression "NULL"

Version 2.1.0

Bug fixes

  • DI-2452: Excel Driver - files created with Apache POI could not be reversed

Version 2.0.2

Bug fixes

  • DI-2881: Excel driver - Temporary files created in operating system temporary folder (such as AppData\Local\Temp under Windows) were not properly deleted

  • DI-3264: Updating an Excel file with a PivotTable was not working (Excel shutdown while data refresh)

Version 2.0.1

Bug fixes

  • DI-1952: Excel driver was not supporting delete statements, causing issues with the 'Delete All Target Table' Template parameter which was therefore not working