Support > Forums > OpenBots Studio > How to extract the value from the PDF & Write in Excel?

How to extract the value from the PDF & Write in Excel?

Jamuna T

  • Reporter
  • Calender Icon February 22,2021 at 12:53 PM

Hi,

I need to extract product no & Amount from the PDF & also need to write the extracted value in excel with the corresponding headers name then need to send mail with Output sheet.

Kindly guide me how to do this by using the Open Bots commands in studio. Thanks.

This forum has 172 topics, 459 replies, and was last updated 2 hours ago by Poornima Malv

Lakshmi Sukumar

  • Participant
  • Calender Icon February 25,2021 at 6:04 PM

Hi Jamuna, While using the 'Get Range' and 'Write Range' commands, the first row of the data in Excel can be read/set as header when you add the 'Add Header' property in the 'Get Range' and 'Write Range' commands to 'Yes'.This will make sure the first row is treated as a header when reading or writing the data in Excel.

If you would like to know more about Excel automation, Please refer the documentation section here - https://openbots.ai/product/openbots-studio/how-to-guide-for-openbots-studio/excel-automation/.

Hope this helps.

Jamuna T

  • Participant
  • Calender Icon February 23,2021 at 10:29 AM

Hi,

Thanks for your response Rotfcoy. How to add the headers in excel by using the command in studio. Can anyone guide me please?

Rotfcoy

  • Participant
  • Calender Icon February 22,2021 at 9:58 PM

Hi Jamuna,

This is what i do normally for PDF extraction. Get PDF text > Get Regex Matches > either Loop Collection or Get list Item for specific value.

To enter variable into Excel, Create Excel Application > Write Cell You may need to create a Counter variable to populate to other cell locations.

You are not authorized to reply, please click here to login and add your reply to this topic.