Output to Named Range, with filename in field

I have a name range (let's call it 'Range1') within an excel file to which I would like to output the results of my workflow.

I also need to change the filename according to a field.

e.g. Workbook name - abc.xlsx

Named Range - Range1

Filename - abc.xlsx|Range1

The problem I have is that when I output to this filename, it outputs it to a new worksheet with the name Range1, rather than to the named range itself. Is there a way I can get it to recognise it as a named range?

Thanks
David

Workflow

Tips and Tricks

Accepted answers

s_pichaipillai

can you change the output option to "Change Entire Path" and try

All comments

s_pichaipillai

If Possible, can you upload your workflow. i need to see what you have missed on that

DJordan14

I've created a dummy workflow which is in a similar format.

I also sometimes get the message when opening the excel workbook that Excel found unreadable content.

Named Range Output.yxmd

s_pichaipillai

can you change the output option to "Change Entire Path" and try

MikeB

You can output to a new Excel file using an explicit range (something like filename.xlsx|Sheet1$A1:B2), but if the file is new, there won't be any pre-defined named ranges to work with.

The Alteryx tools will operate on named ranges if they exist in an Excel file, but up to this point we have not implemented the creation of named ranges in new or existing files.

If this is an important feature for you, please submit it as a feature request here in the community (in the Ideas section) so it can be considered for a future release.

Thanks

DJordan14

Thanks Mike - although I already had an Excel file with the defined names within them.

s_pichaipillai - your solution worked insofar as it outputs to the named range, but I think I need to include the full file path within the filename as otherwise it just saves to the same directory that the workflow is saved in.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703