Icon

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 […]