Skip to main content
Known Participant
August 24, 2021
Question

Export SQL to Excel with Macros (XLSM)

  • August 24, 2021
  • 7 replies
  • 0 views

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.

7 replies

October 21, 2021

Hi [mention:2e62521d35a34f24a07637f6e351881d:e9ed411860ed4f2ba0265705b8793d05] !

Did you figure this out? I am stuck on the similar issue. Please share the solution.

Known Participant
October 21, 2021

I haven't figured it out. I ended up changing my stored procedure which is used to generate the excel.

October 21, 2021

Did you make any change in the stored procedure which will impact the file extension??? Kindly share the details.