Microsoft Excel Component Release Notes

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

Change Log

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