PDF to Excel in uipath

pdf to excel

PDF to Excel in uipath

Step 1 − First, open UiPath studio and start a new blank project.

Step 2 − Now, put the pdf file from which you want to read the data in the folder of your current project. We are reading the data from following Excel file. “test.pdf” for example.

Take a activity Read PDF Text  and select the excel file.

excel to pdf
excel to pdf

 

 

 

 

 

 

 

 

 

 

 

Step 3 −  done the below activity for reading the pdf file and writing in excel.

  • Take a activity Read PDF Text  and select the excel file.
  • Take a Log message.
  • Take a data table for collecting the information from PDF.
  • take write range activity for writing the all data from data table to excel.

data table filterpdf to excel

 

 

 

 

 

 

 

 

 

 

Step 4 –  if you want  to filter data from data table . you can filter it by using in data table as below.

data table filter
data table filter

 

 

 

 

 

 

 

 

 

 

 

Step 5 – After doing above process , Run the project.  It will write the excel file as below in pic.

pdftoexceloutput

Conclusion : That was a simple example of pdf to excel automation in which we read the data from pdf and put in excel as per our choice.

Reference you can read my post :

 

rpa solution design document sample

Know more about UiPath

SHARE THIS

2 thoughts on “PDF to Excel in uipath

  1. Thanks for spreading this data on this wonderful site. i am going to share this post in my fb take into account friends and neighbors

  2. Hurrah! Finally I got a website from where I be able to genuinely get helpful data regarding my study and knowledge.|

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.