topic Re: pdf to excel issue in Digital Exchange

pdf to excel issue

blazino17 — Wed, 06 Nov 2024 08:57:16 GMT

HI Team, Please I have a scenario where I have to copy a give section of a table from a given pdf file and paste into an excel sheet before i perform a filter . how do i get to resolve this? I need directions please

Re: pdf to excel issue

saivikas729 — Fri, 08 Nov 2024 13:06:39 GMT

Hi,

Never had to do this - but if Data is structured in PDF - Try opening it with your approved PDF tool and copy text to clipboard and then to Excel?

also may be can convert PDF to Excel based on tools you have (used to do this with adobe pro ) if i Remember it correctly.

regards

vikas

Re: pdf to excel issue

blazino17 — Fri, 08 Nov 2024 15:53:31 GMT

Thank youu, i would try that now.

Re: pdf to excel issue

tim.dauti — Sun, 01 Dec 2024 20:33:25 GMT

Hello,

is it an editable pdf? If that’s the case I could share with you a code stage.

if it is a non editable pdf but the structure is always the same “pdf form” You could use Excel under “data” get data from pdf . This will open Power Query interface and you could extract the table in the excel file, which than can be read from Blue Prism.
kindly

Tim