Hello, What is the difference between this spreadsheet parser and a table parser - i.e. does it support functions and formulae? Is it possible to integrate this as an output view, so that I can view my results in a spreadsheet and then perform some trivial formulae on columns and rows (e.g. calculating the genetic distance between two points on a chromosome from two columns in my results, or ordering a column by a value - as you would in Excel) ??
cheers, Paul. Alan Williams wrote: > 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/ > ------------------------------------------------------------------------------ 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/
