Nice video. Everything is well explained (except you can't read the code in the video but you already addressed this). But it's using the method i hoped it didn't use! (Last post of this thread: http://groups.google.com/group/grasshopper3d/browse_thread/thread/7eb21ff7630b0352/ ) Nevertheless, i was wrong in that post. I thought some parts wouldn't update correctly, but obviously if you include the point in the scripting component and only that scripting component reads the excel data, you only need to update the scripting component (and its connected components) and not the whole definition.
I wanted to try this to connect my digital piano to grasshopper real time. Unfortunately it looks like there is some considerable lag (from watching the video) when updating using this method. Still, i'm want to try it since it may still be fun. So after all this whining and complaining, is there a chance you will post the code? :P On Jan 30, 3:33 am, damien_alomar <[email protected]> wrote: > Thanks guys, glad you like it. I didn't realize that the video was > that long, but I guess thats what it takes to explain what's going on. > > Jonas, > > you certainly could send the UUID of the point from Rhino, and to be > completely honest I didn't even think of it. However I don't think I > necessarily think its 100% that simple. Because that sheet has a > change event with it you have to be very careful with how you write to > it. When you just sit there and change something that's fine, but if > you have a script that writes to it, then you have the potential to > get in a bad loop of a script writing to a cell, firing a change > event, then that event firing the same script to write again, thus > firing another change event, and it just spirals out of control. > Therefore, anytime you'd write that UUID to a cell (which, off the top > of my head would be the best way to grab the ID of the point) you'd > fire off that change event and start that chain reaction. > > There is a way to suspend events when writing to Excel and the link > that I posted at the bottom of the post talks about it. It would > certainly be possible (probably through a separate GH component) to > suspend change events in excel for the time you write the UUID into a > given cell and then reinstate events. Suspending events was > something that I was looking into for a complete connection the read > from excel and "simultaneously" wrote information back into excel, but > I haven't really spent too much time on this yet. > > Ultimately this was about keeping it as simple as possible, and the > first one I actually got working was quite a bit more complicated, so > I was glad I was able to get it as simple as it is. > > Best, > Damien > > On Jan 29, 4:44 am, baldino <[email protected]> wrote: > > > that's great ! > > but isn't there a way to retrieve the point's uid through Vb.net and > > send it to excel through GH ? would be a bit easier than copy pasting > > it through the what command ;-) > > >http://en.wiki.mcneel.com/default.aspx/McNeel/SDKGetUUID > > > i'm not very good in .net so i may be wrong here... > > > On 29 Jan., 09:44, fraguada <[email protected]> wrote: > > > > Awesome Damien...your explanation is very much appreciated. > > > > luis > > > > On Jan 29, 4:40 am, damien_alomar <[email protected]> wrote: > > > > > Alright guys, Part 2 of the GH <-> Excel connection is up. This part > > > > details how to get excel data into grasshopper, but mostly it focuses > > > > on how to create this link dynamically. Take a look and read up if > > > > you want too... This was my first screencap video, so its not as > > > > "polished" as I'd like, so hopefully it will be a little better next > > > > time. I thought the code itself would be visible in the video, but > > > > not really, so I might post some of the code in a subsequent post. > > > > Thanks again for taking a look > > > > > liquidtectonics.blogspot.com > > > > > Best, > > > > Damien > > > > > On Jan 26, 5:59 pm, visose <[email protected]> wrote: > > > > > > I was trying this definition and got the error 0x80028018. > > > > > Apparently, it's a known bug present in excel. In case someone else is > > > > > getting this error: > > > > > It's caused when you've got an english language version of office and > > > > > windows regional settings set as non-english. The easiest way to fix > > > > > this is setting the regional settings as english, but there are other > > > > > workarounds. > > > > > This page lists the causes and > > > > > workarounds:http://support.microsoft.com/default.aspx?scid=kb;en-us;320369 > > > > > > On Jan 24, 6:25 pm, Splash <[email protected]> wrote: > > > > > > > I do not know about Openoffice Calc. The OpenOffice forums seem > > > > > > active. Perhaps you can post the code snipet to the OpenOffice > > > > > > forums. It would be cool to see if we could get it to work there > > > > > > also. > > > > > > > On Jan 23, 9:24 pm, CAD-NY <[email protected]> wrote: > > > > > > > > No way to use OpenOffice's Calc? > > > > > > > > On Jan 23, 2:38 pm, Splash <[email protected]> wrote: > > > > > > > > > I have been looking for a way to work with Excel in > > > > > > > > GrassHopper. I > > > > > > > > found some information on Damien's cool new blog: > > > > > > > > >http://liquidtectonics.blogspot.com/ > > > > > > > > > Based on Damien's information I put together a few samples of > > > > > > > > Rhino > > > > > > > > reading Excel data. You can download them at: > > > > > > > > >http://en.wiki.mcneel.com/default.aspx/McNeel/GrassHopperGallery.html... > > > > > > > > > Have fun.- Hide quoted text - > > > > > > > > - Show quoted text - > >
