Alteryx Designer Desktop Discussions

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

Preserving Excel Table Format

Nelso01c
5 - Atom

Is there a way to Preserve a table formatted in Excel. My first attempt to create a table was by using OUTPUT DATA tool under OPTIONS and selecting OVERWRITE SHEET RANGE & checked the box for PRESERVE FORMATTING ON OVERWRITE (RANGE REQUIRED) and the desired outcome wasn't what I was looking for. Then I used the BASIC TABLE tool & the RENDER tool to format the OUTPUT, but still would like to have my data copied to a specific sheet already formatted. See below!

 

COUNTReference pointItem NumberBOM LevelMaterial numberFinal material numberDescriptionComponent quantity
11B11C11D11E11F11G11H11
12↓↓↓↓↓↓↓
13       
14       
3 REPLIES 3
cjaneczko
13 - Pulsar

When you use the Preserve formatting on output you need to specify the range the data is outputting to. If you do this the formatting will remain preserved from what was on the sheet originally, including conditional formatting. 

OTrieger
13 - Pulsar

Hi @Nelso01c 

The above solution is good as long as you do not mind that the target file is been overwritten. There is another way how to do it. First you create the excel template that you would like to use over and over again. Then you call to that template with Blob Input Tool and then Output it with Blob Output Tool, now you can write your data into the newly saved template using the setting that you mentioned. As @cjaneczko  you will need to define the range of the data. In this way you will have a prepared template that can use over and over again.

Nelso01c
5 - Atom

@OTrieger

 

First my apologies for such a late response! You mentioned "... Then you call to that template with Blob Input Tool and then Output it with Blob Output Tool, now you can write your data into the newly saved template using the setting that you mentioned..." I added the tools, but I am unable to achieve the desired output!

Labels
Top Solution Authors