Question
Export SQL to Excel with Macros (XLSM)
Hi,
I am trying to export SQL to Excel but the base template would be XLSM due to macros which will hide/show columns based on certain rules. The actual file being generated by the plugin is XLSX and due the file file containing macro excel throws file corrupt error. If I manually change the generated file extension to XLSM everything works fine.
Is there a way to change XLSX to XLSM within Appian or contain macros in XLSX template files.
Thanks.
