PDF Invoice to Excel

Hi All,

I have PDF invoice. I used multiple logic but unable to extract data into excel. I am able to get the attached desired output in case there is only one line in description. I am getting issue in case I have multiple lines in description. Plz help me with logic or sample workflow.

@robin

Sample Tax Invoice.pdf (51.3 KB)
Desired Output.xlsx (10.0 KB)

@Nimin @lakshman

Hi,

Have you tried using Anchor Base activity?

Hi @kapildarmoda,

copy and paste all the data into a text document, filter row by row and use Regular expressions to get a specific data. This will work.

Thanks,
Madhusudhan Govindaraju

Hy, I am working on same project as per requirement. i will send sample please see and refer.
Note :- Pdf only open into adobe reader.
First time to run and xlsx atomatic create and check it.

Main.xaml (12.8 KB)

INV0002.pdf (120.1 KB)

abc.xlsx (8.1 KB)

1 Like

Hi Parthkumar,@rahatadi

I am doing a project which is also Same scenario but exactly reverse process. i.e reading the data from Excel and preparing an invoice in pdf. Kindly help me using the above example.

Thanks in advance.
Eswar

@aruri_eswar

welcome to the forum,

How to Convert Excel to PDF (with Pictures) - wikiHow this link can help you to create pdf from excel data.

is this you want?

@aruri_eswar

have you got your solution?

BR,
Aditya

@rahatadi , Yes I have got the solution.
Thank you so much.

@aruri_eswar
could you please share your workflow if possible ?

Hey have you gotten the solution ? there is package that i found that extract the whole pdf into excel