How to copy some content of excel sheet(A3 TO E32) to email body

Help Something Else
1

Hi,

I need help with copying excel content(some part) to email body.

The color and format must be the same like in excel file.

Thanks,
Naresh

2

Hi @Mandava_Naresh

3

@sangeethaneelavannan1

How can I specify cell range ? I want to take from A3 to E32 in excel

image
image1552×753 44.3 KB

4

First take the range of excel to one sheet and then convert that sheet to html table

5

@sangeethaneelavannan1

I tried this but it is not working

image
image1528×634 32.2 KB

6

Create New “Sheet2” write the datatable there, while reading make sure Preserve the format is checked in Properties, then use “Sheet2” in HTML Table from Excel.

7

No,you have write that datatable in new sheet and then pass that sheet name in html table from excel activity sheet name field

8

Hi @Ganesh_Dongre @sangeethaneelavannan1

It is not working as expected

Expected O/P

image
image1048×330 17.8 KB

Actual 0/P

image
image1687×687 52.1 KB

9

To copy a range of cells from an Excel sheet to the body of an email in UiPath, you can use the following steps:

  1. Read the data from the Excel sheet into a DataTable using the Read Range activity.
  2. Use the Build Data Table activity to create a new DataTable that includes only the cells in the desired range.
  3. Use the For Each loop to iterate over the rows in the DataTable.
  4. Inside the loop, use the Concatenate activity to combine the values from the cells in the row into a single string.
  5. Use the Append Line activity to add the string to the email body.
10

@sudheern … I am unable to get it … Can you please attach any sample xaml ?

11

Screenshot from email (Can select From and to cells)

image
image1035×507 49.3 KB

Attach screenshot in email body

12

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