Grasshopper Docs

Community documentation for Grasshopper add-ons & plugins

Colibri 2.0
Excel
Platypus
Spectacles
TT Tools

Option settings for writing data to Excel.

Inputs

NameIDDescriptionType
File Path[FP]File path pointing to an excel file which will be opened and written to. Only .xlsx file types will be recognized. If the file does not exist and the path is valid, a new file will be created and saved after writing data.Text
Clear Data / Overwrite[C/O]Set to false to partially overwrite data in excel and maintain any formatting in the worksheet. True clears all data and formatting in the sheet, then writes new data.Boolean
Save after write?[Save]Set to true to save the excel file after writing data. A valid file path must be specified in order for a file to be saved.Boolean
Close after write?[Close]Set to true to close the file after writing data. If true, Save after write will be set to true automatically. Use this setting to create a series of files by animating a slider to avoid opening a bunch of excel instnaces.Boolean
Column Start Position[Cs]Cell to start writing columns in.Integer
Row Start Position[Rs]Row to start writing columns in.Integer
Conditional Formatting Colors[FC]A list of 2 or 3 colors to define the conditional formatting color range. Conditional formatting will be added to the tree of data if colors are specified.Colour

Outputs

NameIDDescriptionType
User MessagesOutText output for errors, messages, debugging, etc.Text
Write OptionsWOOptions string to input into Write To Excel component.Text

Video Tutorials

Site design © Robin Rodricks.   TT Toolbox and associated data © 2020 Thornton Tomasetti (CORE studio).  
Rhinoceros and Grasshopper are registered trademarks of Robert McNeel & Associates.  Hosted by GitHub

Report an Issue  |  Terms of Service