Seperate paths to stream (excel)

Replies to This Discussion

Permalink Reply by Damien Alomar on October 5, 2009 at 9:57pm

Umm...how are u getting this into excel?

Permalink Reply by Theunis du Toit on October 6, 2009 at 4:25am

Ya, thats what I was wondering as well.

Permalink Reply by Vicente Soler on October 6, 2009 at 6:25am

Try the attached definition. To get it into excel, right click on the text panel and select 'stream content'. Name it something like "data.csv". Open excel. Go to the 'Data' tab and click on the 'Get external data from text' button. Select the file. On the second step of the import wizard select the semicolon as a delimiter. On the dialog window that appears after you click finish, you may want to click on "properties" and deselect "prompt for file name on refresh".

When you change parameters in grasshopper, the "data.csv" file will update in real time. If you want to see the changes in excel, you just need to click the "Refresh all" button under the 'Data' tab.

excel.ghx

Permalink Reply by Karl Kjelstrup-Johnson on October 7, 2009 at 3:49am

Hello,

Thank you for responce on this guys...the data comes in to excel following your method.

However I still need the formatting as shown in Image:

With each path holding a number of seperate values. I need to have the same numer
of coloums as paths. With each coloum holding the correct number of values .

Thanks again

Attachments:

• Excel_stream.jpg, 1 MB

Permalink Reply by Vicente Soler on October 7, 2009 at 4:34am

That's what it's supposed to do. What are you getting in excel?

Permalink Reply by Karl Kjelstrup-Johnson on October 7, 2009 at 5:13am

Hi Vicente,

Thank you I tried again and brings in perfect !!!
I really appreciate.

Karl