i want to extract table from body of an outlook email save it ina excel file and further send it to respective mail id and in the process i have reached here like used save mail message activity and opened in a browser but i couldnt extract table using scraping so can anybody help me in solving this
please any help would be appreciated
Did you tried to save it in HTML format and then open by open browser and then scrap it ?
Or another way is to use the activity for extracting tables from email to save it into excel directly
can you let me know the activity name? because scrape wasnt working in my case @NIVED_NAMBIAR
Try this please
Mark it as solution if it helps you
two activities were missing @NIVED_NAMBIAR
two of the activities were missing/invalid from the workflow @NIVED_NAMBIAR
Hmm seems like a version mismatch
Let me try from my side and let you now
I found a blog regarding this
If it does not work, we had to go for c#/vb net /python coding to extract table out of pdf
thank you for the help! i will try and let you know @NIVED_NAMBIAR
i got this error
Extract data tables from HTML: Could not load file or assembly ‘HtmlAgilityPack, Version=18.104.22.168, Culture=neutral, PublicKeyToken=bd319b19eaf3b43a’ or one of its dependencies. The system cannot find the file specified.
It is working fine for me
seems like a version problem for you. Can u check at the dependency section?
what should i check at dependencies section? @NIVED_NAMBIAR
this is how dependencies looks like in my project
Please try below steps and let me know if its working or not
Download the below activity
MailMessages is the out of GetOutlookMail activity
Result is the out of Extract tables from email activity
still getting error @vinithareddyk123
The activity you have used is different please use Extract table from email activity ( This Activity is available if you download the package which I have mentioned earlier)
thank you so much @vinithareddyk123 I got the output
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.