How to extract PDF Table into an excel file

[sharazkm32 (Sharaz K M)]

One of the requirement is to extract Table from PDF and write those values into an excel file maintaining the headers

Table is expected to have 5 columns

Rows might vary - Either in one page or it could go to second and third page as well

We can assume that the Table is between 2 MAIN Headers. So Table would present anywhere between these headers

It would be great if someone could help on this scenarion

Please note that the user have StudioX license only

[sharazkm32 (Sharaz K M)]

Any help on the above post??

@Anil_G @ashokkarale @Yoichi

[ashokkarale]

@sharazkm32,

With StudioX it’s quite difficult I must say. You can try using Read PDF text with string manipulation.

Activities - Read PDF files

[sharazkm32 (Sharaz K M)]

I tried that. But hard luck

Is there any option in Studio without using Document Understanding?

[Anil_G (Anil Gorthi)]

@sharazkm32

Did you happen to try loading pdf into excel?

cheers

[ashokkarale]

@sharazkm32,

How about Autopilot for Everyone? Is it available and allowed?

Also checkout Clipboard AI

Clipboard AI - Copy Paste Automation | UiPath

[sharazkm32 (Sharaz K M)]

I will give a try and let you know

[sharazkm32 (Sharaz K M)]

Nope. Yet to migrate to latest version.