Question

How to copy a table from an email body and paste in excel

  • 12 January 2024
  • 1 reply
  • 214 views

Badge +5

Hi all, I want to get only the table from an email body, not the other data, and paste it as a table in excel. How can i do that.


1 reply

Userlevel 6
Badge +15

Hi @tayyabimtiaz1 ,

 

Please try out the below steps,

 

Extract Table from Email Body: Use Automation Anywhere A360's email package to retrieve the email body. Extract the HTML content of the email body, and then parse it to extract the table. You may need to use regular expressions or HTML parsing tools for this task.

https://docs.automationanywhere.com/bundle/enterprise-v11.3/page/enterprise/topics/aae-developer/aae-extract-html-currency-conversion.html

Once,you have extracted the date use the excel advanced package to update excel sheet.

 

i hope this helps.

 

 

 

 

 

Reply