Html table creation

Help Forum
1

Hi ,

I have one excel which consist of Requestor name. I want to create html table for requestor name which consist ISIN and services.
But for duplicate requestor only 1 html table should get created with multiple ISIN and services against that requestor. Attaching the excel.
Testing List for BOT 23.02.2026.xlsx (10.1 KB)

2

Hi sshitol

Just to clarify for me, in the attached excel you need a HTML table for each requestor - so in this case 5 tables, where 2 of the tables has 2 rows?

Could you maybe make an example?

3

yes right. 5 table,where 2 of the tables has 2 rows. but make it dymanic.. because it may have 3 rows 4 rows.

4

Hi @sshitol
Please try this approach

You can achieve this by grouping the DataTable by the Requestor column and then generating one HTML table per Requestor.

Example:

Dim groups = dtData.AsEnumerable().GroupBy(Function(r) r("Requestor").ToString)

For Each g In groups
    html &= "<h3>" & g.Key & "</h3><table border='1'>"
    html &= "<tr><th>ISIN</th><th>Services</th></tr>"

    For Each row In g
        html &= "<tr><td>" & row("ISIN").ToString & "</td>"
        html &= "<td>" & row("Services").ToString & "</td></tr>"
    Next

    html &= "</table><br/>"
Next

This will create one HTML table per Requestor, and if a Requestor has multiple rows (ISIN & Services), they will appear as multiple rows in the same table dynamically.

If Solution help you please mark as Solution ,
Thanks & Happy Automation with UiPath

5

Hi again

I made a small projekt you can use to try it out. Find it here: UiPath-Forum-Examples/Html table creation at main · AutomationGems/UiPath-Forum-Examples · GitHub

When I run it it looks like this:

image
image1266×337 15.2 KB