community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

How to format output using format painter

Atom

Hello,

 

We currently have a workflow that produces an Excel file that is unformatted. We have been manually formatting the output each time the workflow is run using Format Painter. Is there a way to incorporate the file which is already formatted into the workflow so that the output is automatically formatted and we no longer need to use Format Painter each time?

Alteryx Certified Partner
Alteryx Certified Partner

I think you need to look at the 'Reporting' tool category. Here there are a suite of tools which allow you to output a formatted Excel document.

 

Ben

Alteryx Certified Partner
Alteryx Certified Partner

Hi @DGPwC 

 

This topic might help you on your task.

 

It basically talks about the options you have when writing to an Excel Template file, which is what you should do (pre-formatting your Excel Workbook).

 

Cheers,

Labels