Read XLS Task

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

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.

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