PDF to Excel Formatting

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?

1 Like

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

Hi @sparkplug93

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

cheers :smiley:

Happy learning :smiley:

2 Likes

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

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

2 Likes

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

Sheet #
Date
person in charge
etc

See below

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

Sheet #
Date
person in charge
etc

Do you have an example workflow using this?

Thanks for your help

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