Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Rajkumar Ramaswamy (RajkumarR3680)
Cognizant Technology Solutions India PVT Ltd

Cognizant Technology Solutions India PVT Ltd
IN
RajkumarR3680 Member since 2019 5 posts
Cognizant Technology Solutions India PVT Ltd
Posted: Jan 16, 2020
Last activity: Jan 22, 2020
Posted: 16 Jan 2020 7:47 EST
Last activity: 22 Jan 2020 8:08 EST
Closed

Read values in PDF and extract the same to excel

Hello All,

Could you please help me with reading values in PDF and extracting the same to excel.

Also share the configuration setup required to complete this activity.

To see attachments, please log in.
Robotic Process Automation

Posted: 5 years ago
Posted: 16 Jan 2020 10:44 EST
Bhabani Shankar Jena (Bhabani_Jena)
Boubyan Bank
Sr. Pega BPM & RPA Engineer
Boubyan Bank
KW
Pega Robotics has inbuilt pdf connector, refer https://academy.pega.com/library/72/robotic-webinar-using-pdf-connectors This will help you for standard formats, and it is rich with features such as search by text / word / segment / position,... If you need further complicated automations, then any. DotNet library from external space can be used ( ex. Itextsharp, this is a powerful library for individual usey, and licensed for enterprise usage) For excel, you can use the inbuilt excel connector. Refer https://community.pega.com/video-library/use-excel-file-connector-read-spreadsheet-data-pega-robotics Again, pega robotics has rich features, just you have to explore the methods and properties of all these tooolbox components and utilize then as per your automation need
To see attachments, please log in.
Posted: 5 years ago
Posted: 20 Jan 2020 5:28 EST
Rajkumar Ramaswamy (RajkumarR3680)
Cognizant Technology Solutions India PVT Ltd

Cognizant Technology Solutions India PVT Ltd
IN

Thanks Bhabanishankarj for your valuable response.

And is GetRelativeWord(int relativeWordOffset, out PdfWord resultWord) available in version PEGA 8.01?

Since i am not able to extract required information from PDF.

 

 

 

 

To see attachments, please log in.
Posted: 5 years ago
Posted: 20 Jan 2020 8:15 EST
Bhabani Shankar Jena (Bhabani_Jena)
Boubyan Bank
Sr. Pega BPM & RPA Engineer
Boubyan Bank
KW

yes ,

the method is available ,

the functionality is to get a word relative to this(supplied) word.

 

if you are getting false , just check if you are passing correct parameters,

 

Also, it is better to try on a standard pdf , then calibrate your practice.

To see attachments, please log in.
Posted: 5 years ago
Posted: 21 Jan 2020 2:46 EST
Rajkumar Ramaswamy (RajkumarR3680)
Cognizant Technology Solutions India PVT Ltd

Cognizant Technology Solutions India PVT Ltd
IN

I don't find the option under methods (PDF Connector).

Attached the screen prints for your reference.

Version: Pega Robotics Automation Runtime Agent 8.0.1081

 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice