Hi all, After upgrading our server yesterday, I found out that uploading an Excel file in a "File Browse" interface tool, does not allow me to select the " " option on the Server. The option is still shown in the User Interface, but after clicking "Ok", the first tab still gets selected. Has any else seen this issue/hopefully solved it?

"<List of Sheet Names>" Not working on File Browse input

Hi all,

After upgrading our server yesterday, I found out that uploading an Excel file in a "File Browse" interface tool, does not allow me to select the "<List of Sheet Names>" option on the Server.

The option is still shown in the User Interface, but after clicking "Ok", the first tab still gets selected.

Has any else seen this issue/hopefully solved it?

Server

Interface Tools

Accepted answers

All comments

apathetichell

Assuming this previously worked - it sounds like something may have changed in how the term <List of Sheet Names> is being parsed by your workflow or being passed in by Alteryx Server. I'd look into capturing how this is being formatted internally first - you can do this by uploading a new workflow consisting of:

file browse.

action tool

text input tool

output tool.

action tool should be configured to replace field 1 row 1 with the value passed from the file browse tool. It should then write to a .csv (which you'll pick up in your Server output). When run on Server you should be able to see what is being passed in from your Filebrowse tool and compare that to what is expected in your workflow.

RemcoV

Hi @apathetichell,

Thank you for your trouble-shooting idea. The workflow failed in Designer as well, and I managed to already solve that issue with the same logic you proposed.

However, on the server, the option to select <List of Sheet Names> does not seem to work. When selecting the option in the menu that pops up after selecting a file, the option seems to either not register or to default to the first tab.

Therefore not allowing me to have the list of sheet names being imported to my workflow.

Any ideas on this by any chance?

apathetichell

can you share screenshots of your action tools configuration? keep in mind that on server your file will be located at engineworkflow directory and you will need that for any full path replacement to feed into a batch macro to read in multiple sheets.

RemcoV

I think there has been some confusion around what error I am experiencing. Let me try and show the issue again.

I have a workflow that has an interface 'File Browse' tool. This tool asks for a .xlsx file. The rest of the workflow requires the .xlsx file to be read in with its list of sheet names. On Designer, it looks like attachment 1. As it is supposed to, and as I want it to work.

Before the server upgrade to 23.1, this option worked fine on the server. However, after the update the List of Sheets option does not seem to work on the Server. As when I attempt to select the List of Sheets option, the inputfile defaults to the first tab, not allowing me to get the list of sheet names as an input.