Htmltable

Help Studio
1

Dear, I need your assistance.

I need the values in one column of an HTML table to be checked, and the cells should be highlighted based on the following conditions:
Values less than 9999 should be marked in red.
Values between 10,000 and 15,000 should be marked in yellow.

This table will be sent as the body of an email.

2

@okalinic,

Refer this code.

Input file:

A table displays information about four entries, including their ID, link, title, contact name, status, priority, and amount, presented in a structured format with headers highlighted in blue. (Captioned by AI)
A table displays information about four entries, including their ID, link, title, contact name, status, priority, and amount, presented in a structured format with headers highlighted in blue. (Captioned by AI)1090×231 18.7 KB

Output Email:

An email from Ashok Karale at XYZ Company to the team contains a table with data on various items, including ID, links, titles, contact names, status, priority, and amounts. (Captioned by AI)
An email from Ashok Karale at XYZ Company to the team contains a table with data on various items, including ID, links, titles, contact names, status, priority, and amounts. (Captioned by AI)1585×889 46.4 KB

Code Snippet:

This is a flowchart depicting an automated process for reading data from an Excel file, converting it into an HTML table, and emailing the resulting data using Microsoft Outlook. (Captioned by AI)
This is a flowchart depicting an automated process for reading data from an Excel file, converting it into an HTML table, and emailing the resulting data using Microsoft Outlook. (Captioned by AI)920×1029 55.2 KB

Code to change color as per value:

If(CDbl(CurrentRow.Item("column Name").ToString) < 10000,"<td style=""color: red;"">","<td>")+CurrentRow.Item(6).ToString+"</td></tr>"

Full Code developed on Studio version 2025.0.157:
SendHTMLBodyEmail.zip (198.8 KB)

3

Hi @okalinic
If the input is in html format i.e table, then follow this
Download the package"UiPathTeam.ExtractDataTablesFromHTML.Activities"

image
image529×423 14.3 KB

"<table border=2><tr><td>" + 
String.Join("</td><td>", tablearray(0).Columns.Cast(Of DataColumn).Select(Function(x) x.ColumnName).ToArray) + 
"</td></tr>" + 
String.Join("</tr><tr>", 
(From x In tablearray(0).AsEnumerable 
Select "<tr>" + 
String.Join("", x.ItemArray.Select(Function(cell, index) If(tablearray(0).Columns(index).ColumnName = "Values" AndAlso CDbl(x("Values").ToString) < 9999, 
    "<td style=""color: red;"">" + cell.ToString() + "</td>", 
   If(tablearray(0).Columns(index).ColumnName = "Values" AndAlso CDbl(x("Values").ToString)< 10000 AndAlso CDbl(x("Values").ToString) < 15000, 
    "<td style=""color: red;"">" + cell.ToString() + "</td>", 
    "<td>" + cell.ToString() + "</td>"))
).ToArray) + "</tr>"
).ToArray) + 
"</table>"

Demo output!

image
image161×238 1.75 KB

Hope this helps