Skip to main content

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.

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.

 

 

 

 

 

I need to extract only table from the outlook in AA360 version. How to do that… Is there any package 


I need to extract table values from the PDF also and need to save it in excel. Kindly assist


I need to extract only table from the outlook in AA360 version. How to do that… Is there any package 


Hi @SindhujaaS101835,

you can use the “Email” package along with some additional steps to parse the table data. Here’s a general approach:

  1. Retrieve Emails:

    • Use the “Email: Get Messages” action to retrieve the emails from your Outlook account. Make sure to specify the folder (e.g., Inbox) and any filters (e.g., subject, sender) if needed.
  2. Extract Email Body:

    • Use the “Email: Get Message” action to extract the body of the email that contains the table.
  3. Parse HTML Content:

    • Since email bodies are often in HTML format, you can use the “String package” action to extract the table data from the HTML content.
  4. Store Table Data:

    • Store the extracted table data in a variable or directly into an Excel file for further processing.

I hope this helps.


Reply