Configuring File Browse and Action tool - Server

Question

Hi,

Can you plese help me?!

I have a workflow which uses File Browse tool, connected to action tool, which is connected to the Input tool.

User will have to select the file from their desktop and click finish so that the workflow runs on the gallery and generates output.

File Browse Configuration:

* Enter the text or question to be displayed: Attach excel file
* Arbitrary File Specification: Excel Files (*.xlsx)|*.xlsx

Action tool Configuration:

* Select an action type: Update Value
* Value or Attribute to update: File - Value = "C:\Users
ame\Downloads\finename.xlsx|||'Sheetname$'"
* Checked: Replace a specific string: C:\Users
ame\Downloads\finename.xlsx|||'Sheetname$'

Input tool Configuration:

* Connect a File or Database: C:\Users
ame\Downloads\finename.xlsx
* File Format: Microsoft Excel (*.xlsx)
* Table or Query: 'Sheetname$'

Error: Input Data (53): No sheet specified, you must specify a sheet

MichelleL · Answer

Hi @Reddy4  - I've found that it's easiest to leave the File Browse tool set to 'Standard Database File Formats' and then leave the Update Tool with the default selection 'Update Input Data Tool'.   With these selected Excel files/sheets work perfectly.

File Browse configuration:

Action Tool configuration:

I hope this helps.  I just stumbled across this while looking for something else today!

amruthas2 · Answer

Hi @Reddy4

Try using csv / or any other format if you have just a single tab of data, this would help in not specifying the sheet which is used in a input format, 
else alternative would be suggesting the team who uses this default input workflow to use same worksheet name as speicifed in the workflow, else need to change the table or query name in the highlighted field

apathetichell · Answer

Server uses excel sheets in the excel file.xlsx|sheet format - This may have already updated so your action tool may not be updating and your input tool may point to a non-existent location.

try changing the action tool mode to update input data tool instead of your current configuration.