How we get the data from gmail body to excel and how to filter the excel columns.
what kind of data is present in body?
You can use get smtp mail activity for fetching mails then
using for each of mailmessage---------datatype - system.net.mailmessage
assign body=item.body.tostring
then write in cell in excel that variable.
What is the purpose of filter excel
if u directly want to apply that filter on excel then by using hotkeys you can apply filter
say select first row
then using hokey
ctrl+shift+L filter will be apply
if you want data to extract from excel by applying filter and then want that data into another sheet then
use read range then using filter datatable apply condition for filter on column then output of that filter datatable activity can be use d in write range for write filterd data into excel
In mail table structure data
like this and end of the mail link is there if we click that link it will open another tab above image.
I am not getting will u pls share your mail body
If we Click the Link in mail body that will open another tab with total data.Now we need to take the whole data and copy in to xlxs and need to filter the columns what we need.Like StoreScreen.zip (452.0 KB)
If you need to check what am done in bot am attaching the bottest.xaml (28.8 KB) .I think data scraping is not working.