How to convert pdf to excel

Megha_D_Gowda · December 17, 2020, 4:39pm

Hi All,

Is there any activity to convert pdf to excel.
I ave rows and columns in pdf.

prasath17 · December 17, 2020, 4:40pm

@Megha_D_Gowda - Please share the screenshot of the pdf?

Megha_D_Gowda · December 17, 2020, 4:41pm

prasath17 · December 17, 2020, 4:55pm

@Megha_D_Gowda - Thanks for sharing. if its a single page and you are allowed to use CV activities(CV extract table inside cv extraction scope) then you can try that?

Megha_D_Gowda · December 17, 2020, 4:56pm

Its not the single page, I have around 100 pages

NIVED_NAMBIAR · December 17, 2020, 4:57pm

Hi @Megha_D_Gowda

Try this activity to convert pdf to excel

Megha_D_Gowda · December 17, 2020, 5:01pm

I m not getting this package in manage packages

NIVED_NAMBIAR · December 17, 2020, 5:17pm

Hi @Megha_D_Gowda
check this
You can find this under the Question section of above custom activity link

This is the way u can download the above custom activity

sunilch · December 17, 2020, 5:24pm

Hi @Megha_D_Gowda

please add the source in settings and then download the package.

Cristian_Negulescu · March 1, 2021, 7:55am

Hello Megha,
In this video, I have 17 use-cases for extracting tables from PDF and write data in Excel:

2:00 GitHub free code for all the files
2:20 Logic of general workflow
4:40 File 1 simple PDF
9:50 File 2 PDF with a column with multiple lines
20:10 File 3 PDF with a column with multiple words ON the LAST column
27:00 File 5 PDF with a column with multiple words ON inside column (2 columns)
31:40 File 6 PDF with a column with multiple lines
39:10 File 8 simple PDF
42:15 File 9 PDF with multiple spaces on that need to be correct
45:50 File 10 PDF with multiple columns that have multiple lines + multiple pages
55:50 File 11 simple PDF with protection empty Cells
58:35 File 12 Big PDF with an empty line and Empty columns and partial total
1:02:25 File 13 PDF with multiple columns that have multiple words and hard to define a rule
1:10:15 File 15 PDF with multiple columns that have multiple lines
1:12:50 File 17 simple PDF remove spaces from headers also remove space from Data
1:16:05 File 18 simple PDF
1:17:10 File 19 PDF with multiple pages and columns with multiple lines
1:22:10 File 20 PDF with multiple columns that have multiple lines
1:25:00 File 21 PDF with empty columns and subtotal

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

Rimsha_Mahmood · May 24, 2022, 8:28pm

i have installed pdf focus package but unable to see its activites
please help its urgent

Topic		Replies	Views
PDF_To_Excel Automation Starter	5	1289	September 28, 2022
Extracting data table Help excel , activities , question	2	911	March 1, 2021
Extract datatable from pdf and write in excel Activities excel , pdf	2	828	March 1, 2021
Extracting the multiple tables in the single PDF page Activities pdf , activities , question	1	1195	February 28, 2021
Need help to extract the pdf table data into the excel Activities pdf	2	993	November 10, 2021

Most Active Users - Yesterday
Anil_G
Anjani_Kapoor
ijanszen1
OGunnarsson
satish_nangedda
lakshmi.mp
Shruthika_r
sudster
Siraj_Balkhis_Reshma_YICC
devasaiprasad_K
More details...

How to convert pdf to excel

Related Topics