We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Preserve formatting

Aakanksha_chandak
8 - Asteroid

How to get data just filled in the table already existing in the input file.

3 REPLIES 3
RaphaelSilva
9 - Comet

Can you explain a bit further your situation? 

peterr_h
8 - Asteroid

If I'm understanding your question, you want the output to be put over an existing table in a spreadsheet?

 

If you set up the connection in the Output tool to the existing document, image 1 shows the options you should select. 

 

Where the image says to select range, you need to set the output file name as follows:

.\Output.xlsx|||Sheet1$A1:B2

 

  • .\                Output folder location
  • Output       File name
  • .xlsx           Extension
  • |||Sheet1    Sheet name
  • $A1:B2      Output range - this will be where the existing table with required formatting exists. This can be any range required, in this case, cells A1:B2.

 

Hope this helps!

acolten1
5 - Atom

cancel that-- I figured it out!!

 

HI there. Where do you type in the range information? there is no option to enter the range. 

Labels
Top Solution Authors