Microsoft Excel Component Release Notes

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

Change Log

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.

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.

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.

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

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

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)

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