Get Files Methods in UiPath

Help
, ,
22

@Palaniyappan - Hello. Would you have time to answer this issue I am encountering? “‘Directory’ is ambiguous, imported from the namespaces or types ‘Microsoft.Graph, System.IO’.”

1 Like
23

Yes buddy
Directory is from System.IO

@redbee

1 Like
24

How to remove this error message? Apologies, I’m a bit of a rookie in UiPath. Please help.

image

1 Like
25

Kindly mention as System.IO.Directory.GetFiles instead of Directory.GetFiles

Cheers @redbee

1 Like
26

Ohh, didn’t think it was just that easy. Thanks mate.

1 Like
27

Cheers @redbee

28

Hello, sorry I’m still having an issue getting the file in the network drive.

This is the Sharepoint network drive >> Test_Current (\sharepoint\rpa) (Z:)

I am trying to get the Excel files inside it but to no avail.

With this code, UiPath says Assign: Could not find a part of the path ‘Z:\Test_Current’.

System.IO.Directory.GetFiles(“Z:\Test_Current”,“Customer_“+CurrentDateMinusOne+”.xlsx”)

What could I be missing here?

After passing the Get Files, Excel file won’t open. Please help. I’m getting hopeless outta here.

image

1 Like
29

Hi
Is that shared drive folder path is correct
Kindly check them once

@redbee

30

Ohh sorry. I just figured out that the getfiles was not the issue but the Excel Scope.

The file from Directory.GetFile(GetSheetWorkingFile) is not opening in Excel Application Scope.

In the ouput message, bot is opening the excel file from different path. Not the Z path.

Please help. Huhuhu

image

31

May I know what was the error you were getting
In Excel application scope
@redbee

1 Like
32

Here it is:

Excel Application Scope: Failed opening the Excel file C:\Users\rpa\System.String. Possible reasons: the file is corrupt, the file is already used by another process or you don’t have permissions to open the file.

Excel application scope should get the file from GetSheet1WorkingFile is it?

33

Fine
Before excel application scope use a KILL PROCESS ACTIVITY and mention as “EXCEL” in ProcessName property
And the use excel application scope
Cheers @redbee

34

Which one here?

image
image611×641 22 KB

35

@redbee
Please share the correct workflow to detect the error this workflow is not contain anything.

Use process name as string “EXCEL” in kill process.

This will work!!!

This error raises due to wrong input path of excel file.
Please check once the path using debugging then correct it will work perfectly.

Cheers @redbee

2 Likes
36

If anything still not resolved please feel free to discuss with me.

Thanks & Regards,
Paras :grinning:

37

You were almost done
Mention as “EXCEL” between double quotes in the same ProcessName property

@redbee

1 Like
38

System.IO.Directory.GetFiles(“Z:\Test_Current”,“ Customer_“+CurrentDateMinusOne+” .xlsx

This returns an array.
You should assign to a string variable as
Excelfilepath= System.IO.Directory.GetFiles(“Z:\Test_Current”,“ Customer_“+CurrentDateMinusOne+” .xlsx)(0)
And pass this excelfilepath variable to your excel scope

2 Likes
39

Yah that could be the he reason either
Kindly mention with index position and try once
I didn’t see the expression @Sourav_Anand based on the error I was suggesting that buddy

@redbee

2 Likes
40

Sorry what does the (0) do on System.IO.Directory.GetFiles(“Z:\Test_Current”,“ Customer_“+CurrentDateMinusOne+” .xlsx)(0)?

41

Thank you so much for your inputs. Apologies as I am just starting learning UiPath :slight_smile: Cheers mate

1 Like