Icon

07_​Reading_​Excel_​Files

Read an XLS file
This workflow consists of 3 workflows, each reading accounting data from a restaurant business. Each workflow is different according to how data are stored in the .xls file.For more information see the workflow metadata. Find it here: View -> Description All accounting data are stored in one sheet of a single Excel file. One single Excel Reader node is enough to read all data. Accounting data are stored in one different sheet for each month. You have to Loop through all Sheet names to read the content from allsheets. Accounting data are stored in one different file for each month. You have to loop on all Excel files in a folder, loop through all Sheet names ineach Excel file to read the content from all sheets in all Excel files. Read all Sheetnames from fileTotal revenueby monthto DateTimeExtract monthLoop through sheetsto DateTimeExtract monthTotal revenueby monthTotal revenueby monthLoop throughsheetsExtract monthto DateTimeRead all Sheetnames from fileList all thefiles in a folderLoop throughfilesRead default sheetfrom one Excel file Read default sheet from one Excel file Read default sheet from one Excel file Read Excel SheetNames (XLS) GroupBy String to Date&Time Extract Date&TimeFields Table Row ToVariable Loop Start Loop End String to Date&Time Extract Date&TimeFields GroupBy GroupBy Table Row ToVariable Loop Start Extract Date&TimeFields String to Date&Time Read Excel SheetNames (XLS) Loop End List Files Table Row ToVariable Loop Start Loop End Excel Reader (XLS) Excel Reader (XLS) Excel Reader (XLS) This workflow consists of 3 workflows, each reading accounting data from a restaurant business. Each workflow is different according to how data are stored in the .xls file.For more information see the workflow metadata. Find it here: View -> Description All accounting data are stored in one sheet of a single Excel file. One single Excel Reader node is enough to read all data. Accounting data are stored in one different sheet for each month. You have to Loop through all Sheet names to read the content from allsheets. Accounting data are stored in one different file for each month. You have to loop on all Excel files in a folder, loop through all Sheet names ineach Excel file to read the content from all sheets in all Excel files. Read all Sheetnames from fileTotal revenueby monthto DateTimeExtract monthLoop through sheetsto DateTimeExtract monthTotal revenueby monthTotal revenueby monthLoop throughsheetsExtract monthto DateTimeRead all Sheetnames from fileList all thefiles in a folderLoop throughfilesRead default sheetfrom one Excel file Read default sheet from one Excel file Read default sheet from one Excel file Read Excel SheetNames (XLS) GroupBy String to Date&Time Extract Date&TimeFields Table Row ToVariable Loop Start Loop End String to Date&Time Extract Date&TimeFields GroupBy GroupBy Table Row ToVariable Loop Start Extract Date&TimeFields String to Date&Time Read Excel SheetNames (XLS) Loop End List Files Table Row ToVariable Loop Start Loop End Excel Reader (XLS) Excel Reader (XLS) Excel Reader (XLS)

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-05-28
Last update: 2024-11-21
Created with KNIME version: v4.1.0
Tags: readingXLSexcelloopdatadata accesssheetmultiple sheetmultiple filesloop reading

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

Try NodePit Runner!