Hi guys, I have this create HTML content, insert datatable on variables, but why it takes first row as header.
What should I do?
This is the datatable:
Thank you so much.
Hello there,
@hurmet.noka then just try to read the table without headers. uncheck the checkbox from read range table conatains header make it false.
I Want the headers!!! My issue is that headers are not present.
Just read, read range will consider the header as row and then send mail html activity will consider that first row as header again.
The Datatable is coming from a query on a database not from a read excel.
It seems to be a known issue.
Somebody proposed a workaround here, you can take a look:
Post HTML email with datatable but doesn’t contain header - Help / Studio - UiPath Community Forum
It basically creates a fake row as a first row, which will be skipped. Your header will be shifted to 2nd row and displayed as a header. Quite annoying, but it should work.
1 Like
2 Likes
@hurmet.noka
Use following using LINQ you can manupulate
Assign activity:
ConvertedDataTable = New DataTable()
ConvertedDataTable.Rows.Add(OriginalDataTable.Columns.Cast(Of DataColumn)().Select(Function(column) column.ColumnName).ToArray())
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.