Hi everyone, i’d like to share my new custom activity. Feel free to use it and ask any questions
This package contains 2 activities: Convert DT column to HTML and Convert excel column to HTML
-
Convert DT column to HTML - converts a DataTable column to HTML format.
-
Convert Excel column to HTML - converts an Excel column to HTML format.
This is useful for when you need to send an email and include an excel column in your HTML body…
Inputs/outputs
1. Convert DT column to HTML
Inputs
a) In_columnName – name of column to convert to HTML
b) In_dt = datatable
c) In_outputTextFilePath (optional) – if filled in, it will also write the column into a text file (this is useful for SAP operations)
Outputs
a) Out_columnListHTML – the output HTML text
2. Convert Excel column to HTML
Inputs
d) In_columnName – name of column to convert to HTML
e) In_rangeToRead – excel range to read (“leave blank to read from A1”)
f) In_sheetName – name of sheet
g) In_excelPath- path of excel
h) In_outputTextFilePath (optional) – if filled in, it will also write the column into a text file (useful for SAP operations)
Outputs
b) Out_columnListHTML – the output HTML text