Hub

16 results

Filter
Sheet
Excel
Loop XLS Import Reading Data
+3
  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
  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
  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
  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
  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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. Workflow
    Append data to an existing Excel file with the help of Python Pandas and OpenPyxl
    Excel File Sheet
    +5
    Append data to an existing Excel file with the help of Python Pandas and OpenPyxl
    mlauber71 > Public > forum > kn_forum_29528_python_excel_append_to_existing_sheet
    0
  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
  13. 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
  14. 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
  15. 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
  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