I have 500+ Pdf file .All those pdf file convert into excel.
I attached pdf file screen shorts
Please help me : Give me any code/ project
There are multiple ways to achieve it.
-
Create one DataTable with all the required fields using Build DataTable activity.
-
And then read one by one pdf file using Read PDF text activity to read the data from PDF file and it will give you output as String. And then use String manipulation functions or Regular expressions to fetch required details from it. Use Add DataRow activity and pass values to add into the DataTable.
-
At the end use Write Range activity to write data back to the excel file.
Other way:
You can use Document Understanding framework for this.
And also we have many tutorial videos in UiPath academy and YouTube for the same. Please go through and start implement it. If you stuck at any point or any doubts then please post your queries in this forum and we all are ready to help you.