How to paste the table which is in the excel along with format in mail body

Help Automation Ops
,
1

How to paste the table which is in the excel along with format in mail body.
The table has some formats like orders and colours. How to copy paste the table into body of mail.

2

Hi @anjani_priya

Can you share the input excel file.

Regards

3

@anjani_priya Use the “Copy/Paste Range” activity in Excel to transfer the table from one sheet to another while preserving the column formatting.

The image displays an Excel automation process where data is being copied from a specified range in "Sheet1" to a different range in "Sheet3" of the same "TestData.xlsx" file. (Captioned by AI)
The image displays an Excel automation process where data is being copied from a specified range in "Sheet1" to a different range in "Sheet3" of the same "TestData.xlsx" file. (Captioned by AI)616Ă—793 48.2 KB

Cheers! Happy Automating! :rocket::blush:

4

The table should be paste in the body of the mail.

5

@anjani_priya

there is no direct way

you would need to read the data and formatting of cells and create the html table

rather better approach would be to try taking a screenshot or save the excel as pdf and then attach it

cheers

6

Hello @anjani_priya

You could check out the Datatable Activities package from @lakshman in the UiPath Marketplace package source.

I can see that he has developed an activity called Datatable to HTML which would probably solve your request.

Regards
Soren

7

@anjani_priya Use the “Create HTML Content” activity to format data values as a table, then include the table in the email content to display the data in the email.

A screenshot of an email editor displaying instructions for adding a DataTable to HTML mail content, with options to insert data values. (Captioned by AI)
A screenshot of an email editor displaying instructions for adding a DataTable to HTML mail content, with options to insert data values. (Captioned by AI)829Ă—440 52.1 KB

8

The image shows an HTML content editor interface with various text formatting options and a "Map data values" menu open in the top right corner. (Captioned by AI)
The image shows an HTML content editor interface with various text formatting options and a "Map data values" menu open in the top right corner. (Captioned by AI)1192Ă—673 17.7 KB

I couldnt find

9

how can I crop automatically

10

file.xlsx (10.8 KB)

11

Hi @anjani_priya

We cant use html content activity since the format does not get preserved ! Use the below workflow

image
image318Ă—601 27.1 KB

Check the xmal
Main.xaml (13.1 KB)

Output email image

image
image534Ă—204 18.7 KB

Hope this helps !

2 Likes
12

@anjani_priya
Steps to add DataTable in mail content

  1. Open HTML Content Createor
  2. Click on Add Data Values in the top right corner.
  3. Add map values and select “Add Value” type as Table and provide a Data Table Variable to the Table and close the popUp
  4. Click on HTML content> click on “Add Data Values” and Select the variable/table to add

Please find the attached Xaml file and will help you in practically.
Sequence2.xaml (12.9 KB)

1 Like
13

How to add the screenshot picture in the body of the mail?

14

Convert the picture to base64string
base64image = Convert.ToBase64String(System.IO.File.ReadAllBytes(“filePath”))
and then in mail body you can add html string
"<img src='data:image/jpg;base64," & base64image & "' width='750' height='800' align='center'/>"’

1 Like
16

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.