Hoping someone can help me.
I am lifting the body of an email as html. Using regex to find the specific table I want and then trying to convert that table (which is in hmtl) into a datatable.
I have tried the HTMLtoDatatable component (taken from marketplace) but it does not format the tables correctly.
I have seen other posts about this but with no solution. Is it possible to do? If I open the email on a webpage and use datascaping it formats the datatable perfectly. However this is slow and i want to see if theres a better way of doing it.
Write the HTML (which is just text) to a file with extension .html
Use Application/Browser to open the .html file in the browser
Extract Table Data wizard to scrape it to datatable
Delete .html file
@Tony12 Data scraping would be the right and accurate one in extracting table data. My assumption is you were opening the email in the browser that would causing it to slow. Did you try extracting the data without opening it in web page ( from the mail application directly)