Writing to Excel

HI,

I am trying to write some basic data (for now) from rhino/grasshopper to excel. I am not able to correctly connect the ghowl spreadsheet writer to my excel sheet. If there are other ways outside of ghowl I would be happy to try them too.

I think I need a play-by-play for this one, I had it working once but I forget how to setup the spreadsheet.. Thanks for any input or direction!

-Daniel

Attachments:

Floor Plates + Massing_3.gh, 20 KB

Replies to This Discussion

Permalink Reply by Joseph Oster on June 5, 2015 at 9:39am

I haven't looked at the "ghowl spreadsheet writer" but here are two other ways using 'TxtWriter' components someone here gave me recently. (attached)

In order to set the 'Path' input parameter for the VB script, the file you want to write to must already exist.

The Python script writes to file 'Name_n' in the same folder as the GH script, incrementing "n" automagically.

To test it, I had to enable the first bit of code in your file because the part you had enabled had no data (no input). I suggest you use the "Internalize data" feature on that "Geo" param to avoid having to include a Rhino file to test the script.

Attachments:

FloorPlatesMassing_3_2015Jun5a.gh, 26 KB

Permalink Reply by Daniel Greenspan on June 8, 2015 at 2:27pm

Thanks Joseph!

That works. Any idea how to have excel update live with the excel file open? As a design tool I'd like to see the changes to the metrics as the rhino geometries change.

RSS