Extract table data from multiple pages of a pdf file into excel file

Help
1

Hi,
How do we extract table data which are in multiple pages of pdf file into excel file.
My current solution works well but doesnt fetch any row after specific row say 100th row which is in 2nd page. But same solution works well for different pdf file which has same structure. Unable to get if there’s issue with both pdf files which has been created by some tool or my script. Though as a workaround I can process the pdf file from the row where it stopped fetching and append in same excel file but this will also fail if the row is different (where it actually stopped fetching from pdf file)

In any case what’s the best way to fetch tabular data from multiple pages into single excel file. Is it row by row or column by column data. I searched other thread but it’s not what exactly I want as part of solution.
Any quick solution will help me.
Thanks

2

What you have set in the Max results in the properties panel of Extract data table.

By default the value is 100. You have to change to zero if you want to pull all the data.

  • MaxNumberOfResults - The maximum number of results to be extracted. If the value is 0 all the identified elements are added to the output. The default value is 100.

Regards,
Karthik Byggari

3

Thankyou so much Karthik :slight_smile: it worked and my bad luck that I missed this property… but I am surprised with same setting of 100 in MaxNumberOfResults same script worked for other pdf file and all rows got extracted without any issue :frowning:

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.