Spreadsheet_Import_ExamplegraphSpreadsheetImportfileurl0nitrogen11phosphate11potash11year11net.sf.taverna.t2.activitiesspreadsheet-import-activity1.3net.sf.taverna.t2.activities.spreadsheet.SpreadsheetImportActivity 1 5 4 55 D phosphate E potash F total G empty A over B year C nitrogen L 2001 N 2002 H NitrogenPct I PhosphatePct J PotashPct T 2005 V 2006 P 2003 R 2004 X 2007 Z 2008 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.InvokeGenerateGraphURLdata2headers1years1graphURL00net.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.InvokeBeanshellnitrogen1phosphate1potash1year1data22headers11years11net.sf.taverna.t2.activitiesbeanshell-activity1.3net.sf.taverna.t2.activities.beanshell.BeanshellActivity nitrogen 1 text/plain java.lang.String true phosphate 1 text/plain java.lang.String true potash 1 text/plain java.lang.String true total 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_valuevalue00net.sf.taverna.t2.activitiesstringconstant-activity1.3net.sf.taverna.t2.activities.stringconstant.StringConstantActivity http://www.myexperiment.org/files/568/download/FertilizerUse.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.InvokeSpreadsheetImportfileurlurl_valuevalueGenerateGraphURLdataBeanshelldataGenerateGraphURLheadersBeanshellheadersGenerateGraphURLyearsBeanshellyearsGet_Image_From_URLurlGenerateGraphURLgraphURLBeanshellnitrogenSpreadsheetImportnitrogenBeanshellphosphateSpreadsheetImportphosphateBeanshellpotashSpreadsheetImportpotashBeanshellyearSpreadsheetImportyeargraphGet_Image_From_URLimage a752e401-77c5-42ef-9bf8-a60aa8af73f5 2010-07-07 17:50:42.557 EDT 58b3ac31-cfb3-418a-85ae-1990b2883c35 2010-07-07 17:57:04.585 EDT 70c23010-0b47-424e-a1ce-73c040c3d3c6 2010-07-07 11:43:47.690 EDT 808e3725-2a08-4907-9706-fb7f0f08f62f 2010-07-13 06:20:05.749 EDT 6f16e5e6-7e90-44af-9e7a-f63785e5408e 2010-07-07 17:53:58.943 EDT a5bbe32f-ad20-4411-bc0e-d8f693e95493 2010-07-07 17:55:54.366 EDT 6e069c36-8d88-4017-96cf-c1fa87007777 2010-07-07 11:20:48.694 EDT 30c2f2c6-dbd5-4e7a-9620-f6e8526fb9bc 2010-07-07 18:04:59.33 EDT cee35c36-afaf-4093-bcc5-eaac292207f5 2010-07-07 11:02:30.469 EDT f0fe1955-23d6-41b7-b1af-b36d641429b4 2010-07-07 12:24:52.98 EDT 59290a8d-83d5-4434-ba3c-757804731b53 2011-09-21 11:56:45.399 EDT e263e793-b394-4a57-855e-13e69b8780c2 2010-07-07 12:00:11.782 EDT 980d729b-1ec7-492c-9dfd-ccb19f9e81a7 2010-07-07 17:59:09.755 EDT 4462bd43-bcec-4aaf-83e5-64e111668a64 2010-07-07 18:00:20.619 EDT 64b51b72-af09-4842-b034-293dee7a03ff 2010-07-07 17:40:56.858 EDT 73ce4e99-6b83-45d0-8605-896d6d48b7f0 2010-07-07 12:01:14.713 EDT 92d8fa84-2553-4de1-bff5-7d2a9b53c58d 2010-07-07 12:31:19.499 EDT 7ca4b117-111d-4605-826e-868d7d159b52 2010-07-13 06:16:32.697 EDT d533c230-a40d-4f9b-9ad4-f4389d4a6f1f 2010-07-07 11:00:00.482 EDT 7d1166bd-dfa5-4675-918c-a880314302cb 2010-07-07 11:04:08.606 EDT David Withers 2010-07-13 06:09:24.988 EDT 6d9b5609-37c3-4fb1-9eea-e6b70209427e 2010-07-07 09:05:03.421 EDT 58a4da02-d1f0-41ce-9ace-8a62b49b62d7 2010-07-13 06:22:26.72 EDT 812e7abc-4866-43dc-b9d4-44370a399e4e 2010-07-07 12:23:44.739 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 dfa2cd09-f53d-47f4-91cd-207ec2dc2c34 2010-07-07 11:51:22.4 EDT 2c1532f6-0ba4-48ea-9bf4-3fd3e39c6289 2010-07-07 09:00:56.585 EDT 8af7971d-f944-4f27-b62a-437be1b99d3c 2010-07-07 11:07:29.140 EDT 9c2e4b9c-5f25-4416-8653-cd9198a9271e 2010-07-13 06:19:30.143 EDT 10e5546b-8aa9-41c3-9e1d-c98d600ad857 2011-09-21 12:06:34.994 EDT 6622310c-9440-45a1-a051-729487b00b46 2010-07-13 07:32:33.863 EDT e28f14b3-e4ae-4d0b-893d-3a8400625069 2010-07-07 11:10:13.994 EDT 18147588-af3c-43c7-a56e-1c4ab024430b 2011-09-21 12:02:09.22 EDT 99e82825-40e1-4fa9-8cf4-5348a8ff7b82 2010-07-07 17:38:24.439 EDT 99c992df-d200-4cda-a973-c60be723e784 2010-07-07 12:14:16.5 EDT 41265789-c464-4ee2-b145-95ece9388305 2010-07-07 17:34:29.364 EDT 47de0484-f703-40ab-b1f7-b0826495a00d 2010-07-07 18:09:23.782 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 6c2a0ecf-5d91-4722-adf6-607c912ed54c 2010-07-07 11:54:20.460 EDT 32fba157-8f33-4af7-b858-73444dcaf523 2011-09-21 12:09:32.288 EDT 9a2e5f63-ee29-42f3-810e-dc54fa9dfe3c 2010-07-07 11:59:16.81 EDT b4363407-ef56-4cf3-998f-8e780a8dc816 2010-07-07 11:41:31.230 EDT cca71cbe-6d97-4896-90c2-d91016f12882 2010-07-07 17:45:31.148 EDT 464013e1-0699-4e1a-bac7-047576261b33 2010-07-07 18:07:59.655 EDT Spreadsheet Import Example 2010-07-13 06:22:34.496 EDT d8b96d03-8431-4cc0-b032-51e0c32092d3 2010-07-07 12:27:09.166 EDT 14724df6-fee6-4b24-8fbc-eeeeb3dc4e61 2010-07-07 11:38:21.137 EDT c0753ab7-cd9d-400e-b483-048dcbaad5f9 2010-07-07 11:36:44.391 EDT 23eec6e0-9a32-461c-bd90-ba03bdc49d41 2010-07-07 12:25:28.613 EDT 8bdeaa39-f89b-4c33-9ac8-67b007030638 2011-09-21 11:57:26.410 EDT 27965b7c-1a89-46ac-8c9b-a4c6bf9144f0 2010-07-13 06:22:36.27 EDT 486a5356-0f3e-424d-b14e-249295875f2d 2010-07-13 07:31:34.664 EDT