This action retrieves data from multiple rows in a sheet in an
Excel file (all non-empty rows following the table's title row)
and returns multiple data structures, each containing the content
of one of the retrieved rows.
The action's template has three triggers:
<File> (non-repetitive trigger [required]):
The content of an Excel file (e.g. the output of Read
<Sheet Name> (non-repetitive trigger [not
required]): The name of the sheet in the file from which
data is retrieved (if missing, the first sheet in the file is used
<Skip Unmatching Rows> (non-repetitive Boolean
trigger [not required]): If true, erroneous data rows are
ignored (as if they were empty). The default (if the trigger is
missing) is not to tolerate erroneous rows.
<Rows> (repetitive or non-repetitive exit
[required]): The retrieved records (each output item is a
data structure containing the content of one of the retrieved
rows), or just the first record if the exit is non-repetitive.
The data type of <Rows> defines the structure of
the loaded table:
"Tutorial 10-11/Purchaser/Manage Suppliers/Import Suppliers
Data/Select Suppliers Spreadsheet/Import/Extract Spreadsheet Rows"
10 of the tutorial):
This plug-in is using the POI-HSSF package
(part of the Apache Jakarta project) for accessing .XLS (Excel
2003 and earlier) files. .XLSX (Excel 2007 and later) files are
not supported. You may also encounter problems working with .XLS
files not created by Microsoft's Excel (e.g. reading the file
might take a very long time).
For best results, use the Firefox browser..