Hub

343 results

Filter
Excel
Data access Csv Table Education XLS Database SQLite Sheet
  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
    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
    supersharp
  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
    knime
  4. Workflow
    UK Final Energy Consumption
    Excel Data Prep Energy
    +2
    Revamp of the BEIS Excel report on final energy consumption in the UK, turning it into a more exploitable data source to create a…
    msergent > Public > UK Final Energy Consumption
    1
    msergent
  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
    mlauber71
  6. 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
    ipazin
  7. 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
    ipazin
  8. 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
    mlauber71
  9. 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
    knime
  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
    mlauber71
  11. 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
  12. 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
    knime
  13. Workflow
    01 Read Data from File
    Csv Data access Excel
    +1
    Exercise for reading data from a file
    knime > Education > Self-Paced Courses > Archive > L1-DW KNIME Analytics Platform for Data Wranglers - Basics (deprecated) > Exercises > 01 Read Data from File
    1
    knime
  14. Workflow
    20220810 Pikairos Read Excel 97-2003 XML Spreadsheet 2003 files
    Excel 97-2003 XLSX Excel
    This workflow shows how to read several simple Excel files in Excel 97-2003 (XML) format and how to convert them in current XLSX …
    pikairos > Public > 20220810 Pikairos Read Excel 97-2003 XML Spreadsheet 2003 files
    1
    pikairos
  15. Workflow
    Data Access - Exercise
    Csv Data access Education
    +3
    This workflow shows a hands-on exercise in the L1-DS Introduction to KNIME Analytics Platform for Data Scientists - Basics course
    knime > Education > Self-Paced Courses > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Exercises > 01 Data Access
    1
    knime
  16. Workflow
    Tool Migration: From Excel to Value with KNIME
    Automation Excel Machine Learning
    +4
    This workflow shows how using a no-code/low-code tool like KNIME Analytics Platform can substitute, expand and improve considerab…
    roberto_cadili > Public > Tool Migration - From Excel to Value with KNIME
    1
    roberto_cadili
  17. 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
    mlauber71
  18. 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
    mlauber71
  19. 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
    knime
  20. Workflow
    01 Read Data from File - Solution
    Csv Data access Excel
    +1
    Solution to an exercise for reading data from a file CHECK YOUR ANSWERS: a. The reader nodes to use are Excel Reader, CSV Reader/…
    pau22nanda > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 01 Read Data from File - Solution
    0
    pau22nanda