Spreadsheet

Read data from a .csv file.

File - drag in a .csv file from the Assets Window.

Column Title - select a column from your spreadsheet. The first row of your spreadsheet is reserved and used to populate this list.

Remapping - remap numerical values relative to the lowest and highest number in your data. For example, if you want to create a bar chart and need a value of 1 to be represented by a rectangle with a height of 300px, you can.

Remap Minimum - set the minimum value for your range.

Remap Maximum - set the maximum value for your range.

Remap Gradient - set the colors to remap your data to (see hint below).

If you have a minimum value of 0 and a maximum of 10 within your data and a simple black to white gradient, a value of 0 will be Black, a value of 10 will output White and a value of 5 will be remapped to 50% grey.

Fixed Row - When checked it will output the contents of the row specified in Row Index (not including the title row). Useful for Dynamic Rendering.

Row Index - specify the row to output. A value of 0 outputs row 1 of your spreadsheet (row 0 is reserved for Column Title).

Row Offset - add or subtract a value to Row Index.

Use Every Nth Row - only sample the first and then every Nth row where N = the value.

Example usage:

  1. Create a Text Shape, a Duplicator and a Spreadsheet node.

  2. Create a .csv file containing a row titled 'Name' with several names listed below.

  3. Import the .csv file to the Assets Window.

  4. Drag the .csv into the File attribute of the Spreadsheet node.

  5. Set Column Title to 'Name' on the Spreadsheet node.

  6. Connect textShape.id > duplicator.inputShapes.

  7. Set Count to X = 1 and Y = 4 on the Duplicator.

  8. Connect spreadsheet.id > textShape.text.

You should see the first 4 names from your .csv (not including the title) appear. If you have more or less than 4 names just adjust Count Y on the Duplicator.

A Spreadsheet node can only output data from a single row. In order to use several rows from the same .csv you need to create a Spreadsheet node for each row you want to output.