Icon

FileAndSheetNameWithDateAndTime

Excel file and sheet name generation with todays date and time
Same nodes as above but with dynamic file system ports to work with the available file system connectors Running example using the workflow data area Folder to storethe files infile name with dateand sheet name with timeUse variablesfor file and sheetnamescombine sheetnames into listNode 9file name with dateand sheet name with timecombine sheetnames into listFolder to storethe files inUse variablesfor file and sheetnamesNode 16 List Files/Folders Column Expressions Excel Writer Your data Table Rowto Variable Column Aggregator SharePointOnline Connector Table Rowto Variable Column Expressions Column Aggregator List Files/Folders Excel Writer Your data MicrosoftAuthentication Same nodes as above but with dynamic file system ports to work with the available file system connectors Running example using the workflow data area Folder to storethe files infile name with dateand sheet name with timeUse variablesfor file and sheetnamescombine sheetnames into listNode 9file name with dateand sheet name with timecombine sheetnames into listFolder to storethe files inUse variablesfor file and sheetnamesNode 16List Files/Folders Column Expressions Excel Writer Your data Table Rowto Variable Column Aggregator SharePointOnline Connector Table Rowto Variable Column Expressions Column Aggregator List Files/Folders Excel Writer Your data MicrosoftAuthentication

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Tobias
Created at: 2021-09-07
On NodePit since: 2021-10-01
Last update: 2024-04-26
Created with KNIME version: v4.4.1
Tags: Excelfile handlingdateSharePoint

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!