When configuring a task in dynamic reporting with a specific Excel-template, make sure you select all the right settings, like File type and Template.
More information about configuring these settings, can be found here: https://support.icontroller.eu/hc/en-us/articles/360011392900-Dynamic-reports-Task-configuration.