Table output to specific location

Question

I have a dataset that I need to export to Excel and optionally PDF. The output location is in a column. 
The data header needs to have a blue background with white bold text. What is the best way to go do this?

I am trying to use the table tool for formatting and the render tool for output. I currently get an error that the output file is not supported format.

Render Configuration.JPG

Table Formatting Workflow Example.JPG

catmar · Answer

Thank you @peterr_h for the suggestion. I thought about this, but ideally I want to keep all versions without having to rename/resave.

Another option might be using a template with the blob tools. For some reason, I believe this is taking the difficult route and Alteryx might support formatting within workflow before exporting to a dynamic Excel path.

peterr_h · Answer

This may not answer your question, but, one solution that I've used in the past is:

1. Create 'blank' Excel spreadsheet in desired location which has the correct formatting but no data.

2. Set output to this file's location.

3. Set output method to 'overwrite'.

4. Select 'preserve formatting' option in output tool.

This will, obviously, overwrite whatever is in the file each time you run the workflow, but the format will be correct.

Sorry if this isn't helpful, but it could be of some use.

catmar · Answer

Hi - Attached I am including a basic example workflow and desired example Excel output. How can I update the workflow to get the desire Excel output with a colored background for the header, white font for the header, and specific font of the body?

Output format example.xlsx

Table Format.yxmd