Workflow Entry: Spreadsheet Import Example

Created at: 12/07/11 @ 13:57:34 Last updated: 12/07/11 @ 13:57:36

Version 1 (of 1)

Version created on: 12/07/11 @ 13:57:34 by: Alan Williams | Revision comments Expand

Title: Spreadsheet Import Example

Type: Taverna 2

Preview

(Click on the image to get the full size)

Download Scalable Diagram (SVG)

Description

Example using the SpreadsheetImport service to import data from an Excel spreadsheet. The workflow imports the file spreadsheet file WaterUse.xlsx and generates a graph from the date. The source data is from http://data.gov.uk/

Download

Download Workflow File/Package (T2FLOW)

Download Workflow as a Galaxy tool

Run

Run this Workflow in the Taverna Workbench...

Option 1:

Copy and paste this link into File > 'Open workflow location...'
http://www.myexperiment.org/workflows/2218/download?version=1
[ More Info Expand ]

Workflow Components

Authors (1)

Titles (1)

Descriptions (1)

Inputs (0)

Processors (5)

Name	Type	Description
SpreadsheetImport	spreadsheet
GenerateGraphURL	beanshell
Get_Image_From_URL	localworker
Beanshell	beanshell
url_value	stringconstant

Beanshells (2)

Name	Description	Inputs	Outputs
GenerateGraphURL		title data headers years	graphURL
Beanshell		year electricity fish_farming public_water_supply	data headers years

Outputs (1)

Name	Description
graph

Datalinks (10)

Source	Sink
url_value:value	SpreadsheetImport:fileurl
Beanshell:data	GenerateGraphURL:data
Beanshell:headers	GenerateGraphURL:headers
Beanshell:years	GenerateGraphURL:years
GenerateGraphURL:graphURL	Get_Image_From_URL:url
SpreadsheetImport:year	Beanshell:year
SpreadsheetImport:electricity	Beanshell:electricity
SpreadsheetImport:fish_farming	Beanshell:fish_farming
SpreadsheetImport:public_water_supply	Beanshell:public_water_supply
Get_Image_From_URL:image	graph