In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Output to Excel Template, 'Delete Data & Append' Output option not available

ckestler
8 - Asteroid

I am currently producing an excel spreadsheet with five sheets, and I would like to format these with color and spacing. I've tried the direction on this page:

 

http://community.alteryx.com/t5/Alteryx-Knowledge-Base/How-do-I-output-to-an-Excel-template-file/ta-...

 

but my version of excel does not seem to have the 'Define Name' option, nor does Alteryx have the 'Delete Data & Append' Output option. Any idea's?

1 REPLY 1
JordanB
Alteryx Alumni (Retired)

Hi @ckestler

 

The delete data and append options comes with .xls as well I believe:

 

undefined

 

In terms of the names range piece you can see specify a range such as Sheet1$A1:L120 when outputting. 

 

I would highly recommend checking out this article  by @AndrewL and this one as well to provide more clarity. 

 

Best,

 

Jordan Barker

Solutions Consultant 

Labels
Top Solution Authors