How to read and open folder files path inside Excel

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

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

what do you mean by

value inside circle

? can you show a screenshot


like this i need to read the files

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

1 Like

Yes but how can i open this files

use start process

image

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?

1 Like

install uipath.pdf.activities from package manager

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

1 Like

I try like this one but it give me an error
image

image

1 Like

use pdf file path in read pdf text
image

still failed

image

1 Like

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), "")
image

1 Like

Hi this works ! Thanks !!

2 Likes

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