pdf to excel issue

[blazino17]

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

[saivikas729]

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

[blazino17]

Thank youu, i would try that now.

[tim.dauti]

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