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.
Discussion posts and replies are publicly visible
Hi chanakyav0002 !
Did you figure this out? I am stuck on the similar issue. Please share the solution.
I haven't figured it out. I ended up changing my stored procedure which is used to generate the excel.
Did you make any change in the stored procedure which will impact the file extension??? Kindly share the details.
My Used case was to hide/show columns so my first option was to go for macros since macros are not working I changed my stored procedure to return certain columns based on user inputs.
Got it. So you eventually changed the excel template file extension to XLSX instead of XLSM?
correct
Thank you!