Spreadsheet_Import_ExamplegraphSpreadsheetImportfileurl0electricity11fish_farming11other11other_industry11public_water_supply11year11net.sf.taverna.t2.activitiesspreadsheet-import-activity1.4net.sf.taverna.t2.activities.spreadsheet.SpreadsheetImportActivity 1 6 7 41 D other E fish_farming F other_industry G public_water_supply A over B year C electricity L 2001 N 2002 H 1999 J 2000 T 2005 V 2006 P 2003 R 2004 X 2007 Z 2008 false false false EMPTY_STRING PORT_PER_COLUMN , net.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeGenerateGraphURLdata2headers1years1graphURL00net.sf.taverna.t2.activitiesbeanshell-activity1.4net.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.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeGet_Image_From_URLurl0image00net.sf.taverna.t2.activitieslocalworker-activity1.4net.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.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeBeanshellyear1electricity1fish_farming1public_water_supply1data22headers11years11net.sf.taverna.t2.activitiesbeanshell-activity1.4net.sf.taverna.t2.activities.beanshell.BeanshellActivity year 1 text/plain java.lang.String true electricity 1 text/plain java.lang.String true fish_farming 1 text/plain java.lang.String true public_water_supply 1 text/plain java.lang.String true data 2 2 headers 1 1 years 1 1 workflow net.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invokeurl_valuevalue00net.sf.taverna.t2.activitiesstringconstant-activity1.4net.sf.taverna.t2.activities.stringconstant.StringConstantActivity http://www.myexperiment.org/files/410/download/WaterUse.xlsx net.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.4net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeSpreadsheetImportfileurlurl_valuevalueGenerateGraphURLdataBeanshelldataGenerateGraphURLheadersBeanshellheadersGenerateGraphURLyearsBeanshellyearsGet_Image_From_URLurlGenerateGraphURLgraphURLBeanshellyearSpreadsheetImportyearBeanshellelectricitySpreadsheetImportelectricityBeanshellfish_farmingSpreadsheetImportfish_farmingBeanshellpublic_water_supplySpreadsheetImportpublic_water_supplygraphGet_Image_From_URLimage David Withers 2010-07-13 11:09:24.988 BST 6c2a0ecf-5d91-4722-adf6-607c912ed54c 2010-07-07 16:54:20.460 BST 2c1532f6-0ba4-48ea-9bf4-3fd3e39c6289 2010-07-07 14:00:56.585 BST cca71cbe-6d97-4896-90c2-d91016f12882 2010-07-07 22:45:31.148 BST d533c230-a40d-4f9b-9ad4-f4389d4a6f1f 2010-07-07 16:00:00.482 BST 9a2e5f63-ee29-42f3-810e-dc54fa9dfe3c 2010-07-07 16:59:16.81 BST 99c992df-d200-4cda-a973-c60be723e784 2010-07-07 17:14:16.5 BST a752e401-77c5-42ef-9bf8-a60aa8af73f5 2010-07-07 22:50:42.557 BST 92d8fa84-2553-4de1-bff5-7d2a9b53c58d 2010-07-07 17:31:19.499 BST 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 11:16:31.908 BST 41265789-c464-4ee2-b145-95ece9388305 2010-07-07 22:34:29.364 BST 980d729b-1ec7-492c-9dfd-ccb19f9e81a7 2010-07-07 22:59:09.755 BST 47de0484-f703-40ab-b1f7-b0826495a00d 2010-07-07 23:09:23.782 BST 808e3725-2a08-4907-9706-fb7f0f08f62f 2010-07-13 11:20:05.749 BST 7ca4b117-111d-4605-826e-868d7d159b52 2010-07-13 11:16:32.697 BST 6e069c36-8d88-4017-96cf-c1fa87007777 2010-07-07 16:20:48.694 BST 812e7abc-4866-43dc-b9d4-44370a399e4e 2010-07-07 17:23:44.739 BST 64b51b72-af09-4842-b034-293dee7a03ff 2010-07-07 22:40:56.858 BST 27965b7c-1a89-46ac-8c9b-a4c6bf9144f0 2010-07-13 11:22:36.27 BST a5bbe32f-ad20-4411-bc0e-d8f693e95493 2010-07-07 22:55:54.366 BST dfa2cd09-f53d-47f4-91cd-207ec2dc2c34 2010-07-07 16:51:22.4 BST cf60043b-e08a-49d7-a150-711f413d3d18 2010-07-07 22:52:10.583 BST 23eec6e0-9a32-461c-bd90-ba03bdc49d41 2010-07-07 17:25:28.613 BST 99e82825-40e1-4fa9-8cf4-5348a8ff7b82 2010-07-07 22:38:24.439 BST 486a5356-0f3e-424d-b14e-249295875f2d 2010-07-13 12:31:34.664 BST b4363407-ef56-4cf3-998f-8e780a8dc816 2010-07-07 16:41:31.230 BST cee35c36-afaf-4093-bcc5-eaac292207f5 2010-07-07 16:02:30.469 BST e263e793-b394-4a57-855e-13e69b8780c2 2010-07-07 17:00:11.782 BST 73ce4e99-6b83-45d0-8605-896d6d48b7f0 2010-07-07 17:01:14.713 BST 4462bd43-bcec-4aaf-83e5-64e111668a64 2010-07-07 23:00:20.619 BST 31ac21d6-7c10-48ff-b9b2-82cac03f55c9 2010-07-07 22:43:05.458 BST d8b96d03-8431-4cc0-b032-51e0c32092d3 2010-07-07 17:27:09.166 BST 6d9b5609-37c3-4fb1-9eea-e6b70209427e 2010-07-07 14:05:03.421 BST 70c23010-0b47-424e-a1ce-73c040c3d3c6 2010-07-07 16:43:47.690 BST f0fe1955-23d6-41b7-b1af-b36d641429b4 2010-07-07 17:24:52.98 BST c0753ab7-cd9d-400e-b483-048dcbaad5f9 2010-07-07 16:36:44.391 BST 464013e1-0699-4e1a-bac7-047576261b33 2010-07-07 23:07:59.655 BST 58a4da02-d1f0-41ce-9ace-8a62b49b62d7 2010-07-13 11:22:26.72 BST 6f16e5e6-7e90-44af-9e7a-f63785e5408e 2010-07-07 22:53:58.943 BST Spreadsheet Import Example 2010-07-13 11:22:34.496 BST 9c2e4b9c-5f25-4416-8653-cd9198a9271e 2010-07-13 11:19:30.143 BST 58b3ac31-cfb3-418a-85ae-1990b2883c35 2010-07-07 22:57:04.585 BST 8af7971d-f944-4f27-b62a-437be1b99d3c 2010-07-07 16:07:29.140 BST e28f14b3-e4ae-4d0b-893d-3a8400625069 2010-07-07 16:10:13.994 BST 7d1166bd-dfa5-4675-918c-a880314302cb 2010-07-07 16:04:08.606 BST 14724df6-fee6-4b24-8fbc-eeeeb3dc4e61 2010-07-07 16:38:21.137 BST 30c2f2c6-dbd5-4e7a-9620-f6e8526fb9bc 2010-07-07 23:04:59.33 BST 6622310c-9440-45a1-a051-729487b00b46 2010-07-13 12:32:33.863 BST