topic RE: PDF to Excel in Product Forum

PDF to Excel

zainebdhifli1 — Tue, 19 May 2020 13:45:00 GMT

Hi,
Please I need to convert PDF to Excel, is there any solution?

------------------------------
zaineb dhifli
------------------------------

RE: PDF to Excel

GopalBhaire — Wed, 20 May 2020 06:49:00 GMT

If you have Acrobat Pro you can directly use the Export to generate excel, you can also write code for it.
Or you can get data from PDF using BP, format it (using regex) and save it in Excel. Another option is to write a script in python and call it using BP.

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

RE: PDF to Excel

MayankGoyal2 — Sat, 23 May 2020 23:09:00 GMT

Gopal Bhaire - thanks a lot for your response, I have few questions on this.

1) Is there any standard VBO in blue prism for Acrobat Pro. I have used it with code in excel VBA in past however not sure if BP has a standard VBP supporting it
2) Python - This one is quite interesting, kindly provide some pointers on how can i integrate my python script on bot with BP?

------------------------------
Mayank Goyal
------------------------------

RE: PDF to Excel

GopalBhaire — Tue, 26 May 2020 04:48:00 GMT

1. Currently no VBO for Acrobat Pro from BP, but you surely create one.
2. You can directly run your python script using Start Process and read std out action of Utility Environment passing interpreter as program and your script as argument.

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------