How to read and open folder files path inside Excel

[user123mem]

Hi , i need to read the excel files that have column “PDF Folder Path” and inside this field got folder path and i need to read the files . How can i do it. I need to read value inside circle

[jack.chan]

you mean you have excel like this and you want to go through each folder path and read the files inside 1 by 1?

what do you mean by

value inside circle

? can you show a screenshot

[user123mem]

like this i need to read the files

[jack.chan]

use read range to read your table to dt variable (datatable)

then use for each row activity to loop this table, in the loop, currentRow(“PDF Files Path”).tostring will give you the pdf path of current row

[user123mem]

@jack.chan

then use for each row activity to loop this table, in the loop, currentRow(“PDF Files Path”).tostring will give you the pdf path of current row

Yes but how can i open this files

[jack.chan]

use start process

[user123mem]

I able to open this files in Folder Path. but how can i read this files instead just open. I need to read this PDF files to convert it to Text Files. Is that possible?

[jack.chan]

install uipath.pdf.activities from package manager

then you can use read pdf text activity to convert pdf to string

[user123mem]

@jack.chan

then you can use read pdf text activity to convert pdf to string

I try like this one but it give me an error

[jack.chan]

use pdf file path in read pdf text

[user123mem]

still failed

[jack.chan]

because your path has " "

do this (this will remove “” from file path then it will be ok)
currentRow("PDF Files Path").tostring.Replace(Chr(34), "")

[user123mem]

Hi this works ! Thanks !!