How can i get the excel path with directory get files

Help Activities
,
1

how can i get the excel path with directory get files, i need to path as a string value but when i use message box i see system string

image
image921×349 17.6 KB

image

2

@Soudios

it will give you output as array of files

you can use as

ExcelExist.first

or

ExcelExist(Index)

ExcelExist(0)

3

Hi @Soudios,

Try something like this, since it returns a string array you need to use array index to get its value.

ExcelExist[0].ToString
4

Hi @Soudios

Try this

System.IO.Path.GetFullPath(currentItem)

image
image1289×603 34 KB

5

i need to assign it as a variable

image
image1001×303 31.5 KB

6

@Soudios

Use within for each activity

7

@Soudios

Path=Directory.GetFiles("C:\Users\lrtetala\Documents\UiPath\BlankProcess12\New folder")
For Each
       ExcelExist=System.IO.Path.GetFullPath(currentItem)
       MsgBox:ExcelExist

image
image1256×724 40.1 KB

8

Directory.GetFiles doesn’t return a string with just one file path in it. It returns an array of strings, in other words a list of multiple string values - because it can return multiple files from the folder. Even if there is only one file, it still returns an array. That array will just have only one element in it.

So you need to work with it as an array, not a string. And you don’t need to assign it to a variable. You can just directly use the expression where you need it. If you know there will always only be one file, then this gets you the path and filename of the one file in the folder:

System.IO.Directory.GetFiles(folderpath)(0)

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.