Spreadsheet_Import_Examplegraph Final graph derived from values pulled from spreadsheet 2011-09-21 00:21:11.132 EDT SpreadsheetImportfileurl0NY_areaHarvested11NY_areaPlanted11year11net.sf.taverna.t2.activitiesspreadsheet-import-activity1.3net.sf.taverna.t2.activities.spreadsheet.SpreadsheetImportActivity 0 2 4 10 D phosphate E potash F total G public_water_supply A year B NY_areaPlanted C NY_areaHarvested L 2001 N 2002 H 1999 J 2000 T 2005 V 2006 P 2003 R 2004 X 2007 Z 2008 false true 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.InvokeGenerateGraphURLyears1headers1data2graphURL00net.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.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.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_2fileurl0NJ_areaHarvested11NJ_areaPlanted11net.sf.taverna.t2.activitiesspreadsheet-import-activity1.3net.sf.taverna.t2.activities.spreadsheet.SpreadsheetImportActivity 0 2 4 10 D phosphate E potash F total G public_water_supply A year B NJ_areaPlanted C NJ_areaHarvested L 2001 N 2002 H 1999 J 2000 T 2005 V 2006 P 2003 R 2004 X 2007 Z 2008 false true 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.InvokeBeanshellNY_areaHarvested1NY_areaPlanted1NJ_areaHarvested1NJ_areaPlanted1year1years11headers11data22net.sf.taverna.t2.activitiesbeanshell-activity1.3net.sf.taverna.t2.activities.beanshell.BeanshellActivity year 1 text/plain java.lang.String true NY_areaPlanted 1 text/plain java.lang.String true NY_areaHarvested 1 text/plain java.lang.String true NJ_areaPlanted 1 text/plain java.lang.String true NJ_areaHarvested 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.InvokeSpreadsheetImportfileurlurl_value_NYvalueGenerateGraphURLyearsBeanshellyearsGenerateGraphURLheadersBeanshellheadersGenerateGraphURLdataBeanshelldataGet_Image_From_URLurlGenerateGraphURLgraphURLSpreadsheetImport_2fileurlurl_value_NJvalueBeanshellNY_areaHarvestedSpreadsheetImportNY_areaHarvestedBeanshellNY_areaPlantedSpreadsheetImportNY_areaPlantedBeanshellNJ_areaHarvestedSpreadsheetImport_2NJ_areaHarvestedBeanshellNJ_areaPlantedSpreadsheetImport_2NJ_areaPlantedBeanshellyearSpreadsheetImportyeargraphGet_Image_From_URLimage fdebd5e8-2186-4262-9d9f-4a6063bd63bc 2011-09-21 03:06:52.551 EDT 808e3725-2a08-4907-9706-fb7f0f08f62f 2010-07-13 06:20:05.749 EDT David Withers 2010-07-13 06:09:24.988 EDT cee35c36-afaf-4093-bcc5-eaac292207f5 2010-07-07 11:02:30.469 EDT cca71cbe-6d97-4896-90c2-d91016f12882 2010-07-07 17:45:31.148 EDT 2596ad3f-e7e7-41d2-aa4c-ace93bce934e 2011-09-20 23:50:51.32 EDT 63d64e34-b752-4393-90c5-2008d31dcf33 2011-09-21 02:54:41.890 EDT fb35d91b-ae3f-4f14-920d-2442c129a5e6 2011-09-21 02:57:43.60 EDT 48ca88c0-54a9-4499-80ae-9a624c3b2b7e 2011-09-21 00:01:18.231 EDT cb33bf84-d2ed-4559-b2d7-deb529f377bd 2011-09-21 00:10:29.734 EDT 47de0484-f703-40ab-b1f7-b0826495a00d 2010-07-07 18:09:23.782 EDT f7841c0c-59e5-4a88-b941-28eebc171c2e 2011-09-21 00:07:57.637 EDT bf29cb7d-2ac8-4c97-86c2-480cce8f4575 2011-09-21 03:13:45.27 EDT 7a604bd3-6e18-4e8c-9a9e-99f5db332596 2011-09-20 22:52:07.354 EDT 812e7abc-4866-43dc-b9d4-44370a399e4e 2010-07-07 12:23:44.739 EDT 2c1532f6-0ba4-48ea-9bf4-3fd3e39c6289 2010-07-07 09:00:56.585 EDT 31ac21d6-7c10-48ff-b9b2-82cac03f55c9 2010-07-07 17:43:05.458 EDT 260bd82c-41fd-4362-a717-0e826c476153 2011-09-21 02:45:35.651 EDT 773cbfb1-081f-4fd2-8700-3ce264b3c2f2 2011-09-20 22:51:05.474 EDT 89f8d2e0-4f0b-4c99-8c34-884906da05de 2011-09-21 03:07:59.10 EDT 58a4da02-d1f0-41ce-9ace-8a62b49b62d7 2010-07-13 06:22:26.72 EDT 70c23010-0b47-424e-a1ce-73c040c3d3c6 2010-07-07 11:43:47.690 EDT 64b51b72-af09-4842-b034-293dee7a03ff 2010-07-07 17:40:56.858 EDT 7d1166bd-dfa5-4675-918c-a880314302cb 2010-07-07 11:04:08.606 EDT 5eeaf4df-a3ac-4630-abd1-b9e54974f8bf 2011-09-21 02:54:00.582 EDT 0b6b4d50-fac7-4821-9864-14447f753e0d 2011-09-21 03:28:00.50 EDT 4462bd43-bcec-4aaf-83e5-64e111668a64 2010-07-07 18:00:20.619 EDT 6c2a0ecf-5d91-4722-adf6-607c912ed54c 2010-07-07 11:54:20.460 EDT da400484-8fac-4933-bd12-94b2a48f1825 2011-09-21 02:43:09.215 EDT e8ec0ac9-559d-4aec-8a4c-6935a38956b7 2011-09-21 03:23:32.6 EDT 27965b7c-1a89-46ac-8c9b-a4c6bf9144f0 2010-07-13 06:22:36.27 EDT b3c27fb2-e7b1-44a1-a48f-aa4346991a6a 2011-09-20 14:03:37.600 EDT 7ca4b117-111d-4605-826e-868d7d159b52 2010-07-13 06:16:32.697 EDT e28f14b3-e4ae-4d0b-893d-3a8400625069 2010-07-07 11:10:13.994 EDT 8a3abf79-a675-45d4-976c-c7bd49d9065c 2011-09-20 23:21:45.15 EDT a752e401-77c5-42ef-9bf8-a60aa8af73f5 2010-07-07 17:50:42.557 EDT 6622310c-9440-45a1-a051-729487b00b46 2010-07-13 07:32:33.863 EDT c0753ab7-cd9d-400e-b483-048dcbaad5f9 2010-07-07 11:36:44.391 EDT d8b96d03-8431-4cc0-b032-51e0c32092d3 2010-07-07 12:27:09.166 EDT 9c2e4b9c-5f25-4416-8653-cd9198a9271e 2010-07-13 06:19:30.143 EDT 73ce4e99-6b83-45d0-8605-896d6d48b7f0 2010-07-07 12:01:14.713 EDT 23eec6e0-9a32-461c-bd90-ba03bdc49d41 2010-07-07 12:25:28.613 EDT c1f2434c-dddf-4ade-a58f-879991a9ceff 2011-09-21 03:00:12.450 EDT a433545b-2fad-400c-980c-2585b58e6096 2011-09-20 23:24:27.517 EDT d1fc16ea-1b7b-4894-acda-9ef94ed002bb 2011-09-21 03:18:42.274 EDT f0fe1955-23d6-41b7-b1af-b36d641429b4 2010-07-07 12:24:52.98 EDT c03d3829-7880-4a8c-bcdf-16f7850e66bb 2011-09-20 23:02:04.759 EDT dc4fc84c-b9b4-4f0d-9275-ca7f8788e0d3 2011-09-21 02:56:30.92 EDT 58b3ac31-cfb3-418a-85ae-1990b2883c35 2010-07-07 17:57:04.585 EDT 5a5e971e-ad80-43d2-afed-6d67b5dc6f47 2011-09-21 02:55:28.545 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 41265789-c464-4ee2-b145-95ece9388305 2010-07-07 17:34:29.364 EDT 99e82825-40e1-4fa9-8cf4-5348a8ff7b82 2010-07-07 17:38:24.439 EDT Spreadsheet Import Example 2010-07-13 06:22:34.496 EDT 9ec4b219-54a2-45fb-8b6c-75b2f67d791f 2011-09-21 00:21:11.464 EDT ab1d47cb-3a6c-4290-bfc8-a94f29b84546 2011-09-20 23:59:34.22 EDT 30c2f2c6-dbd5-4e7a-9620-f6e8526fb9bc 2010-07-07 18:04:59.33 EDT b4363407-ef56-4cf3-998f-8e780a8dc816 2010-07-07 11:41:31.230 EDT babbbbf7-f431-4eb4-bea2-d057fa4c2641 2011-09-20 23:57:59.624 EDT 6f16e5e6-7e90-44af-9e7a-f63785e5408e 2010-07-07 17:53:58.943 EDT 6e069c36-8d88-4017-96cf-c1fa87007777 2010-07-07 11:20:48.694 EDT 464013e1-0699-4e1a-bac7-047576261b33 2010-07-07 18:07:59.655 EDT 8af7971d-f944-4f27-b62a-437be1b99d3c 2010-07-07 11:07:29.140 EDT 22738e00-f3db-420e-b092-6029546143f3 2011-09-20 23:57:01.222 EDT a8845730-8952-466f-900d-ae65a4228925 2011-09-20 13:55:11.855 EDT 1f054c54-c333-4bbd-acf6-263eb6e04c78 2011-09-20 23:19:13.612 EDT 14724df6-fee6-4b24-8fbc-eeeeb3dc4e61 2010-07-07 11:38:21.137 EDT 9b66bbd5-6fec-48cb-83ae-0be5e5dbbe0a 2011-09-21 00:05:37.44 EDT 486a5356-0f3e-424d-b14e-249295875f2d 2010-07-13 07:31:34.664 EDT a5bbe32f-ad20-4411-bc0e-d8f693e95493 2010-07-07 17:55:54.366 EDT d533c230-a40d-4f9b-9ad4-f4389d4a6f1f 2010-07-07 11:00:00.482 EDT 63d64e34-b752-4393-90c5-2008d31dcf33 2011-09-21 02:50:00.397 EDT 2e999866-035b-4adf-9ca4-03e378d8b2d4 2011-09-21 02:46:34.82 EDT 6d9b5609-37c3-4fb1-9eea-e6b70209427e 2010-07-07 09:05:03.421 EDT e1566824-84c5-4598-aa1e-39287eefce03 2011-09-20 14:05:27.742 EDT 7adcc3be-da29-481d-afc0-5fea2a1e341b 2011-09-21 00:13:21.165 EDT c219e7a5-dfc9-4240-b9c7-ea8fd7fe4423 2011-09-21 03:17:03.193 EDT e0adb8bb-1b3f-4763-b9ac-0b60f144d633 2011-09-21 02:48:01.18 EDT 6c8a9c7f-49ca-4a44-a8a1-e58aa5166c69 2011-09-21 03:01:00.23 EDT a898fb39-d6f7-4d5f-ba8c-91aaa7eaa827 2011-09-21 00:02:34.679 EDT 9a2e5f63-ee29-42f3-810e-dc54fa9dfe3c 2010-07-07 11:59:16.81 EDT c1cef864-c7b3-4a59-8f6e-175ecb4873f9 2011-09-20 23:00:59.24 EDT cf60043b-e08a-49d7-a150-711f413d3d18 2010-07-07 17:52:10.583 EDT 99c992df-d200-4cda-a973-c60be723e784 2010-07-07 12:14:16.5 EDT c05db1e2-e4d7-48f0-a63c-0f80cf0f2341 2011-09-21 02:59:15.181 EDT 93a2c5c2-234e-4871-a279-fc38940f51ff 2011-09-20 14:08:43.236 EDT 8276541a-8f12-49f7-89f7-e8f4a344f434 2011-09-21 00:55:35.301 EDT 122f5ad3-0e87-417d-8b77-b6cb5dcf560e 2011-09-21 00:09:14.160 EDT d4121860-8795-4edc-9417-d3d30563da82 2011-09-21 03:21:54.604 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 92d8fa84-2553-4de1-bff5-7d2a9b53c58d 2010-07-07 12:31:19.499 EDT 39c82318-ae4c-4292-879a-5a34bf45481a 2011-09-21 03:06:23.163 EDT dfa2cd09-f53d-47f4-91cd-207ec2dc2c34 2010-07-07 11:51:22.4 EDT