Spreadsheet Import service allows you to import Excel or csv spreadsheets and feed their content into other services in your workflow.
Adding a Spreadsheet Import
- Expand Service templates under Available services in the Service Panel.
- Select Spreadsheet Import Service.
- Drag and drop the Spreadsheet Import to the Workflow Diagram.
- In a dialog that pops up, configure the Spreadsheet Import as explained next.
 | Note that you can add a Spreadsheet Import service from the Insert menu as well. |
Configuring a Spreadsheet Import
When you add a Spreadsheet Import service to your workflow, you can configure how it deals with the rows and columns from the spreadsheet:
• Select which rows and columns to output
• How to deal with empty cells
• Whether to include the header row, and
• What name to use for the data from a given column
A Spreadsheet Import service takes the file path or URL to an Excel spreadsheet as input. It has an output port for each selected column; data for the selected rows of the column is output from the port in row order.
