AtoS.Excel_to_Html.Activities + Project Convert to Windows

Help Activities
,
1

Hi, everyone
I have a project which was ‘Windows-legacy’ and used a dependency named ‘AtoS.Excel_to_Html.Activities’. I use this to catch excel data and convert to html text, Now I 'm trying to convert to ‘Windows’, about this sequence, is there any other activity can do this?
Thanks

2

Hi @maxzz

Try to use an Invoke Code activity with VB.NET to convert the Excel DataTable to HTML manually. Might be work.

Happy Automation

3

you can use below in invoke code activity

    Dim htmlTable As New System.Text.StringBuilder()

    ' Start the HTML table
    htmlTable.AppendLine("<table style='border-collapse: collapse; width: 100%;' border='1'; font-family: AmplitudeTF;'>")

    ' Add the header row with background color
    htmlTable.AppendLine("<tr>")
    For Each column As DataColumn In dataTable.Columns
        htmlTable.AppendFormat("<th style='background-color: #DEEAF6;border: 1px solid black;font-family:=AmplitudeTF;'>{0}</th>", column.ColumnName)
    Next
    htmlTable.AppendLine("</tr>")

    ' Add the data rows
    For Each row As DataRow In dataTable.Rows
        htmlTable.AppendLine("<tr>")
        For Each column As DataColumn In dataTable.Columns
			If column.ColumnName = "Share Path" Then
				htmlTable.AppendFormat("<td style='border: 1px solid black;font-family:=AmplitudeTF;'>{0}</td>", "<a href=""" & row(column).ToString & """>" & row(column).ToString & "</a>")
			Else
				htmlTable.AppendFormat("<td style='border: 1px solid black;font-family: AmplitudeTF;'>{0}</td>", row(column))
			End If
        Next
        htmlTable.AppendLine("</tr>")
    Next

    ' End the HTML table
    htmlTable.AppendLine("</table>")
	
	Out_str_HTML_Table = htmlTable.ToString

image
image709×201 7.6 KB