Outputting from gallery to Excel

Hi, I am trying to create an app to upload to our gallery which outputs data into a sheet of an excel file. The file has other sheets which display the data from alteryx in different ways.

I have got this working fine in designer on my pc however when I upload the app to the gallery and run it there the output is an excel file with just the data from alteryx (i.e. the data is being put into a blank excel file rather than the template I have created).

Is it possible to output to an excel template from the gallery?

Thanks,

Richard

Gallery

Output

Accepted answers

All comments

patrick_digan

Hi Richard! Here is my suggestion that worked for me: whatever template file you intend to output to, I would add an input tool to read that exact file to your workflow (it doesn't matter what sheet you read). Then you can add a Tool container, place the input tool in the container, and disable that container. When you upload to the gallery, be sure to have that file checked under the view workflow assets. I've included a sample workflow to show you that I'm outputting to sheet1 and sheet2 has a formula to display your text. This should fix your dilemma.

In case you're curious, here's my take on what is happening. When you just have the output tool and you check the box to package it up with the workflow, it doesn't actually send the excel file with the workflow to the server to store in the Mongo files. Alternatively, if you have an input (even if it's disabled) and package it up with workflow, then it does send the excel file with the workflow to the server to store in the Mongo files. Now that it's sending the file, your template should work just fine.

Let me know if you run into any problems!

Test Write to Template.yxzp

jarrod

you should be able to add the excel template file as an Asset which you can refer to as an output in the app.

Here's a knowledge base article on the matter:

http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Attaching-additional-files-to-a-workflow-package-yxzp-file-in/ta-p/3741

Here's a relevent snippet from that article:

To include additional files, you need to enable Asset Management which can be found under Options ->User Settings-> Edit User Settings -> Advanced, check the box, Display Asset Management in Properties window. Once this is enabled, you will be able to include assets with your workflows.

Return to your workflow canvas and select the Input tool (or any tool that may require an asset or dependency, like Input/Output tools or the Run Command tool). In the Configuration Window, click theAssets icon then Add Files to browse to the additional files to include.

Richard_

Thanks a lot to you both for your responses - I've got it working using the input data and disable method. I'll see if I can get it working the second way as well as it could be a bit tidier

rld2

This solution works fine on desktop; however, I'm still getting the same error on the gallery even if I push your sample app directly to our gallery. Error message is still

Unable to open file for write: \ProgramData\Alteryx\Service\Staging\5656_a61e1821b57b4835b41ea60a923e5b0f\Book1.xlsx Error Opening file: \ProgramData\Alteryx\Service\Staging\5656_a61e1821b57b4835b41ea60a923e5b0f\Book1.xlsx : Access is denied. (5) (Tool Id: 9)

Is there a server setting causing this issue?

mikebruno

Hello Patrick, I have what might be a similar situation, whereby I have an EXCEL output from a workflow that will be run from the Gallery. I have an EXCEL macro that I'd like to have included in that output, along with an EXCEL sheet that advises the user to run the macro (and that sheet is the one that I'd like to open when the EXCEL output is opened by the user if possible). Can I use the Tool Container and an input tool that pulls in the EXCEL file with the macro, and then have my other EXCEL output sheets be contained in the file that has the macro?

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335