PDF Invoice to Excel

Help
1

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

2

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

@Nimin @lakshman

3

Hi,

Have you tried using Anchor Base activity?

4

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

5

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
6

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

7

@aruri_eswar

welcome to the forum,

3 Ways to Convert Excel to PDF - wikiHow this link can help you to create pdf from excel data.

is this you want?

9

@aruri_eswar

have you got your solution?

BR,
Aditya

10

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

11

@aruri_eswar
could you please share your workflow if possible ?

12

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