Icon

is excel file already open

Is excel file already open?
This demo flow will attempt to writeto a filec:\temp\mytestfile.xlsxIf you need to test it with a different file location, you will need tochange that reference in both the initial Table Creatorand in the Excel Writer writes to c:\temp\mytestfile.xlsxOpens file in Excel after execution.If you reset the workflow and attempt to rerun without closing excelit should fail at the "Fail in execution" nodeMain Flow starts here"List" of files to test.in this demo it just containsc:\temp\mytestfile.xlsxTest for each filesin list ifit is unlockedReturns0=Unlocked-1=Not Found1=Lockedfor each fileLower port should contain norows if all files areunlockedDo we have locked files?Files(s) are lockedGets to hereonly if all files are not locked Excel Writer Table Creator Table Creator Java Snippet Row Splitter Empty Table Switch Fail in execution End IF This demo flow will attempt to writeto a filec:\temp\mytestfile.xlsxIf you need to test it with a different file location, you will need tochange that reference in both the initial Table Creatorand in the Excel Writer writes to c:\temp\mytestfile.xlsxOpens file in Excel after execution.If you reset the workflow and attempt to rerun without closing excelit should fail at the "Fail in execution" nodeMain Flow starts here"List" of files to test.in this demo it just containsc:\temp\mytestfile.xlsxTest for each filesin list ifit is unlockedReturns0=Unlocked-1=Not Found1=Lockedfor each fileLower port should contain norows if all files areunlockedDo we have locked files?Files(s) are lockedGets to hereonly if all files are not lockedExcel Writer Table Creator Table Creator Java Snippet Row Splitter Empty Table Switch Fail in execution End IF

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: @takbb Brian Bates
Created at: 2021-06-01
On NodePit since: 2021-06-01
Last update: 2024-04-29
Created with KNIME version: v4.3.3
Tags: File LockedFile Unlocked

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

Try NodePit Runner!