Create your first automation in just a few minutes.Try Studio Web

Column to HTML

Column to HTML

by Jack Chan

1

Activity

Downloads

2.2k

back button
back button
carouselImage0
next button
next button

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)

Publisher

Jack Chan

Visit publisher's page

License & Privacy

MIT

Privacy Terms

Technical

Version

1.0.1

Updated

June 5, 2021

Works with

Studio: 21.10 - 22.10

Certification

Silver Certified

Application

Microsoft Excel

Support

UiPath Community Support

Resources

Similar Listings