Hello,
I have extracted table in pdf file. The problem is that it cant extract the second page table, only extracted 1st page table. I have shared images.
Image 1:
Image 2:
Thanks
Minal
Hi @minal.patil
Try repeating the steps you have done on the first page on the second page aswell… Then combine them in your code later
cheers
But in my pdf file there are multiple pages.
Hi @minal.patil
Then split the pdf into multiple pages and use a loop to loop through each page and get the data
cheers
Can you send xaml file(exmaple)
How can i split
some error is occur
what is “Main DT”? I can’t understand.
I already added.
How to get and how to store ?
Hi @minal.patil
You have to create two datatables…one which you will use while extracting the data and another datatable which you will use to merge all the datat you retreived from each page into one datatable using merge datatable action
So main dt is where ypur final all pages data will be present and the other dt will be the datatable where you will extract each page in loop
Cheers
Hi @minal.patil
Those should be datatable variables…create two datatable variables dtmain and dtsub
And one thing the datamain shpuld be in destination field and dtsub in source field. Basically it merges data from source table to the destination table
Cheers
Can you send steps plz?
Here’s how you can extract tables from a PDF file using Excel:
Open your Excel spreadsheet.
Go to the Data tab.
In the Get & Transform section, click on Get Data.
From the list, select From File and then select From PDF.
Select the PDF file you want to extract tables from.
Click Open.
Hope This Works,
Peter
Anil_G
ashokkarale
Gautham_Pattabiraman
goprisko
rashmisingh2695
SorenB
Julian_Muhlbauer