Spreadsheet
Read data from a Google Sheet or .csv file.
File - drag in a Google Sheet or .csv asset 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.
A Spreadsheet node can only output data from a single column. In order to use several columns from the same .csv you need to create a Spreadsheet node for each column you want to output.
Factorize - when checked, a column of text can be converted into values. For example, a column of data containing the text Summer, Spring, Summer, Summer can be converted to a list of values 1, 0, 1, 1. The resulting list is ordered alphabetically.
For performance reasons the asset (.csv or Google Sheet) must also be 'factorized'. Right click on the asset in the Asses Window and check Factorize.
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.
None - remapping disabled.
Number Range - see Number Range.
Number Range to Color - see Number Range to Color.
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.
Row Count - a read only attribute that outputs the number of rows in the selected column.
Example usage:
Create a Text Shape, a Duplicator and a Spreadsheet node.
Create a
.csvfile containing a row titled 'Name' with several names listed below.Import the
.csvfile to the Assets Window.Drag the
.csvinto the File attribute of the Spreadsheet node.Set Column Title to 'Name' on the Spreadsheet node.
Connect textShape.id > duplicator.inputShapes.
Set Count to X = 1 and Y = 4 on the Duplicator.
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.
Example usage:
Create a Google Sheet containing the data below:
Label
Value
Color
Twitter
235
#00acee
Instagram
1135
#c13584
YouTube
101
#ff0000
Vimeo
2301
#1ab7ea
TikTok
764
#69c9d0
Ensure Link Sharing is set to On and either Public on the web or Anyone with the link.
Import the Google Sheet via the Assets Window.
Drag the Google Sheet asset into the Viewport (this will create a Spreadsheet Element and connect the asset).
Set Column Title to Value.
Create a Rectangle.
Connect spreadsheet.id > rectangle.size.height
Select the Rectangle and
alt + clickthe Duplicator icon in the Shelf.Set Distribution to Linear.
Set Count to 5.
At this point you should have 5 rectangles each with a height set as per each row of the Value column in your data. In order to pin the rectangles to a 'floor' you can use an Align Behaviour.
Create an Align.
Connect align.id > rectangle.deformers.
On the Align Behaviour, set Y to 1.
If the data contains small/large values then you may need to remap the values to something that produces results that better fit your Composition.
On the Spreadsheet Element set Remapping to Number Range.
Set Source Minimum to 0.
Set Source Maximum to 2500. These to values roughly contain the range of your data.
Set Minimum to 0.
Set Maximum to 500.
A value of 0 in your data will now output as 0 while a value of 2500 will be output at 500. In this example we are effectively dividing all values by 2500/500 = 5 so a value of 1000 would be remapped to 200.
See data.cv in Example Files for an example scene file.
Last updated
