Create sheets from the Excel file

This script run Data-Shapes user interface.

The user interface will ask you to show the location of Excel file, you will also need to write an excel sheet name and to enter the name of the cell from which Dynamo will start reading data and the last cell. After that Dynamo will create sheets.

The script can also cover two more cases. The case when you have sheets in your project, but you did not start preparing them so you want to quickly delete all of them and create new sheets. 

The last option is the case when you have sheets in the model, you do not want to delete them but you have new sheet numbers and/or names and you want Dynamo to change those parameters instead of you.

Please make sure that before you start using this script that you back up your existing project model.

Also, if you want to download this (and all other scripts) with my sample files please visit the Shop page.

The script uses the following Dynamo packages:
Clockwork for Dynamo 2.x, 2.3.0
Data-Shapes, 2019.2.42
Rhythm, 2020.2.13
BumbleBee, 2021.25.2

Leave a Reply

Your email address will not be published. Required fields are marked *