Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Search

288 results

Filter
Excel
Data access Csv Table Education E-learning
+3
  1. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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. Go to item
    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

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits