User / Examples / Building Workflows With Excel / Uploading Samples

Adding Samples to Workflow

Last updated on 29-Aug-2018 by Thomas P. Boesen
Thomas P. Boesen


In the previous tutorial we learned how to create a workflow in Scifeon using Excel.
Now we will take a look at adding samples and result arrays to our workflow:

1. The Array Tag and Samples

For samples and results we would like a more compact data representation: Introducing the [array] tag:

The [array] tag indicates that the following should be read as an array. The parser will then stop reading Key-Value pairs and attempt to parse the data array.
The parser will start reading one cell down and to the right of the tagged cell (B11 in the demo file). The parser will continue reading outward until an empty cell is reached and downwards until a new Key-Value pair is reached. This means that vertical whitespace is ignored - you are free to delete sample rows without affecting samples below.
The samples array should be placed in the experiment section, the samples will then be sent forward through the steps.

2. Result Array

The array tag is also used for uploading results:

Here is a more complex workflow featuring multiple steps (made with the [section] tag) and a couple of data arrays.
The results array also has an [array] tag and is parsed the same way as the samples. Once uploaded, however, Scifeon treats them differently:

Samples are attached to the experiment workflow and propagates down through each step.

Results are connected to a single step. On the picture we are looking at the result set in the database.
Note that we can easily navigate the database using the ID links in the top-left and center boxes.

3. Object Oriented Excel

If you wish to play around with the demo files, they can be downloaded here: [samples](./Demo 2 Samples.xlsx) and *[results](./Demo 3 results.xlsx).
Or you can continue with *Objects and Plates in Excel