Import EXCEL - a meta workflow trying to answer questions about importing data from Excel files

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