This function is available with the add-on Sverchok extra and his dependencies SciPy.
For the installation of the add-on and his dependences please refer to the following link:
https://github.com/portnov/sverchok-extra
Once installed, open the Sverchok tab and click on Add. Scroll till Data and there we have 4 nodes:
- Spreadsheet;
- Data Items;
- Read Excel;
- Write Excel.
The read Excel nodes need a file path to load the document.
You can choose to work with the sheet by name or all of them.
In the drop-down, you can choose the dictionary type
- Nested lists – reads the data as It is in the file.
- Dictionary by row – allows you to read the data as a vertical table (the header first cell of the row);
- Dictionary by columns – allows you to read the data as a horizontal table (the header first cell of the column);
- Nested Dictionaries – uses the nested dictionary;
So the table used in the example video can be used as an input after connecting the data items node as in the following images. Dictionary by rows, and we use the row names from the first column.
The first option will give us the next result:
The last option will give us this result:
Attaching the nodes to a typography node, you can write the data into Blender Space or use it as input for further algorithms.
The demo video for this article:
The files used in this article (Blender and xls) you can find them at this link: