All content

Search filter terms
Filter by category
Filter by type
Filter by tag
Filter by user
Filter by licence
Results per page:
Sort by:
Showing 4 results. Use the filters on the left and the search box below to refine the results.
Category: Workflow Tag: excel Licence: by-sa

Workflow Demo of statistics webservice invoked from... (1)

This "spreadflow" was created by searching Seekda for a statistics webservice, adding it using "Web Services References" in Excel, and creating a simple VBA module to implement the corresponding Excel functions (sum, average, standard deviation etc) . The module simply gathers data from the cells to build an array of doubles that can be passed to the webservice. For more details about adding webservices to Excel see the inchidemo workflow http://www.myexperiment.org/workf...

Created: 2009-03-29

Credits: User David De Roure

Workflow Demo of ChemSpider InChi to SMILES webserv... (1)

This demo was created in Excel 2007, with the Office XP Webservices toolkit. Using the spreadsheet, the formula InChiToSMILES invokes the corresponding ChemSpider web service.  How I made this: 1. Installed Office XP Webservices toolkit from the Microsoft Download Center. 2. In Excel 2007 I turned on the Developer tab (hit Office button, then Excel options). 3. In the Developer ribbon I selected Visual Basic 4. In Tools->Web Services References I selected Web Service URL and ente...

Created: 2009-03-28 | Last updated: 2009-03-28

Credits: User David De Roure

Workflow Extract lists from a tab-delimited spreads... (1)

Thumb
This workflow takes a spreadsheet exported as a tab delimited file, such as an Excel spreadsheet. The style is expected as a matrix of data with the first row containing the column names and the first column containing the row names (see below). The top left cell is discarded. The workflow outputs three lists. A list of column names, a list of row names, and a two deep list of data points. The first list is a list of the rows and the sublist is a list of values of the cells from the columns....

Created: 2008-10-17 | Last updated: 2008-10-18

Credits: User Andrew Gibson

Workflow Spreadsheet Importer (1)

Thumb
This workflow is designed to import a spreadhseet from a local computer. The imported spreadsheet is parsed to extract the first two columns, A and B, for all rows in the spreadsheet. These are returned as two separate outputs.

Created: 2009-08-24

Credits: User Paul Fisher

Results per page:
Sort by: