Hub

288 results

Filter
Excel
Data access Csv Table Education E-learning
+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
    Financial Reporting Variance Analysis
    Variance analysis Excel Finance
    +9
    This workflow demonstrates a typical variance analysis report created by Finance teams. The process identifies corresponding Exce…
    supersharp > Finance, Accounting and Audit Automation > Financial Reporting Variance Analysis > Financial Reporting Variance Analysis
    2
  3. 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
  4. Workflow
    kn_forum_transpose_excel_questions
    Excel Transpose Loop
    +2
    Transpose with multiple sheets without duplicating columns ---------- Hi there - I am trying to combine several versions of the s…
    mlauber71 > Public > forum > kn_forum_transpose_excel_questions
    1
  5. 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
  6. Workflow
    Update User Loan Information
    Excel File Handling
    This workflow concentrates on the basic functionality of KNIME Excel Cell Updater Node. This example workflow demonstrates how ba…
    knime > Examples > 01_Data_Access > 01_Common_Type_Files > 18_Basic_Example_Excel_Cell_Update
    1
  7. Workflow
    Reading and transforming multiple Excel files from a ZIP archive
    Decompress Excel ETL
    +1
    This workflow demonstrates how to read and transform multiple files with similar file structure.
    knime > Examples > 01_Data_Access > 01_Common_Type_Files > 13_Reading and transforming multiple Excel files from a ZIP archive
    1
  8. Workflow
    Excel Files Manipulations
    Excel
    This workflow splits data from one Excel file based on departmentID and appends each set to existing excel files which contain th…
    ipazin > Public > 2019_08_22_Excel_Files_Manipulations
    1
  9. Workflow
    Read binary Excel Files (.xlsb) wit the help of Python package "pyxlsb"
    Python Excel Xlsb
    +3
    Read binary Excel Files (.xlsb) wit the help of Python package "pyxlsb" conda install -c conda-forge pyxlsb
    mlauber71 > Public > kn_example_python_excel_xlsb
    1
  10. Workflow
    Download zip folder with multiple files from temp folder
    Zip Temp Folder
    +1
    Download zip folder with multiple files from temp folder
    mlauber71 > Forum > 2022 > kn_forum_43389_zip_temporary_folder_download
    1
  11. Workflow
    Extracting Minimum and corresponding Index
    Excel Column Names
    This workflow demonstrates how to extract Index (Column Name) after calculating minimum value from selected columns. Two option a…
    ipazin > Public > 2019_08_14_ExtractingMinimum&IndexFromColumns
    1
  12. 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
  13. Workflow
    01 Read Data from File
    Csv Data access Excel
    +1
    Exercise for reading data from a file
    knime > Education > Self-Paced Courses > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 01 Read Data from File
    1
  14. Workflow
    KNIME - openpyxl and xlsxwriter to add formulas to excel files
    Xlsxwriter Excel Python
    +1
    use python package openpyxl to add formulas to excel files
    mlauber71 > Public > kn_example_python_excel_enter_formula
    1
  15. Workflow
    Write three files in one Excel file on three sheets
    Writing Sheets XLS
    +6
    This workflow demonstrates how to write three files in one Excel file on three sheets. It separates values in different sheets ba…
    knime > Examples > 01_Data_Access > 01_Common_Type_Files > 09_Multiple_Sheet_in_one_Excel_File
    1
  16. Workflow
    01 Read Data from File
    Csv Data access Excel
    +1
    Exercise for reading data from a file
    cpiraqu > Public > 01 Read Data from File
    0
  17. Workflow
    01 Read Data from File
    Csv Data access Excel
    +1
    Exercise for reading data from a file
    falconjd37 > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 01 Read Data from File
    0
  18. Workflow
    01 Read Data from File
    Csv Data access Excel
    +1
    Exercise for reading data from a file
    froilan_sia > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 01 Read Data from File
    0
  19. Workflow
    01 Read Data from File
    Csv Data access Excel
    +1
    Exercise for reading data from a file
    kellytm2 > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 01 Read Data from File
    0
  20. Workflow
    01 Read Data from File
    Csv Data access Excel
    +1
    Exercise for reading data from a file
    the32bitphoenix > Public > Excercises 1 - Data Wrangler Beginner > 01 Read Data from File
    0