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

Alteryx designer Discussions

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

Output to a specific range in Excel

Meteor

I'm attempting to write to a specific range in Excel, but I think I have my apostrophes/quotes wrong.  My output path is:

 

C:\Users\bakerc12\Desktop\Output Test.xlsx|||'Test1A1:A3'

 

I get the following error message:

 

'Test1A1:A3' is an invalid Sheet/Range specification for Excel'

 

Workflow attached.  Thanks for your help.

Alteryx Partner

You're very close, but you need a $ after the sheet name, so ... 

 

C:\Users\bakerc12\Desktop\Output Test.xlsx|||'Test1$A1:A3'

 

so you could also do:

 

C:\Users\bakerc12\Desktop\Output Test.xlsx|||'Test1$B11:B13'

Meteor

Thanks @cmcclellan.  That works.

Labels