File Browse Output to Excel in Alteryx App

[apatel1501]

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?

[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.

[apathetichell · Accepted solution]

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!