Gallery - Excel Download

Hi Team,

I want to provide option to an user to download a standard excel template on Alteryx gallery.

I already built an interface app where user can browse an excel file. Before working on filling the excel template, I also want to provide user an option to download an excel template so they can fill and download.

Please advise if this is possible

Thanks

Gallery

Common Use Cases

Interface Tools

Accepted answers

All comments

FinnCharlton

Hi @JDong , you could do this with the Blob Input and Blob Output tools:

The Blob Input tool inputs the Excel template file as an object.
The filter is connected to a check box, allowing the user to choose whether or not to download the template.
The formula allows the user to choose where to save the template.
The blob output tool saves the template in the chosen location.

Hope this helps!

Template Download Idea.yxwz

JDong

Thanks

FinnCharlton

@JDong , can you tell it to ignore the warning and open it anyway? As it is an app, open it from Designer itself.

JDong

@FinnCharlton Works but what I wish to achieve is to directly show a pre existing template as default and provide user option to download. So it could be more like a 1 click option. On download user can populate the template and Browse and run the same within my workflow is that possible to show more like a default?

Instead of the file browse it can just show a default excel as template

Thanks

FinnCharlton

@JDong there is no way to download a file just from the Interface without running a workflow, so the stages would need to be split into separate chained apps:

First app allows the user to download the template. On completion, the second app immediately loads.
Second app allows the user to upload the filled template and does the rest of the work.

JDong

Hi @FinnCharlton

For some reason I am unable to configure and download a template.

In the first blob I configure the network path with my excel, later in the blob I configure the destination path.

When I run as analytical app I cannot seem to download the default template...should the checkbox be selected?

Please advise

JDong

@FinnCharlton Anyway to get this working...I see bytes on the false filter. The true filter is empty

Am I making any mistake?

Thanks

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703