Excel interaction

OpenRPA
1

I have a function to Read Excel like that

image
image1220×666 47.3 KB

How can I get the name of this excel file ?

Thanks

2

ReadExcel only works if you give it the full path to a file that exists. I cannot see if you gave it a filename?
So, if we assume you have given a full path to a file that exists, and you need to find the filename only, you can use System.IO.Path.GetFileName.

You can call that as an expression in any input field or call it from the Invoke code activity.

3

“%USERPROFILE%\Downloads\Temp_DauVao_FW_1.xlsx”
this is the link I put into ReadExcel. How can I get this path “Temp_DauVao_FW_1.xlsx” . If I use invoke code, can you help me with this . Thank

4

you can use System.IO.Path.GetFileName.

how can I integrate this into openRPA app ?

5

image
image685×204 12.3 KB

fileName = System.IO.Path.GetFileName(fullPath) #code in invoke code
with this code, what is agrument I have to input in here

6

Setup RPA error - OpenRPA - OpenIAP

I already fixed this problem. But I still have this. Can you help me