Hi Everyday we are getting emails with client data in the table. That table is located into the email’s body. What we are doing: Extracting particular data and sending it to robots for further processing. The Problem: length, width and rows of the table are dynamic. Everytime we are getting a l…

What is the best solution to extract information from various excel tables which are located in one file?

Pablito (Pawel Wozniak) January 8, 2021, 9:35am 2

Hi @Karolis_Urbonas,
Please follow this thread to see some excel examples:

As well as “Regex” which could help you with this. There are tons of solutions on forum.

Topic		Replies	Views
How to extract table data and individual texts from multiple emails Help	0	742	February 3, 2020
How to store the extracted tables data in an excel sheet Studio uiautomation	21	549	July 27, 2023
Extracting tables from email body in outlook app Studio studio , question , find_references	6	2783	March 17, 2022
Extract a table from outlook mail and then store the values in an excel table Studio excel , mail , activities , regex , string , question	1	1108	May 8, 2020
Extract Table from Outlook Help excel , outlook , activities , data_scraping	14	14341	October 29, 2018