How to Read a Table from specific page in pdf

Help
1

Hello,

I want to extract the table from a pdf on 2nd page and write in excel. i have tried using screen scrapping and was able to get the table data in text file and then tried to insert in Excel by spliting …but Could not succeed.Please help me to resolve my issue.
I have attached the pdf for refernce.AbhinavGupta_31YrsMale_LabReport.pdf (1.9 MB)

1 Like
2

@sneha_arbole Can you show us the Table that you Extracted from ScreenScraping or send that Data in a Text File, You may need to use Generate Datatable Activity

3

Text File:
Data.txt (1.2 KB)

5

@Mohsin_Inamdar Data Scrapping does not Support to extract this table.

6

can you please share the output you want in excel sheet for the pdf attached

7

@sneha_arbole The Data Looks a bit Complicated to Extract as Datatable, Even using Generate Datatable Seems not to be a good idea, I think we might need Expert Suggestion to understand if we really can Perform this Operation :sweat_smile:

8

I need the output in the excel format
Untitled.xlsx (10.8 KB)

9

I have tried using Generate Data Table but could not succeed in it…

10

@Palaniyappan Can you please help to resolve this issue

2 Likes
11

@sneha_arbole,

Does all the files are in same format?

I have coded for the given pdf and put the data in excel.

PLease provide you pdf location and Output excel location in the code and tryPDFTOEXCEL.xaml (18.6 KB)

1 Like
12

Hi
Did we try copy and paste method
Like select the table, copy it and paste in excel

@sneha_arbole

13

@MuralidharVankamaddi Thank You Very much…

14

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