Outputting to Excel template and keeping columns center aligned

Question

Hi all,

I'd like to output data into an Excel file that has already a default template and keep the data that is outputted into the cells center aligned. I have tried several options before hand including saving the Excel file I am outputting to with all columns centered aligned. Still, when the workflow is run and Alteryx prints on the file, the values in the cell by default switch to left cell alignment.

Basically I'd like Alteryx to output data into an Excel file like this:

But I am only able to output data like this:

Any help would be much appreciated.

Thanks!

sparksun · Answer

Yes,I didn't encount the same issue you described.You can see from my screenshot that I have set different cell styles in my excel template.

You should config the right range setting to get it down,I guess you have missed something,pls check.

If you don't see those settings,you have to update your Designer to the latest version.

asuamat · Answer

Hi thank you very much.

However, even if I already set columns to be centre aligned before outputting to the workflow, once it is run the output is left-aligned. Therefore, even if I bring in a template that has cells centre-aligned, the output comes out as left-aligned.

I see that in your case this did not happen to you? I.e. you were able to output and have the outputted data centre aligned?

Thanks a lot for helping me out!

sparksun · Answer

Try the following configurations:

The result in excel template,the format could be anything you want:

Note:The Preserve Formating configuration is only available in recent Designer license.