Components
This directory contains 193 workflows.
Excel Comment Reader
Reads the cell comments from the specified sheet of the Excel xlsx file. Limitations This uses the apache poi 4.1.1 package to access the xlsx file. This […]
Excel Date Serial to DateTime
Converts chosen numeric columns containing Excel Date Serial numbers to datetime. @takbb Brian Bates 8 July 2022
Excel Font Changer
Changes the font for every cell on a specified sheet in an XLSX file. This component uses Python and openpyxl which must be installed and available to your […]
Excel Unmerge Cells
Reads an Excel XLSX or XLS file and attempts to unmerge any merged cells. All unmerged cells are given the value that previously applied to the merged […]
Extract Data Table from Delimited Text
THIS COMPONENT IS DEPRECATED 2024-02-27 ******************************* please use my DELIMITED TEXT READER component […]
Extract File Name from Path
Returns the following from a Path column (String) File Path (String) File Name without extension (String) File Extension (String) Parent Folder […]
First and Last for Group
For a given group column, appends two boolean columns IS_FIRST_IN_GROUP and IS_LAST_IN_GROUP which mark the first and the last row in the current sorted […]
Fix Table After Column Append
Fixes tables that have been generated with repeated (#Iter ) columns following Loop End Column Append This reduces the columns to the required original set […]
Flexible Date Reader
A flexible date reader. This component will attempt to read dates in a variety of free-text formats. The only requirement is that the Day Month and Year […]