Icon

kn_​forum_​38226_​excel_​sheet_​force_​name_​read

Excel Reader - force sheet_selection "NAME" with Flow variable

Excel Reader - force sheet_selection "NAME" with Flow variable



URL: original file from forum https://forum.knime.com/t/bug-or-no-bug-excel-reader-preconfigured-work-sheet-selection-options/38226/2?u=mlauber71
URL: forum entry https://forum.knime.com/t/bug-or-no-bug-excel-reader-preconfigured-work-sheet-selection-options/38226/7?u=mlauber71
URL: Ticket AP-18133 https://forum.knime.com/search?q=AP-18133%20order%3Alatest

Excel Reader - force sheet_selection "NAME" with Flow variable seach *.xlsxin /data/ folderOUTER LoopStartINNER LOOPEndread Excel filewithNAMEed sheetforce sheet_selection as "NAME"INNER LOOPStartOUTER LoopEndSheetvar_sheet_selectionreturn "NAME"; List Files/Folders Table Row ToVariable Loop Start Loop End Excel Reader Read ExcelSheet Names Table Row ToVariable Loop Start Loop End ConstantValue Column Java EditVariable (simple) Excel Reader - force sheet_selection "NAME" with Flow variable seach *.xlsxin /data/ folderOUTER LoopStartINNER LOOPEndread Excel filewithNAMEed sheetforce sheet_selection as "NAME"INNER LOOPStartOUTER LoopEndSheetvar_sheet_selectionreturn "NAME";List Files/Folders Table Row ToVariable Loop Start Loop End Excel Reader Read ExcelSheet Names Table Row ToVariable Loop Start Loop End ConstantValue Column Java EditVariable (simple)

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: lars.schweikardt
Created at: 2021-12-15
On NodePit since: 2021-12-18
Last update: 2024-05-01
Created with KNIME version: v4.7.8
Tags: excelsheetnameforceflowvariable

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

Try NodePit Runner!