Column to HTML

Bronze Certified

Custom Activity

1 reviews

106

Column to HTML

Bronze Certified

Custom Activity

1 reviews

106


Summary

Convert Excel / DataTable column to HTML format.

carouselImage0

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


Tags

ColumnToHTML
ColumnToTextFile
ExcelToHTML
ExcelToText

Compatibility

Studio: 20.4.3 - 21.4.4


Dependencies

UiPath.Excel.Activities >= 2.9.5 UiPath.System.Activities>=20.10.3



Similar Listings