Insert pivot table in mail body

Help Studio
, ,
#1

Hi,
My today’s query is to insert pivot table in mail body with same format and colour given in sheet.
I try many times but not received any output.

please help me out to solve this problem.

here I am attach the file for your reference.
pivot.xlsx (24.5 KB)

#2

Hi @lakshya_garg1
Please read pivot table and then change into html body and give css according your requirements.

#3

Here I am sharing datatable to html string.

Please read excel file store datable and pass that datable to this module. Then it will return html string that pass to email body.

#4

it’s not working

#5

Hello @lakshya_garg1

You can use Create Html content activity.

How to use Create HTML Content activity to add tables and images to email body in UiPath? | AutoBot

Thanks

#6

I already use it, this only create table not fill colour as required.

#7

If it is possible to create code for me because I have to submit my project urgently.

If some one help me then it means alot for me.

#8

For the color again you need to replace the html tags with the formatted tags.

For that, you can use the Replace method.

Thanks