Spreadsheet_Import_ExamplegraphGenerateGraphURLdata2headers1years1graphURL00net.sf.taverna.t2.activitiesbeanshell-activity1.3net.sf.taverna.t2.activities.beanshell.BeanshellActivity title 0 text/plain java.lang.String true data 2 text/plain java.lang.String true headers 1 text/plain java.lang.String true years 1 text/plain java.lang.String true graphURL 0 0 workflow net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeGet_Image_From_URLurl0image00net.sf.taverna.t2.activitieslocalworker-activity1.3net.sf.taverna.t2.activities.localworker.LocalworkerActivity url 0 'text/x-taverna-web-url' java.lang.String true base 0 'text/x-taverna-web-url' java.lang.String true image 0 'image/*' 0 workflow org.embl.ebi.escience.scuflworkers.java.WebImageFetcher net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeBeanshellareaHarvestedNJ1areaPlantedNJ1areaHarvestedNY1areaPlantedNY1year1data22headers11years11net.sf.taverna.t2.activitiesbeanshell-activity1.3net.sf.taverna.t2.activities.beanshell.BeanshellActivity areaHarvestedNY 1 text/plain java.lang.String true areaHarvestedNJ 1 text/plain java.lang.String true areaPlantedNY 1 text/plain java.lang.String true areaPlantedNJ 1 text/plain java.lang.String true year 1 text/plain java.lang.String true data 2 2 headers 1 1 years 1 1 workflow net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invokeurl_value_NJvalue00net.sf.taverna.t2.activitiesstringconstant-activity1.3net.sf.taverna.t2.activities.stringconstant.StringConstantActivity http://www.myexperiment.org/files/569/download/PS3-NJ-Broccoli.xls net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeSpreadsheetImport_2fileurl0areaHarvestedNY11areaPlantedNY11net.sf.taverna.t2.activitiesspreadsheet-import-activity1.3net.sf.taverna.t2.activities.spreadsheet.SpreadsheetImportActivity 0 2 4 10 NY A year B areaPlantedNY C areaHarvestedNY false false true EMPTY_STRING PORT_PER_COLUMN , net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeSpreadsheetImport_2_2fileurl0areaHarvestedNJ11areaPlantedNJ11year11net.sf.taverna.t2.activitiesspreadsheet-import-activity1.3net.sf.taverna.t2.activities.spreadsheet.SpreadsheetImportActivity 0 2 4 10 NJ A year B areaPlantedNJ C areaHarvestedNJ false false true EMPTY_STRING PORT_PER_COLUMN , net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invokeurl_value_NYvalue00net.sf.taverna.t2.activitiesstringconstant-activity1.3net.sf.taverna.t2.activities.stringconstant.StringConstantActivity http://www.myexperiment.org/files/570/download/PS3-NY-Broccoli.xls net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeGenerateGraphURLdataBeanshelldataGenerateGraphURLheadersBeanshellheadersGenerateGraphURLyearsBeanshellyearsGet_Image_From_URLurlGenerateGraphURLgraphURLBeanshellareaHarvestedNJSpreadsheetImport_2_2areaHarvestedNJBeanshellareaPlantedNJSpreadsheetImport_2_2areaPlantedNJBeanshellareaHarvestedNYSpreadsheetImport_2areaHarvestedNYBeanshellareaPlantedNYSpreadsheetImport_2areaPlantedNYBeanshellyearSpreadsheetImport_2_2yearSpreadsheetImport_2fileurlurl_value_NYvalueSpreadsheetImport_2_2fileurlurl_value_NJvaluegraphGet_Image_From_URLimage 6e069c36-8d88-4017-96cf-c1fa87007777 2010-07-07 11:20:48.694 EDT 9a2e5f63-ee29-42f3-810e-dc54fa9dfe3c 2010-07-07 11:59:16.81 EDT Spreadsheet Import Example 2010-07-13 06:22:34.496 EDT 64b51b72-af09-4842-b034-293dee7a03ff 2010-07-07 17:40:56.858 EDT 087f0faf-c2f4-45cf-a3d4-45ceb8d09a77 2011-09-21 12:42:52.793 EDT e28f14b3-e4ae-4d0b-893d-3a8400625069 2010-07-07 11:10:13.994 EDT 6c2a0ecf-5d91-4722-adf6-607c912ed54c 2010-07-07 11:54:20.460 EDT 8bdeaa39-f89b-4c33-9ac8-67b007030638 2011-09-21 11:57:26.410 EDT 30c2f2c6-dbd5-4e7a-9620-f6e8526fb9bc 2010-07-07 18:04:59.33 EDT 808e3725-2a08-4907-9706-fb7f0f08f62f 2010-07-13 06:20:05.749 EDT d94533da-f953-4532-a0d8-2e695f93bee0 2011-09-21 12:25:43.393 EDT 7d1166bd-dfa5-4675-918c-a880314302cb 2010-07-07 11:04:08.606 EDT 6d9b5609-37c3-4fb1-9eea-e6b70209427e 2010-07-07 09:05:03.421 EDT 464013e1-0699-4e1a-bac7-047576261b33 2010-07-07 18:07:59.655 EDT 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/ 2010-07-13 06:16:31.908 EDT 73ce4e99-6b83-45d0-8605-896d6d48b7f0 2010-07-07 12:01:14.713 EDT 4d5aa070-6bb9-417d-93ba-1179a5b38930 2011-09-21 12:22:40.883 EDT 41265789-c464-4ee2-b145-95ece9388305 2010-07-07 17:34:29.364 EDT 58b3ac31-cfb3-418a-85ae-1990b2883c35 2010-07-07 17:57:04.585 EDT 7c83cfa8-a0f0-4c70-9666-27cd2fa03c9a 2011-09-21 12:39:26.859 EDT cee35c36-afaf-4093-bcc5-eaac292207f5 2010-07-07 11:02:30.469 EDT 23eec6e0-9a32-461c-bd90-ba03bdc49d41 2010-07-07 12:25:28.613 EDT 32fba157-8f33-4af7-b858-73444dcaf523 2011-09-21 12:09:32.288 EDT 6622310c-9440-45a1-a051-729487b00b46 2010-07-13 07:32:33.863 EDT f0fe1955-23d6-41b7-b1af-b36d641429b4 2010-07-07 12:24:52.98 EDT 92d8fa84-2553-4de1-bff5-7d2a9b53c58d 2010-07-07 12:31:19.499 EDT b08510c9-187e-4742-af3f-45cfb09a400e 2011-09-21 12:29:38.620 EDT 812e7abc-4866-43dc-b9d4-44370a399e4e 2010-07-07 12:23:44.739 EDT 8af7971d-f944-4f27-b62a-437be1b99d3c 2010-07-07 11:07:29.140 EDT 59290a8d-83d5-4434-ba3c-757804731b53 2011-09-21 11:56:45.399 EDT 14724df6-fee6-4b24-8fbc-eeeeb3dc4e61 2010-07-07 11:38:21.137 EDT 2c1532f6-0ba4-48ea-9bf4-3fd3e39c6289 2010-07-07 09:00:56.585 EDT 18147588-af3c-43c7-a56e-1c4ab024430b 2011-09-21 12:02:09.22 EDT b4363407-ef56-4cf3-998f-8e780a8dc816 2010-07-07 11:41:31.230 EDT 58a4da02-d1f0-41ce-9ace-8a62b49b62d7 2010-07-13 06:22:26.72 EDT 10e5546b-8aa9-41c3-9e1d-c98d600ad857 2011-09-21 12:06:34.994 EDT 6f16e5e6-7e90-44af-9e7a-f63785e5408e 2010-07-07 17:53:58.943 EDT 99e82825-40e1-4fa9-8cf4-5348a8ff7b82 2010-07-07 17:38:24.439 EDT d533c230-a40d-4f9b-9ad4-f4389d4a6f1f 2010-07-07 11:00:00.482 EDT a752e401-77c5-42ef-9bf8-a60aa8af73f5 2010-07-07 17:50:42.557 EDT d8b96d03-8431-4cc0-b032-51e0c32092d3 2010-07-07 12:27:09.166 EDT c0753ab7-cd9d-400e-b483-048dcbaad5f9 2010-07-07 11:36:44.391 EDT a5bbe32f-ad20-4411-bc0e-d8f693e95493 2010-07-07 17:55:54.366 EDT 99c992df-d200-4cda-a973-c60be723e784 2010-07-07 12:14:16.5 EDT 486a5356-0f3e-424d-b14e-249295875f2d 2010-07-13 07:31:34.664 EDT 7ca4b117-111d-4605-826e-868d7d159b52 2010-07-13 06:16:32.697 EDT 31ac21d6-7c10-48ff-b9b2-82cac03f55c9 2010-07-07 17:43:05.458 EDT cf60043b-e08a-49d7-a150-711f413d3d18 2010-07-07 17:52:10.583 EDT 9c2e4b9c-5f25-4416-8653-cd9198a9271e 2010-07-13 06:19:30.143 EDT David Withers 2010-07-13 06:09:24.988 EDT 47de0484-f703-40ab-b1f7-b0826495a00d 2010-07-07 18:09:23.782 EDT 4462bd43-bcec-4aaf-83e5-64e111668a64 2010-07-07 18:00:20.619 EDT ae42a292-b7c5-48d6-93a4-b519b692ee3e 2011-09-21 12:44:46.640 EDT cca71cbe-6d97-4896-90c2-d91016f12882 2010-07-07 17:45:31.148 EDT e263e793-b394-4a57-855e-13e69b8780c2 2010-07-07 12:00:11.782 EDT 41afdcd6-fe98-4a7c-89fe-d1c9f87c20dc 2011-09-21 12:17:03.55 EDT dfa2cd09-f53d-47f4-91cd-207ec2dc2c34 2010-07-07 11:51:22.4 EDT 980d729b-1ec7-492c-9dfd-ccb19f9e81a7 2010-07-07 17:59:09.755 EDT 70c23010-0b47-424e-a1ce-73c040c3d3c6 2010-07-07 11:43:47.690 EDT e91839d7-586b-40d4-8ebe-28fd9dacbc46 2011-09-21 12:46:18.364 EDT 27965b7c-1a89-46ac-8c9b-a4c6bf9144f0 2010-07-13 06:22:36.27 EDT a51c1ed4-6419-4b5c-bb80-1eb2fea44341 2011-09-21 12:34:38.912 EDT