Hi, I want to extract the table from multiple pdf files and write it to excel. The first page of the pdf contains some text and from 2nd page onwards the table, while in some pdfs the table starts from page one itself. The issue is that from all the records present in the table some records are not extracted i.e. from 6000 rows only 4000 rows are extracted rest are omitted. What can be done to get all the present records? Can anyone guide me with this. For different pdfs the column orders can be different and also extra column can also be there. I can’t seem to find standard solution for this.

PDF parsing and Extracting Data

mlauber71 March 9, 2022, 9:40am 4

@shivani_soni you could try and use the R package tabulizer. Maybe you could provide us with an example.

How to install R: KNIME guide and collection.