How to copy the content (pivot table) of an excel sheet to a mail body in send exchange mail activity?

[Sathish_Kumar_S]

How to copy the content (pivot table) of an excel sheet to a mail body in send exchange mail activity?

We are downloading the daily report from ticket tool and send the report on daily basis. We are able to find the latest downloaded file using Directory.GetFiles(“C:\Users\sathish\Downloads”,”*.xls”).orderbydescending(Function(a) New FileInfo(a).CreationTime).ToList(0).ToString

and run pivot activity to store the pivot table in another sheet in same downloaded file.

We would like to copy the pivot table from an excel sheet to a mail body and send email using exchange mail activity.

[Nithinkrishna]

Hi @Sathish_Kumar_S

Hope you’re doing well

1. Just read the final resultant table from Excel

2. Convert the datatable to HTML table

Xebia - DataTable to HTML Table Conversion - RPA Component | UiPath Marketplace

3. Pass it to the mail body and mark BodyHTML property as true in mail activity

Thanks
#nK

[Sathish_Kumar_S]

Thank you… I am doing good

[Sathish_Kumar_S]

Hi Nithin,
It is working perfectly… Thank you. But whatever the text we are adding above HTML are printing in single line. I need " Please find the automation" in next line and i have added environmet.new line. But still all the texts are printing in single like above HMTL

[Sathish_Kumar_S]

I have added
HTML tag and it worked