cancel
Showing results for 
Search instead for 
Did you mean: 

pdf to excel issue

blazino17
Level 4

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

3 REPLIES 3

saivikas729
Level 5

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

Thank youu, i would try that now.

tim.dauti
Level 3

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