We need your help! 🔥
Please consider disabling your ad-blocker to support this website! 🔑
We are a free, community-supported website! 🥰
We only display small unobtrusive ads which help us stay online! 💯
Thank you in advance! ❤️
We are a free, community-supported website! 🥰
We only display small unobtrusive ads which help us stay online! 💯
Thank you in advance! ❤️
Write Options
Option settings for writing data to Excel.
Inputs
| Name | ID | Description | Type |
|---|---|---|---|
| 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
| Name | ID | Description | Type |
|---|---|---|---|
| User Messages | Out | Text output for errors, messages, debugging, etc. | Text |
| Write Options | WO | Options string to input into Write To Excel component. | Text |
Site design © Robin Rodricks.
TT Toolbox and associated data © 2024 Thornton Tomasetti (CORE studio).
Rhinoceros and Grasshopper are registered trademarks of Robert McNeel & Associates.
Hosted by GitHub