PDF to Excel Formatting

[sparkplug93]

Good Morning,

I have a pdf with two sections:

1. A header that i need to pull the date from
2. a table that I need headers and all information below it.

How can I put this into excel without a messy format or it all going into one cell?

[Palaniyappan (Palaniyappan P)]

HI
did we try with READ PDF or READ PDF with OCR activity
and pass that string variable obtained as input to excel
@sparkplug93

[pattyricarte (Patty Boy)]

Hi @sparkplug93

You can explore this helpful component if you want to address your issue.

https://go.uipath.com/component/pdf-to-excel

cheers

Happy learning

[sparkplug93]

Yes I did but it put all the content in cell A1 rather than breaking it into several

[Palaniyappan (Palaniyappan P)]

may i know how the output is coming on reading pdf
is it coming with any delimiters between data and if so we can pass them to GENERATE DATATABLE activity and get the output with a variable of type datatable and then write that to excel
Cheers @sparkplug93

[sparkplug93]

Hello,
It is coming with no delimiters but every value is on it’s own line as in:

Sheet #
Date
person in charge
etc

[sparkplug93]

See below

[sparkplug93]

Hello,
It is coming with no delimiters but every value is on it’s own line as in:

Sheet #
Date
person in charge
etc

[sparkplug93]

Do you have an example workflow using this?

Thanks for your help