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?
what do you mean by
value inside circle
? can you show a screenshot
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
Yes but how can i open this files
use start process
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?
install uipath.pdf.activities from package manager
then you can use read pdf text activity to convert pdf to string
I try like this one but it give me an error
use pdf file path in read pdf text
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), "")
Hi this works ! Thanks !!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.