Hub

21 results

Filter
Sheet
Excel Loop XLS Reading Data Import Openpyxl Data access Knime
  1. Workflow
    Read an XLS file
    Reading XLS Excel
    +7
    This workflow demonstrates how to read an XLS file using the XLS Reader node. It contains three workflows. The goal of each workf…
    knime > Examples > 01_Data_Access > 01_Common_Type_Files > 07_Reading_Excel_Files
    3
    knime
  2. Workflow
    Read all sheets from an XLS file in a loop
    Reading Excel XLS
    +2
    This workflow demonstrates how to read all sheets from an XML file using the XML Reader node together with the Read XLS Sheet Nam…
    knime > Examples > 01_Data_Access > 01_Common_Type_Files > 05_Read_all_sheets_from_an_XLS_file_in_a_loop
    2
    knime
  3. Workflow
    use R's openxlsx to add a worksheet to an existing Excel file with a macro .xlsm
    Openxlsx Xlsm Macro
    +5
    it is possible to use R’s openxlsx to add sheets from within KNIME to an existing Excel file which contains Macros.. With newer E…
    mlauber71 > Public > kn_example_excel_macros_xlsm
    1
    mlauber71
  4. Workflow
    Import EXCEL - a meta workflow trying to answer questions about importing data from Excel files
    Excel Import Sheet
    +17
    Import EXCEL - This workflow will act as a meta workflow trying to answer questions about importing data from Excel files One of …
    mlauber71 > Public > kn_example_excel_import_meta_workflow
    1
    mlauber71
  5. Workflow
    m_001_import_r_excel_unite_fields
    R Excel Knime
    +8
    use R to list excel sheet names, extract the data and keep only columns that are present in all sheets use R package readxl to li…
    mlauber71 > Public > kn_example_r_excel_find_united_fields > m_001_import_r_excel_unite_fields
    0
    mlauber71
  6. Workflow
    use R to list excel sheet names
    R Excel Knime
    +4
    use R package readxl to list all sheets of excel files from a folder
    mlauber71 > Public > kn_example_r_excel_multiple_sheets > m_001_import
    0
    mlauber71
  7. Workflow
    use KNIME and Python OpenPyxl to read the index numbers of every sheet in an Excel file. Then use the index numbers to import the files back
    KNIME Python Openpyxl
    +3
    use KNIME and Python OpenPyxl to read the index numbers of every sheet in an Excel file. Then use the index numbers to import the…
    mlauber71 > Public > kn_example_python_excel_sheet_index
    0
    mlauber71
  8. Workflow
    Read an XLS file
    Reading XLS Excel
    +7
    This workflow demonstrates how to read an XLS file using the XLS Reader node. It contains three workflows. The goal of each workf…
    wardsl > Public > 07_Reading_Excel_Files
    0
    wardsl
  9. Workflow
    008_Loops - 1
    Loop Sheet Collect
    +3
    Table Row To Variable Loop example - reading Excel sheets in a loop and collectiong results. Checked for update: 6.4.2021 Updated…
    laufi > Public > 008_Loops - 1
    0
    laufi
  10. Workflow
    use KNIME and Python OpenPyxl to read the index numbers of every sheet in an Excel file - then move a sheet from one index position to a new one
    KNIME Python Openpyxl
    +5
    use KNIME and Python OpenPyxl to read the index numbers of every sheet in an Excel file - then move a sheet from one index positi…
    mlauber71 > Public > kn_example_python_excel_sheet_move_to_position
    0
    mlauber71
  11. Workflow
    Read an XLS file
    Reading XLS Excel
    +7
    This workflow demonstrates how to read an XLS file using the XLS Reader node. It contains three workflows. The goal of each workf…
    haoran > Public > 01_Data_Access > 01_Common_Type_Files > 07_Reading_Excel_Files
    0
    haoran
  12. Workflow
    Read an XLS file
    Reading XLS Excel
    +7
    This workflow demonstrates how to read an XLS file using the XLS Reader node. It contains three workflows. The goal of each workf…
    williamb > Internal Audit - Analytics > 07_Reading_Excel_Files
    0
    williamb
  13. Workflow
    Read all sheets from an XLS file in a loop
    Reading Excel XLS
    +2
    This workflow demonstrates how to read all sheets from an XML file using the XML Reader node together with the Read XLS Sheet Nam…
    haoran > Public > 01_Data_Access > 01_Common_Type_Files > 05_Read_all_sheets_from_an_XLS_file_in_a_loop
    0
    haoran
  14. Workflow
    Excel Reader - force sheet_selection "NAME" with Flow variable
    Excel Sheet Name
    +3
    Excel Reader - force sheet_selection "NAME" with Flow variable
    mlauber71 > Forum > 2021 > kn_forum_38226_excel_sheet_force_name_read
    0
    mlauber71
  15. Workflow
    Loop thru same Excel sheet names from various sources and collect them back
    Excel Loop Sheets
    +4
    Loop thru same Excel sheet names from various sources and collect them back
    mlauber71 > Public > forum > kn_forum_27953_loop_multiple_excel_files
    0
    mlauber71
  16. Workflow
    use R's openxlsx to remove an existing worksheet from an Excel file
    Openxlsx Excel Load
    +5
    use R's openxlsx to remove an existing worksheet from an Excel file edit: warning! in this example from the first sheet "data1" s…
    mlauber71 > Public > kn_example_r_excel_remove_sheet
    0
    mlauber71
  17. Workflow
    use Python package openpyxl to remove an existing worksheet from an Excel file
    Excel Load Write
    +5
    use Python package openpyxl to remove an existing worksheet from an Excel file
    mlauber71 > Public > kn_example_python_excel_remove_sheet
    0
    mlauber71
  18. Workflow
    Collect data from 4 differet Excel files and put it into sheets of a single file
    Excel Import Sheet
    +2
    Collect data from 4 differet Excel files and put it into sheets of a single file
    mlauber71 > Forum > 2022 > kn_forum_42783_excel_multiple_files_into_sheets
    0
    mlauber71
  19. Workflow
    Read all sheets from an XLS file in a loop
    Reading Excel XLS
    +2
    This workflow demonstrates how to read all sheets from an XML file using the XML Reader node together with the Read XLS Sheet Nam…
    berolly > Public > 05_Read_all_sheets_from_an_XLS_file_in_a_loop
    0
    berolly
  20. Workflow
    Read the sheet names from an existing excel file and add the sheet name as a column and write to a new excel file
    Excel Import Sheet
    +2
    Read the sheet names from an existing excel file and add the sheet name as a column and write to a new excel file
    mlauber71 > Forum > 2022 > kn_forum_43376_excel_sheet_names_as_column
    0
    mlauber71