Pdf data extract into excel

when i want to hole pdf data into excel but i can not find this option pdf to excel when i go to package manager and download pdf to excel but it can not install please help me

Hello @Rakesh123,
You should get text from pdf using Read PDF Text or Read PDF With OCR activity (part of UiPath.PDF.Activities). Then (depends of what you want to achieve) make some Regex/Substring operations and write it to the excel using Write cell / Write Range activity.

Please also go through https://www.uipath.com/rpa/academy. The Level 1 - Foundation training is pretty useful for basic operations :wink:

1 Like

no i want to pdf to excel

Which package are you trying to install and what error do you have? Need more details to help you out.

balareva pdf activity

This is not official package for Studio. It might be that it needs to have more dependencies than standard project. In error description there should be information about what kind of problem with installation is this etc. You need to give us more details so we could help you.

However BalaReva.PDF.Activities have no activity for extracting PDF to Excel.

please tell me how to convert pdf to excel

or give me some example

I gave you an information in second post in this topic how to export data from pdf to excel. Please join our academy portal as there is a lot information in Level 1 - Foundation Training about how to handle with simple task (including pdf operations also).

i have already done this course but i want to hole pdf data in to excel.there was seen that a particular data to excel

You should be familiar how to proceed with data, work with variables etc. Cause if you passed Level 1 training you should already know such things. Here’s the example how to pass data from pdf to excel:
pdfTOxls.zip (37.7 KB)
Anyway please be advised that we are here to help with the problems and if you are asking for help you need to describe your problem as possible as you can. Write the steps you have done or what you have tried to do. This will prevent from unnecessary posts with questions about what you could write at the very beginning.

1 Like

BLAST HOLE DRILL MANUAL SAMPLE PAGE.pdf (2.8 MB)

THIS IS MY PDF FILE NOW I WANT TO DATA AS A EXCEL FORMAT FOREACH LINE AS A ROW AND DIFFERENT COLUMN