Geometry based on data from excel

Hello,

Is there a way to use referenced data from excel to generate geometry?

I.e. I have a list of area sqm from excel that I have referenced into grashopper, however, how would i go about building geometry from this data.

Thanks,

David

Replies to This Discussion

Permalink Reply by taz on March 15, 2010 at 2:39pm

This will help you get the data from Excel. What you do with the data is up to you...

http://www.grasshopper3d.com/forum/topics/transferring-data-from-excel

Permalink Reply by David B on March 15, 2010 at 2:56pm

Well I have got the data into grasshopper, my question was is I can generate geometry based on area, instead of points or what have you

Permalink Reply by taz on March 15, 2010 at 3:35pm

You would have to incorporate your area data into a geometric relationship.

Squares and circles would be straightforward to make based on their area equations.

If you wanted to make rectangles you could try to specify the length of one side or a particular aspect ratio.

There are no GH (or even Rhino) objects that can be automatically created from a single value that represents area.

Permalink Reply by Adam Brillhart on March 16, 2010 at 12:02pm

SRY - DBL POST BUT REALIZED THIS WAS RECENT, RELEVANT THREAD.

I tapped into excel via the vb.net component http://www.thediscontinuum.net/iot-overview/2009/10/30/definitions-...

I am using this as a basis for generating simple squares based on excel data which represents area. The vb.net component is pulling two columns of data from excel, whose horizontal (row) relationship I would like to preserve in GH in order to create "square pairs" which share a center point and have variable area. The bond of these pairs could be established through lofting or grouping.

The problem I am encountering is extracting the data sets pulled from two columns of excel into lofted pairs in GH. Pathmapper + Weave seems like an option, but I can't seem to get the right structure through the source/target dialogue in Pathmapper.

Check out the attached files - open the excel file along with the GH definition ( you may need to recompute or establish new connections between the vb.net component and the "pow" component).

Attachments: