Business Solutions
Business Solutions
Collections
Collections
Business Solutions
Business Solutions
Collections
Collections
English
|
Japanese
Column to HTML
by Jack Chan
1
542
Column to HTML
by Jack Chan
1
Custom Activity
542
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
MIT
Technical
Version
1.0.1Updated
05 Jun 2021Works with
Studio: 20.4.3 - 21.4.4
Certification
Silver Certified
Tags
ColumnToHTML
ColumnToTextFile
ExcelToHTML
ExcelToText
Application
Microsoft Excel
Support
UiPath Community Support
Resources
Similar Listings
English
English
日本語