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
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.
Thanks for your response Rotfcoy. How to add the headers in excel by using the command in studio. Can anyone guide me please?
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.