Thanks visose. I thought the video was going to be available via Youtube's new HD option. I'll check up on how to get videos up there in HD since its much easier to edit the videos for HD as opposed to smaller resolutions.
As to the update method, I threw a few ideas around, but that was the only one that really worked. There were a few other hurdles associated with this one, specifically that the point had to be updated via a macro as opposed to a scripting method. Anyway, hopefully in the future David will add a way to regenerate the GH definition externally as opposed to tricking it. Maybe a "RegenerateActiveDefinition" command could be added. I'll go over and post the code on the blog now. Best, Damien On Jan 31, 1:24 pm, visose <[email protected]> wrote: > 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/7eb... > ) > 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 -
