Preserve Conditional Formatting in excel output on Gallery

Question

I'm encountering an issue with preserving Excel formatting when publishing a workflow to the Gallery.

Locally, everything works as expected — the output Excel file retains formatting such as:

* Bold first row
* Conditional formatting that highlights specific rows

This works when I have “Preserve Formatting” selected in the output settings.

However, when I publish the workflow to the Gallery:

* The output file does not retain the formatting.
* The file is written to EngineTempPath.
* I'm dynamically updating the file name using a field that appends the date.
* I'm using a template Excel file that already contains the desired formatting.

*

Is there a way to ensure that the formatting is preserved in the published version as well? Any guidance or workaround would be appreciated.

dreldrel · Answer

For the workflow in the gallery, it may be best to stick with one final location. EngineTempPath will generate a temp folder while it's processing, which might be the reason your formatting is not preserved on the gallery side

jrlindem · Answer

How are you handling the template?  Are you using BLOB to bring that into the workflow or are you handling the template outside the workflow and populating it after the fact?

If you're not using BLOB, I would recommend it.  Article here:  The Blob: Reporting That Isn’t From a Horror Film - Alteryx Community

But otherwise, some more context would be useful to help troubleshoot your immediate issue.  I'm really wondering if your template handing isn't being impacted by something where the server's ability to see, and handle the template is being impeded by the differing environment.

-Jay