Extuding individual surfaces from data i

I am looking to extrude polylines by unique individual heights.

I have the buildings heights in an excel sheet and I want to extrude the polylines by that amount. All of them are different.

Would I take each polyline as a path in a data tree and extrude them as a series?? And somehow bifurcate the input data from the excel sheet to give them their extrusion distance?

I have 310 of these to do so if you could help you would be saving me hours of manual modelling work:)Thanks,

Replies to This Discussion

Permalink Reply by Nick on November 13, 2013 at 10:05am

I think you'll need to have both list match.

ie, item 0 in your excel file corresponds to curve 0

item 1 in your excel file corresponds to curve 1

...

item x in your excel file corresponds to curve x

Permalink Reply by John Egan on November 13, 2013 at 12:53pm

Yes that's right. But how do I take the info and apply it to the individual curves. is there a single function that can do this? I would usually use the list item component from the list of items in excel files and apply that as the input parameter for the same item in the curve list.

This will be far too lengthy of a process to do 310 times. Is there a more efficient method?

Permalink Reply by Nick on November 13, 2013 at 1:58pm

Assuming you're using gHowl:

Permalink Reply by John Egan on November 13, 2013 at 2:37pm

I just input this as a test path and I received the error;

1. Solution exception:The type initializer for 'ClosedXML.Excel.XLWorkbook' threw an exception.

Below, I have attached the grasshopper definition along with the .osm file that needs to be plugged in to the initial path at the far left of the screen. I am also using the elk plug-in.

thanks for your time!

John

Permalink Reply by Nick on November 13, 2013 at 2:56pm

Sorry John, but you have yet to attach the files...

Permalink Reply by John Egan on November 13, 2013 at 3:27pm

Very Sorry, the files were too big. They are uploaded here;

https://www.dropbox.com/sh/3jg4ardowc0wzpc/-NkvM9gCJK

Thankyou!

Permalink Reply by Nick on November 13, 2013 at 5:10pm

My bad, it's not *.xls, but *.xlsx which is an Excel Microsoft Office Open XML Format

You will have to convert your file to this format. Either use an online service or download and install Open Office, from which you will be able to use Open Office Calc to copy paste your data and save as an *.xlsx

I haven't personally tried, but apparently Office 2007 and above also gives the possibility to save to that format.

RSS