Exctract table from pdf to excel

Aleksey_M · November 4, 2020, 5:16pm

Hi!
I have pdf file. In this file one table on 600 pages.
How I can extract table in to excel? Text not image, not scan.
Data Scraping not work. It no see a table.
Why such a powerful platform as UiPath does not have basic tools for working with pdf tables?

Srini84 · November 4, 2020, 7:29pm

@Aleksey_M

This is some thing not a basic tool I believe

But UiPath has Document Understanding activity, where you can train your PDF to extract the content

OR

You need to go for some ML based OCR’s like Abbyy Flexicapture OR Form Recoginzer etc.,

Again these are paid licenses

Hope this helps you

Thanks

NIVED_NAMBIAR · November 4, 2020, 8:45pm

Check this link for document understanding

Hope it helps you

Regards

Nived N

Happy Automation

Cristian_Negulescu · February 28, 2021, 7:41pm

Hello Aleksey,
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
Scrape Table Data From multiple pdf page and save into Excel File Help studio	5	1949	January 29, 2021
How to get the mulitple tables from PDF in excel in document understanding Document Understanding question	5	1333	October 20, 2021
How to extract a table from pdf to excel Studio excel , activities	18	5949	July 19, 2023
Extract PDF with more than hundred pages to Excel Studio excel , pdf , pdf-extraction	6	834	May 24, 2022
Data Scraping from PDF with multiple pages and tables in excel Activities pdf , activities , question	2	2277	February 28, 2021

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

Exctract table from pdf to excel

Related Topics