Components
This directory contains 224 workflows.
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 […]