English
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
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
Documentation
Support
UiPath Community SupportSimilar Listings
