Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Have a gallery app which does not prompt for an excel sheet name

Bob_Blackey
11 - Bolide

Hi All,

 

I have an app that reads in two Excel xlsm files does some Alteryx magic and overwrites a sheet (Drop) in another.

 

The files are of a standard format so the two input files will have a sheet named "Data", and the output file I'm writing to has a sheet "ComboData".

 

My app prompts the user for the file name and I used:

 

 File Browse Tool :Arbitrary FIle Spec *.xlsm 

 

Action tool: Update Value  - for the  File value.

                   In replace a specific string I replace the entire file name (leaving the |'Data' )

 

This works fine when I run it locally - no prompt for a sheet name on input or output, but when published to the gallery it prompts for table/sheet name.

 

Is there a way to have it not prompt for a sheet name in the gallery?

 

Cheers,

Bob

12 REPLIES 12
delf
5 - Atom

Hello, any update regarding this issue?

Jo-B
8 - Asteroid

This is still an issue on the version 2021.2. 

 

I would appreciate here a fix of this! Thx.

npariso
10 - Fireball

Is this fixed yet? Seems like I am still having this issue.

Labels