Column to HTML

Bronze Certified

Custom Activity

1 reviews

168

Summary

Convert Excel / DataTable column to HTML format.

Overview

This package contains 2 activities:

1) Convert DT column to HTML - converts a DataTable column to HTML format.

Inputs

a)  In_columnName – name of the column that needs to be converted to HTML.
b)  In_dt = DataTable
c)  In_outputTextFilePath (optional) – if filled in, it will also write the column into a text file (useful
for SAP operations).

Outputs
a) Out_columnListHTML – the output HTML text.


2) Convert Excel column to HTML - converts an Excel column to HTML format.

Inputs

a) In_columnName – name of the column to be converted to HTML.
b) In_rangeToRead – Excel range to read (“leave blank to read from A1”).
c) In_sheetName – the name of the sheet.
d) In_excelPath - Excel path.
e) In_outputTextFilePath (optional) – if filled in, it will also write the column into a text file (useful
for SAP operations).
f) In_useFilter - if this is True, it will only read the filtered cells (if filter exists) and not the whole table.

Outputs

c) Out_columnListHTML – the output HTML text.

Benefits

Useful when: 1) you have to include table column data in the email body and 2) upload an Excel column to SAP.

Published: 22 Feb 2021 | Updated: 14 Jun 2021

Jack Chan

RPA Developer

License

MIT

Code Language

Visual Basic

Runtime

.NET Framework

DataTable Utility Activity…

Custom Activity

This Custom Activity provides the ability to convert DataTable to HTML table, convert to JSON, find Min,Max and Average of a column, find column names and rename column in a DataTable…

637

Bronze Certified

Supported by Publisher

Mastek - Generic - Convert DataTable to HTML Table…

Custom Activity

This component is used to convert DataTable into HTML table format. The Output is HTML string which will be used directly or under HTML body to represent the HTML table…