Microsoft Excel Component Release Notes

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

Change Log

Version 2023.1.14

Bug fixes

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

Version 2023.1.13

Bug fixes

  • DI-4380: Fixed file read issues with Excel files generated by SAP BO.

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)

Feature improvements

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

Feature improvements

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

Feature improvements

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

Feature improvements

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

Version 2.1.1 (Microsoft Excel Component)

Feature improvements

  • 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