One of the most asked questions is the one how to import data from Excel files under various circumsatnces 050 - the (new) excel import node can also handle multiple files at once from a single folder - you may want to start with that https://hub.knime.com/knime/extensions/org.knime.features.ext.poi/latest/org.knime.ext.poi2.node.read4.XLSReaderNodeFactory 100 - the standard import - Read an XLS file - by scottf https://hub.knime.com/knime/spaces/Examples/latest/01_Data_Access/01_Common_Type_Files/07_Reading_Excel_Files => most of the time you will just be fine using these examples 150 - OK you have a changing structure of your Excel files but still want to read them, no problem, just give the collecting end loop some flexibility https://forum.knime.com/t/how-to-read-multiple-excel-files-in-a-folder-and-multiple-sheets-in-an-excel-file/10723/9?u=mlauber71 170 - and you want to keep some information about the file you jus imported. You could annotate them with the name of the file/sheet https://forum.knime.com/t/can-knime-help-me-input-words-in-excel-automatically/25071/5?u=mlauber71 Read and annotate multiple Excel files https://kni.me/w/32TRHcgHTUeWoUup 175 - another example extracting some information about your Excel file and location https://hub.knime.com/mlauber71/spaces/Public/latest/forum/kn_forum_excel_read_multiple_files_and_sheets ------------------- some more complicated scenarios that can be solved easily with the help of R ----------- 550 - you want to import a lot of data from various excel sheets and only keep the ones that are present in all sheets https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_r_excel_find_united_fields/m_001_import_r_excel_unite_fields https://forum.knime.com/t/reading-excel-sheets-with-different-column-counts-and-different-data-types/19245/2?u=mlauber71
This is a companion discussion topic for the original entry at https://kni.me/w/BxiMlBJ2jYCPlZnS