Grasshopper

algorithmic modeling for Rhino

Colibri 2.0
Excel
Platypus
Spectacles
TT Tools

Write Options

Component Index > TT Toolbox > Excel > Write Options

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.String
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.String
Write OptionsWOOptions string to input into Write To Excel component.String

© 2018   Created by Robin Rodricks and Andrew Heumann.   Hosted by

Badges  |  Report an Issue  |  Terms of Service