Accelerators
Partner Solutions
Professional Services
Collections
Sign In
Accelerators
Partner Solutions
Professional Services
Collections
Column to HTML
by Jack Chan
1
Activity
2.2k
Summary
Summary
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
Code Language
Visual Basic
Runtime
Windows Legacy (.Net Framework 4.6.1)
License & Privacy
MIT
Privacy Terms
Technical
Version
1.0.1Updated
Jun 5, 2021Works with
Studio: 21.10 - 22.10
Certification
Silver Certified
Tags
ColumnToHTML
ColumnToTextFile
ExcelToHTML
ExcelToText
Application
Microsoft Excel
Support
UiPath Community Support
Resources
Similar Listings
