Output to a specific range in Excel

[BradBaker]

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.

[cmcclellan · Accepted solution]

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'

[BradBaker]

Thanks @cmcclellan.  That works.

[rujin]

Hi,

Is there an option in Alteryx that I can fill in value to Excel with conditional values in Excel?

E.g. My Alteryx output:

I want to fill in Net Sales and Response Rate to Excel where "Campaign Name" equals "L113" (highlighted part):

Appreciate any suggestions! Thanks.

[rujin]

Hi,

Is there an option in Alteryx that I can fill in value to Excel with conditional values in Excel?

E.g. My Alteryx output:

I want to fill in Net Sales and Response Rate to Excel where "Campaign Name" equals "L113" (highlighted part):

Appreciate any suggestions! Thanks.

[CatheyH]

Hi Rujin,

Hopefully you have had your answer by now, but just in case, you will need to create a new thread so that a) people can see it and answer it and 2) the correct answer can  be marked as complete so that others can find the right answer quickly if they have the same question.

C