Hello everybody,
David Withers who is currently working with the BioMoby Consortium has
developed an Excel spreadsheet plugin for Taverna 2.1 beta 2. The plugin
can read Excel (.xls), Excel 2007 / OOXML (.xlsx) and OpenOffice / ODF
(.ods) files. It currently cannot read .xls files from Office 2008 (for
Mac).
To enable the plugin, go to Advanced -> Updates and plugins. Click on
Find new plugins. Tick the box for Taverna 2 Spreadsheet 0.2.0 and click
Close.
When you restart Taverna 2.1 beta 2, you will have a new type of Service
template called SpreadsheetImport. To import a spreadsheet into your
workflow, simply add the SpreadsheetImport service to your workflow. (To
add a service either drag it from the service panel into the workflow
diagram or explorer, or right-click on it in the service panel.)
When you add the service to your workflow, you can configure how it
deals with the rows and columns from the spreadsheet:
* selecting 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.
We are interested in any comments you have on the plugin, including
requests for additional functionality. Someone has already suggested
reading in csv files.
Thanks to David for his good work,
Alan
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
taverna-users mailing list
[email protected]
[email protected]
Web site: http://www.taverna.org.uk
Mailing lists: http://www.taverna.org.uk/taverna-mailing-lists/
