Hub

469 results

Filter
Filter by tag
Excel
Data access Table Csv Education Database Read Import SQLite
  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
    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
    2
    roberto_cadili
  3. 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
    2
    pikairos
  4. 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
    2
    mlauber71
  5. 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
  6. 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
    2
    mlauber71
  7. 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
  8. Workflow
    kn_forum_26510_excel_single_file_loop
    Excel Split Tables
    +4
    Extract a group of smaller tables (identifyed by a keyword) from Excel file with some empty columns and store them in separate ne…
    mlauber71 > Public > forum > kn_forum_26510_excel_single_file_loop
    1
    mlauber71
  9. 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
  10. 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
  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
    ipazin
  12. 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
  13. 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
  14. Workflow
    Read all sheets from Google Sheet & Excel with loop nodes
    Google Sheet XLS Loop
    +3
    This workflow demonstrate how to read all the sheets (or selected sheets) from a Google Sheet or an Excel sheet along with the lo…
    yemunn_soe_ydsc > Public > Read all sheets from Google Sheet & Excel with loop nodes
    1
    yemunn_soe_ydsc
  15. Workflow
    Pivot Table
    Spreadsheet Excel
    A pivot table aims to arrange a table so that other stakeholders can easily share and understand data. Let's walk through the dif…
    knime > KNIME for Spreadsheet Users > Pivot Table
    1
    knime
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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