Data Scraping from PDF with multiple pages and tables in excel

Texter12 · December 22, 2020, 1:38pm

Hi, I would like to transfer data from a PDF file with several pages and tables on the pages to Excel. Can you help me?

Marcelo_Guimaraes · December 22, 2020, 1:51pm

Hi!

Please check the following tutorial:
https://epsilonai.com/how-to-extract-table-from-pdf-in-uipath

Best Regards

Cristian_Negulescu · February 28, 2021, 8:00pm

Hello,
In this video, I have 17 use-cases for extracting tables from PDF and write data in Excel and I have also samples with multiple pages:

45:50 File 10 PDF with multiple columns that have multiple lines + multiple pages
1:17:10 File 19 PDF with multiple pages and columns with multiple lines

Code:

github.com

cristinegulescu/startUiPathFromSalesforce/blob/master/PDFdecode.txt

        'FILE1
        Dim strtmp As String
        strtmp = strin.Substring(strin.IndexOf("Number"), strin.IndexOf("Subtotal") - strin.IndexOf("Number")).Trim
        strout = strtmp.Replace(" ", "|")

        strtmp = strin.Substring(strin.IndexOf("Subtotal") + 8)
        strpar = strtmp.Substring(0, strtmp.IndexOf(Environment.NewLine)).Trim


        'FILE2
        Dim strtmp As String
        Dim strout As String
        strout = "Col1|Col2|Col3|Col4"
        strtmp = strin.Substring(strin.IndexOf("Vacancies") + 11).Trim
        For Each line As String In strtmp.Split(New String() {Environment.NewLine}, StringSplitOptions.RemoveEmptyEntries)
            If (line.Length > 3) Then
                If (IsNumeric(line(0))) And (line(1) = " ") And (line(2) = " ") Then
                    strout = strout + Environment.NewLine + line.Replace("  ", "").Replace("  ", "|").Trim
                ElseIf (line(0) = "") And (line(1) = " ") And (line(2) = " ") Then
                    strout = strout + line.Replace("  ", "$").Trim()

This file has been truncated. show original

Thanks,
Cristian Negulescu

Topic		Replies	Views
How to extract pdf table data in multiple pages Help studio , question	1	1104	February 28, 2021
Extracting the multiple tables in the single PDF page Activities pdf , activities , question	1	1192	February 28, 2021
How do we scrap a pdf that has a table which extends to the next page? Studio datatable , excel , selector , studio , data_scraping , question	2	1417	February 28, 2021
How to scrap data from a single PDF with multiple rows and multiple tables? Studio activities	3	1300	February 28, 2021
Exctract table from pdf to excel Studio	3	2528	February 28, 2021

Most Active Users - Yesterday
Anil_G
lrtetala
Yoichi
aranadya
A_Learner
pravallikapaluri
Chetan_Wagh
Dingkun_Yang
111561
indiedev91
More details...

Data Scraping from PDF with multiple pages and tables in excel

Related Topics