Table (vuo.table)

These nodes are for working with information that has a tabular structure made up of rows and columns, like a spreadsheet.

You can import a spreadsheet into a Vuo composition by exporting it from your spreadsheet application in CSV (Comma-Separated Values) or TSV (Tab-Separated Values) format and using the Fetch Data and Make Table from Text nodes. You can export CSV or TSV data from a Vuo composition, to be imported into your spreadsheet application, by using the Format Table and Save Data nodes.

Like a spreadsheet, Vuo’s Table data type stores information in a grid of rows and columns. For example, here’s a table of top-ranking tennis players (source:

1Serena WilliamsUnited States7010
2Angelique KerberGermany6925
3Karolina PliskovaCzech Republic6020
4Dominika CibulkovaSlovak Republic5065
5Simona HalepRomania5021

This table has 6 rows and 4 columns. In several nodes, such as Get Table Row and Get Table Column, you can refer to rows and columns by number, counting left-to-right or top-to-bottom starting from 1. For example, the header row of this table is row 1, and the bottom row (Simona Halep) is row 6.

You can also refer to rows and columns by header if there is one. The table above has headers for the columns (but not for the rows). With the Get Table Column node, you could request the row with header Player to get a list of all of the players' names.

Vuo stores each item of the table as text (even if it’s a number or date). With the Sort Table node, you have the option to treat the sorted column as a number or date, instead of sorting it alphabetically like text. When you retrieve table items with the Get Table Row, Get Table Column, or Get Table Item node, the items are output as text. You can convert them to numbers using nodes such as Convert Text to Integer and Convert Text List to Real List.

Example compositions: