Unable to browse excel file path, and select cell value from Excel to Type into activity

[balkishan (Balkishan Singh)]

Hi,

I am using Studio Web, I have added my name, when i browse the file it’s showing no file even the file is there. then i just created a variable and pass the excel file path.

now in the type into activity, i want to pass the first column value which is Name in the excel file. but am getting error.

so confusing this studio web…it is not user friendly…

Even I don’t see the excel columns names.

[yedukondaluaregala (YK)]

@balkishan

Where is your excel file is located, is it in local or in onedrvie.

you cant see the excel column names, just open the expression editor and there write currentrow(“Name”).tostring

[ashokkarale]

@balkishan Use Expression Editor like this.

[balkishan (Balkishan Singh)]

it is in one drive folder

there is a one more folder inside UiPath Folder , but it is not visibile here, even i can not see the excel file which is there in the Folder.

[balkishan (Balkishan Singh)]

if i browse, why the file is not visible.

i tried created a Variable & pass the full file path, but still it was showing the issue in the Variable…

[yedukondaluaregala (YK)]

After giving the connection of OneDrive, files will be visible but you cant see those files you might given wrong drive connection.

check the connection and files where it got located.

[balkishan (Balkishan Singh)]

connection is ok, other folder files i can see. but not this folder.

even i tried to put the files in the C drive folder , but there i am not able to browse the C Drive Folder…

[yedukondaluaregala (YK)]

@balkishan

Take a look, whether that folder is synched properly or not and as well files.

If you placed the files in c drive that is local folder, then you cant get those file in this action, you need to use read range workbook, find below snap

After clicking on use local file , you need to enter full filepath by using expression editor

[ashokkarale]

@balkishan

Check if you have the excel files in the folder. If uploaded recently, try sync the files once again and refresh the studio once.

I just tried and able to see the files.