Skip to main content
Known Participant
Aug 24, 2021 2:42 PM UTC
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.

7 replies

Inspiring
Oct 21, 2021 8:31 PM UTC

Hi [mention:2e62521d35a34f24a07637f6e351881d:e9ed411860ed4f2ba0265705b8793d05] !

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

Known Participant
Oct 21, 2021 8:33 PM UTC

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

Inspiring
Oct 21, 2021 8:35 PM UTC

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