User pick Excel file

Help
1

I have a process that will be using an Excel File to run , and I want to have an activity at the very first to ask the user to pick which excel file should be executed. and this path will passed to the Excel App Scope as a String variable

Please help if there is a ready to use activity or a workaround

Thank you,

1 Like
2

yah thats possible
use INPUT DIALOG activity and ask the user for excel file name with file extension .xlsx
–we get the output from the input dialog box as a string variable
named out_filename

–if we have the excel file in our project folder itself then we can directly mention that file name in the excel application scope between double quotes
OR
–if we have in different folder then we need to mention the folder path and concatenate the input we obtained from user like this
youfolderpath+“\”+out_filename

For more detail on input dialog activity

hope this would help you
Kindly try this and let know for any queries or clarification
Cheers @talssagh09

3

It doesn’t work. The error message is "Value of type ‘String’ can not be converted to “UiPath.Excel.Workbook.Application”. Could you show the details if it works for you?

4

image
image1048×267 12.2 KB

5

Please put message box actitvity after Input Dialog and send us the screenshot of what is displaying in message box

6

There is a select file activity for this. The output variable you can pass to your excel application scope

7

If we select the file then it works for a single file only, in my case the objective is to take an input from user for instance the file path and launch the particular file.