Read PDF Tabel form and extract data to excel file

Build Studio
,
#1

Hello Guys,

i need some help to extract data in excel format from PDF tabular form.
i already create the work flow but data in excel file is not valid, it just only fill one cell ony.
i’m using PDF activities UIPath as a package manager.

Here is my workflow Read PDf Tabel.xaml (6.7 KB)

and this is my PDF source File InvoicePdf.pdf (203.4 KB)

Thanks guys, any kind help would be appreciate. :smiley:

#2

I’ve attached the fix. The column separator was set to tab, rather than space, and you want CSV parsing enabled (even though this technically isn’t comma-delimited).

I also had to change the name of column “Invoice Id” to “InvoiceId” because otherwise the space between the words would be counted as a column separator.

Read PDf Tabel.xaml (7,2 Ko)

#3

Hi @Anthony_Humphries, Thanks for your advice and the workflow to…
So, is it the other way to use column “Invoice Id” and avoid that “space” between that words as a column separator ?

#4

Check this updated workflow and I used regex, @asuprayitno
Read PDf Tabel.xaml (11.8 KB)
and the output file,
Output.xlsx (7.6 KB)

1 Like
#5

yeay… thank you so much @Manish540…

you really save my day… :smiley:

#6

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