Pdf to Excel without dataloss

Learn Academy Feedback
#1

Hi

Trying to convert pdf to excel file and image to excel file. share your ideas here.

1.Without data loss
2. Does anybody know the package name?

Thanks
Ganesh.D

1 Like
How to extract pdf to excel
#2

check this

1 Like
#3

Hi,
If you are not using custom activity then you can have workaround as follow,
Read pdf text activity to read pdf as a text,

and then using split function you can split as per the requirement and then using substring function you can write to a datatable which you should create using build datatable activity and then you can write to excel using write range

Let us know if need more information

Regards,
Pavan H

1 Like
#4

Can you send any sample flow for this?

#5

Sure,

#6

Are you going to send?

#7

Hi @ganesh_rajan,

Is your pdf Native or scanned

If the PDF is Native, you can use Uipath PDF to excel extractor or the method provided by pavan.

If the PDF is scanned, and you cannot select the text - Then you have to use read pdf text with ocr and see if the output is proper, mostly for scanned pdf’s the output wont be proper, so cannot be extracted the table using uipath.

Image to Excel file - Uipath cannot read image files

If you want to extract information from scanned pdf and image files and if you want the data to be proper better to use abby flexicapture, but it is not free.

2 Likes
#8

Native pdf format

#9

Hi,

here is the example pdf to excel for your reference.

PDFToExcel.zip (55.6 KB)

Regards,
Pavan H

3 Likes
#10

Ok. Is there any possible way to get a particular table format portion?

#11

Hi,
Yes you can get it by using pdf to excel activities.

Regards,
Pavan H

1 Like
#12

is it…that’s awsm…can you send any sample for that?

#13

Pdf file.pdf (93.7 KB)

In this pdf file data Table want to pull in excel please tell me how to do this