Multiple page pdf extraction to excel

Hi,

Each page has different table data, first table data starts at page 1 and ends at half of 2nd page and next table data starts at half of 2nd page and ends at page 3, & another table data starts at page 3. Tried using regex but not working.
Multiple pages.xlsx (14.5 KB)
pdf task 3.pdf (252.9 KB)
pdf multiple pages.xaml (20.3 KB)
Sample files and xaml has been attached.
Table values need to be extracted and stored into excel file. Which method i should use.

Regards,
Lakshmi

Hello ,

Did you tried to use the Table extraction in the Modern studio? If the pdf is in table format, it can read the Table data and can output you to Datatable variable.

Hi,

Not able to find table extraction in studio. Is there is any other method to do.

Regards,
Lakshmi

Hi @lakshmi.mp

Can you share the output excel with the required output

Hi @kumar.varun2 ,

Multiple pages.xlsx (14.3 KB)
pdf task 3.pdf (252.9 KB)
Sample file and excel output file, done using regex but not working. Each table need to be stored in new excel sheet. Here i have page1, page2, page3, three tables are there in pdf file.

Regards,
Lakshmi

@lakshmi.mp

What is the required output


Table need to extract and store into excel

@lakshmi.mp

For the third table what is the required output


this is third table that need to be extracted and stored in sheet 3

Hi @lakshmi.mp

This implementation is for first two tables using regex. Please check if it works for you or not.

ExtractTable.xaml (13.6 KB)

1 Like

hi @kumar.varun2 ,

Yes its working for first 2 tables.

Regards,
Lakshmi

@lakshmi.mp

The third table is also added. Please Check

ExtractTable.xaml (30.5 KB)

1 Like

Hi @kumar.varun2 ,

It’s working fine all pages are being extracted. Thanks a lot for the solution.

Thanks & Regards,
Lakshmi


Hi,

In table 3 not able to extract the subtotal and total values. How to do that.

Regards,
Lakshmi

Hi @lakshmi.mp

Please check

ExtractTable.xaml (32.7 KB)

1 Like

Hi @kumar.varun2 ,

Its extracting now, thank you so much.

Thanks & regards,
Lakshmi

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