Sign In
Create your first automation in just a few minutes.Try Studio Web →
Column to HTML
by Jack Chan
1
Activity
2.2k
Summary
Summary
Convert Excel / DataTable column to HTML format.
Overview
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.
Features
Features
Useful when: 1) you have to include table column data in the email body and 2) upload an Excel column to SAP.
Additional Information
Additional Information
Dependencies
UiPath.Excel.Activities >= 2.9.5 UiPath.System.Activities>=20.10.3
Code Language
Visual Basic
Runtime
Windows Legacy (.Net Framework 4.6.1)
License & Privacy
MIT
Privacy Terms
Technical
Version
1.0.1Updated
June 5, 2021Works with
Studio: 21.10 - 22.10
Certification
Silver Certified
Application
Support
UiPath Community Support
Resources
Similar Listings
