Inserting calculated table into excel template file from gallery

Question

Hi,
I wanted to create an analytic app which would allow user to output result into the provided (from user's local pc) excel template file and into specific range. I've made it to work on local machine but this app needs to be used by non-alteryx users so it have to be on gallery and when i reference a file path to that file, server obviously looks for it in it's local environment. And I can't figure out how to approach that.
The last resort is a network drive which gallery can access but I want to avoid that.

Thanks in advance

I2ufu5 · Answer

Well, locally it's pretty simple. I just point the template file i want to use as an output but that wont work in gallery. So I'm trying to figure out a way so that template file could be uploaded to app on gallery and then downloaded to local PC with results in it.
Right know i will probably use network drive as a place to store template file and insert results into it.

afv2688 · Answer

Hello @I2ufu5,

Where are you writing the results? Server is normally not able to write to users pc. Are you planning to show the results directly on the gallery? If it's like that maybe I would recommend you also to have a list of templates on the server (that depens also on the access you have)

Regards

echuong1 · Answer

The Gallery/Server would not be able to access a local copy of the template, unless the template is also uploaded with runtime via file browse.

Another option is to create a copy of the template with the blob tools. See example here:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Write-multiple-excel-files-using-a-template/td-p/443950

You'd need to use a shared drive if you want the template to pull from a live location.