Column to HTML

by Jack Chan

1

2.1k

Column to HTML

by Jack Chan

1

Custom Activity

2.1k

carouselImage0

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)

Publisher

Jack Chan

Visit Publisher's Page

License & Privacy

MIT

Privacy Terms

Technical

Version

1.0.1

Updated

05 Jun 2021

Certification

Silver Certified

Tags

ColumnToHTML
ColumnToTextFile
ExcelToHTML
ExcelToText

Application

Microsoft Excel

Support

UiPath Community Support

Resources

Similar Listings