Reading Excel Files

This workflow demonstrates how to read an XLS file using the XLS Reader node. It contains 3 workflows. The goal of each workflow is to read accounting data from a restaurant business for all months in 2016 and to calculate the total revenues for each month. 1. All accounting data are stored in one sheet of a single Excel file. One single Excel Reader node is enough to read all data. 2. Workflow 2 reads data from all sheets in an Excel file using the Read Excel Sheet Names node, a loop, and the Excel Reader node 3. Workflow 3 reads data from all sheets of all Excel files present in a folder. Here we use the List Files node, we loop on the list of files, we use the Read Excel Sheet Names node, we loop on the list of sheets, and we read the data from each sheet.

Reading Excel Files

 

Resources

EXAMPLES Server: 01_Data_Access/01_Common_Type_Files/07_Reading_Excel_Files01_Data_Access/01_Common_Type_Files/07_Reading_Excel_Files*
Download a zip-archive

Video:

 

 


* Find more about the Examples Server here.
The link will open the workflow directly in KNIME Analytics Platform (requirements: Windows; KNIME Analytics Platform must be installed with the Installer version 3.2.0 or higher). In other cases, please use the link to a zip-archive or open the provided path manually