DataTable to HTML using Assign Activity

[poorna_nayak07 (Poornachandra M)]

Hello,

Here is the solution for converting DataTable variable into HTML table.
By this you can avoid adding new dependencies to your project or implementing long workflows to get data in HTML table format.

Create a String variable (HTMLBodyStr) and assign below expression to it. Replace TestDT variable with your Datatable Variable

HTMLBodyStr="<table border=2><tr><td>"+String.Join("</td><td>",TestDt.Columns.Cast(Of DataColumn).Select(Function (x) x.ColumnName).ToArray)+"</td></tr>"+
"<tr>"+String.Join("</tr><tr>",(From x In TestDt.AsEnumerable
Let cells="<td>"+String.Join("</td><td>",x.ItemArray)+"</td>"
Select cells).ToArray)+"</tr>"

You can find the same in this link

[jeevith (Jeevith Hegde, Ph.D.)]

Hi @poorna_nayak07,

That is a cool little snippet requiring zero dependencies.

Quite useful for people looking to embed html tables in emails.
Thanks for sharing.

I will soon try it out on a TDD generator workflow.

[JavRR]

@poorna_nayak07

"<table border=2><tr><td>"+String.Join("</td><td>",TestDt.Columns.Cast(Of DataColumn).Select(Function (x) x.ColumnName).ToArray)+"</td></tr>"+
"<tr>"+String.Join("</tr><tr>",(From x In TestDt.AsEnumerable
Let cells="<td>"+String.Join("</td><td>",x.ItemArray)+"</td>"
Select cells).ToArray)+"</tr>"

So great solution.
I newy to this. So how can I change headers to be bold?

[poorna_nayak07 (Poornachandra M)]

Hi @JavRR ,

Glad to know that it is useful to you
You could try below expression to get what you wanted to.

HTMLBodyStr="<table border=2><b><tr><td>"+String.Join("</td><td>",TestDt.Columns.Cast(Of DataColumn).Select(Function (x) x.ColumnName).ToArray)+"</td></tr></b>"+
"<tr>"+String.Join("</tr><tr>",(From x In TestDt.AsEnumerable
Let cells="<td>"+String.Join("</td><td>",x.ItemArray)+"</td>"
Select cells).ToArray)+"</tr>"

Thanks,

[RPA_Canada]

@poorna_nayak07

for converting D

Hi, Thanks for the guide.
I got an error. Do you have a xaml file to compare?

[poorna_nayak07 (Poornachandra M)]

Hi @RPA_Canada,

The reason for the issue you are facing is because of an extra assignment operation inside assign activity.

Please refer above picture and remove highlighted part from assign activity

Thanks