File Browse Output to Excel in Alteryx App

I need my alteryx app to output files to a .xlsx format. Using the file browse interface tool, the standard database formats do not include .xlsx (.csv may be a worst case solution), and when i specify an arbitrary format and put .xlsx, i get an error because there is no prompt to select a worksheet for the output to write to.

Any ideas on a workaround for this?

Output

Macros

Interface Tools

App Builder

Accepted answers

apathetichell

Excel is not a database format -> you need to unclick that and save it as an arbitrary file type (ie *.xlsx)--- report formats probably works as well.

All comments

apathetichell

this is weird. can you share screenshots of this --- can configurations of your input data tool and your action tool.

you should see an option for file ---> and should be able to map that to an excel file.

apatel1501

The last picture is of the formats available for output when running the app if "Standard Database Outputs" is selected.

App Output.png

apathetichell

Excel is not a database format -> you need to unclick that and save it as an arbitrary file type (ie *.xlsx)--- report formats probably works as well.

apatel1501

I tried the arbitrary file type and did .xlsx. when the app runs and it tries to save the output, it errors out because there is no way to name the worksheet. Report format does work though. Or if I change the action on the arbitrary selection to Update Value and replace the filepath string, that works also.

Thanks!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703