Microsoft Excel Component Release Notes

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

Feature Highlights

Version 2.2.0

This version contains some improvements which can be found on the full changelog.

Version 2.1.1

This version contains some issues which can be found on the full changelog.

Version 2.1.0

Apache POI

When reversing the Excel File generated with Apache POI an error occured.

This has been fixed.

Version 2.0.2

This version contains some issues which can be found on the full changelog.

Version 2.0.1

Delete statement was not working

Excel driver was not supporting delete statements, causing issues with the 'Delete All Target Table' generic Template parameter which was therefore not working.

Change Log

Version 2023.1.12

Bug Fixes

  • 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 2023.1.6

Bug Fixes

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

Version 2023.1.0 (Component Pack)

New Feature

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

Version 5.3.9 (Component Pack)

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 (Component Pack)

New 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 (Component Pack)

New 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 (Microsoft Excel Component)

New Features

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

Version 2.1.1 (Microsoft Excel Component)

New 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 (Microsoft Excel Component)

Bug Fixes

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

Version 2.0.2 (Microsoft Excel Component)

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 (Microsoft Excel Component)

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