Hub

55 results

Filter
XLS
Data access Education Import Csv Read Table Excel ETL
  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
    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
  3. Workflow
    Format Multiple Excel Sheets
    Workflow Snippet XLS Formatting
    +1
    This workflow snippet provides you with an example of how you can set up a loop that iterates over each sheet in a file and use a…
    knime > Workflow Snippets > Format Multiple Excel Sheets
    1
    knime
  4. 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
  5. 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
  6. Workflow
    Importing Data
    Data access Import Csv
    +6
    "Importing Data" exercise for basic Life Science User Training - Import data from three different file formats (table, csv, xls)
    pau22nanda > Public > L1-LS KNIME Analytics Platform for Data Scientists - Life Sciences - Basics > Exercises > 01. Importing Data
    0
    pau22nanda
  7. Workflow
    Importing Data
    ETL Data access Import
    +7
    Exercise 1 for KNIME User Training - Import data from three different file formats (table, csv, xls) - Import data from SQLite da…
    morpheustm > Public > EU_Scholarship > Day1 > 00_GetStart > 01_Importing Data
    0
    morpheustm
  8. Workflow
    Importing Data
    Data access Import Csv
    +6
    "Importing Data" exercise for basic Life Science User Training - Import data from three different file formats (table, csv, xls)
    ciaccindr > Public > Corso2022 > L1-LS > Exercises > 01. Importing Data
    0
    ciaccindr
  9. Workflow
    Styling Excel Tables
    Excel Customization XLS
    +2
    Exercise 12 for the KNIME Analytics Platform for Data Wranglers course - Write data in a Excel file - Define styling operations o…
    ana_ved > L2-DW 3.3 > L2-DW KNIME Analytics Platform for Data Wranglers - Advanced 2 > Exercises > 12_Styling_Excel_Tables
    0
    ana_ved
  10. Workflow
    Styling Excel Tables
    Excel Customization XLS
    +2
    Exercise 12 for the KNIME Analytics Platform for Data Wranglers course - Write data in a Excel file - Define styling operations o…
    tenalf > Public > L2-DW KNIME Analytics Platform for Data Wranglers - Advanced > Exercises > 12_Styling_Excel_Tables
    0
    tenalf
  11. Workflow
    How to force column data type in “Excel Reader (XLS)” node?
    Excel Xls Xlsx
    +4
    I built a workflow that uses your idea and does three imports of an Excel file, one all numeric, one all strings and one guess. F…
    mlauber71 > Public > forum > kn_example_r_readxl > m_001_r_readxl
    0
    mlauber71
  12. Workflow
    Importing Data - Solution
    ETL Data access Import
    +8
    Solution to the exercise 1 for KNIME User Training - Import data from three different file formats (table, csv, xls) - Import dat…
    mprof9 > Public > L1-DS KNIME Analytics Platform for Data Scientists - Basics > solutions > 01. Importing Data - solution
    0
    mprof9
  13. Workflow
    Write three files in one Excel file on three sheets
    Writing Sheets XLS
    +4
    This workflow demonstrates how to write three files in one Excel file on three sheets. It separates values in different sheets ba…
    jobyjosek1 > Public > 09_Multiple_Sheet_in_one_Excel_File
    0
    jobyjosek1
  14. Workflow
    Importing Data
    ETL Data access Import
    +7
    Exercise 1 for KNIME User Training - Import data from three different file formats (table, csv, xls) - Import data from SQLite da…
    pau22nanda > Public > L1-DS KNIME Analytics Platform for Data Scientists - Basics > exercises > 01. Importing Data
    0
    pau22nanda
  15. Workflow
    Importing Data - Solution
    ETL Data access Import
    +8
    Solution to the exercise 1 for KNIME User Training - Import data from three different file formats (table, csv, xls) - Import dat…
    vfarmak > Public > 01. Importing Data - solution
    0
    vfarmak
  16. 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…
    haoran > Public > 01_Data_Access > 01_Common_Type_Files > 09_Multiple_Sheet_in_one_Excel_File
    0
    haoran
  17. Workflow
    Importing Data
    ETL Data access Import
    +7
    Exercise 1 for KNIME User Training - Import data from three different file formats (table, csv, xls) - Import data from SQLite da…
    sabikahumais > Public > 01. Importing Data
    0
    sabikahumais
  18. 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
    wardsl
  19. Workflow
    Importing Data
    Data access Import Csv
    +6
    "Importing Data" exercise for basic Life Science User Training - Import data from three different file formats (table, csv, xls)
    knime > Education > Courses > L1-LS KNIME Analytics Platform for Data Scientists - Life Sciences - Basics > Exercises > 01. Importing Data
    0
    knime
  20. Workflow
    Importing Data
    Data access Import Csv
    +6
    Solution to "Importing Data" exercise for basic Life Science User Training - Import data from three different file formats (table…
    pau22nanda > Public > L1-LS KNIME Analytics Platform for Data Scientists - Life Sciences - Basics > Solutions > 01. Importing Data - solution
    0
    pau22nanda