Icon

05_​Read_​all_​sheets_​from_​an_​XLS_​file_​in_​a_​loop

Read all sheets from an XLS file in a loop
This workflow reads all the sheets of an XML file using a loop. Collects readsheetsCreates variablesfrom the rowsReads the sheetnames from iris.xlsSet flow variable to sheetNode 11Node 13Node 14Node 16Collects readsheetsSet flow variable to sheetNode 19Creates variablesfrom the rowsNode 21Node 35Node 36Node 37Node 38Node 39Node 40Node 42Node 43Node 44Node 46 Loop End Table Row ToVariable Loop Start Read Excel SheetNames (XLS) Excel Reader (XLS) Cell Replacer String Manipulation String Manipulation Rule-basedRow Filter Loop End Excel Reader (XLS) Rule-basedRow Filter Table Row ToVariable Loop Start Rule-basedRow Splitter String to Date&Time Concatenate Column Rename Column Rename String To Number String To Number Rule-basedRow Filter String to Date&Time Color Manager Scatter Plot(Plotly) Stacked AreaChart (Plotly) This workflow reads all the sheets of an XML file using a loop. Collects readsheetsCreates variablesfrom the rowsReads the sheetnames from iris.xlsSet flow variable to sheetNode 11Node 13Node 14Node 16Collects readsheetsSet flow variable to sheetNode 19Creates variablesfrom the rowsNode 21Node 35Node 36Node 37Node 38Node 39Node 40Node 42Node 43Node 44Node 46Loop End Table Row ToVariable Loop Start Read Excel SheetNames (XLS) Excel Reader (XLS) Cell Replacer String Manipulation String Manipulation Rule-basedRow Filter Loop End Excel Reader (XLS) Rule-basedRow Filter Table Row ToVariable Loop Start Rule-basedRow Splitter String to Date&Time Concatenate Column Rename Column Rename String To Number String To Number Rule-basedRow Filter String to Date&Time Color Manager Scatter Plot(Plotly) Stacked AreaChart (Plotly)

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: oole
Created at: 2016-05-02
On NodePit since: 2021-01-19
Last update: 2024-04-16
Created with KNIME version: v4.1.4
Tags: readingexcelXLSloopsheet

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

Try NodePit Runner!