Skip to main content

Read XLS

This task will allow you to read an Excel file very easily.

main

Input file path
Full Path to the XLS file you want to read. If "Input file path" is empty, Excel reader will use the first Excel reader task as input value. This would be useful if you want to iterate on sheets and then on rows.

Example: Cascading Excel reader tasks​

Sheet iterator would open the Excel file and Rows iterator will iterate on current sheet rows.

sample1

Iterate On
Excel Read can iterate on sheets, rows or columns. Each one generated some variables in context:

  • sheets
    • sheet (object) see ReadTheDocs for reference.
    • sheet_index
    • sheet_name

Accessing a single cell directly​

You may want to get direct access to a cell. Here is the way to address a cell directly.

sheet.cell(1, 0).value