Taverna offers a spreadsheet import service that allows you to import Excel or csv spreadsheets and feed the content into your workflow. To import a spreadsheet into your workflow, simply add the SpreadsheetImport service to your workflow (either drag it from the Service Panel into the Workflow Diagram or Explorer, or right-click on it in the Service Panel and select Add to workflow).
When you add the 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 SpreadsheetImport service takes as input the file path or URL to an Excel spreadsheet. 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.