Excel Cell Formula Writer
This directory contains 6 workflows.
Demo - Excel Cell Formula writing - single cell
Demonstration of my Write Excel Cell Formula component, which will write an excel formula directly to a single cell in a spreadsheet
Excel Cell Formula Expander
This is used to create an instruction table for use by the "Write Excel Formula (multi-cell) component. Takes a table consisting of […]
Grouped Row Splitters
Demo workflow for using Grouped Regex Row Splitter components. Each row splitter can return groups of rows matching a number of regex patterns. For […]
Write Excel Cell Formula
Writes a simple formula into a named cell in an existing XLSX spreadsheet. Note that it will not be able to write to a spreadsheet that is currently open […]
Write Excel Cell Formula (multi cell)
Writes a set of formula into a list of named cells in an existing XLSX spreadsheet. The input table should consist of two columns. The first is the list […]
Write Value to Single Excel Cell
Simplified demo of Write Excel Cell Formula component. This writes the value of a flow variable containing a calculated total into cell E2, and a […]