damien, thx for your answer, that made it clear, i have a question concerning your Excel<->GH scripts, is there a way to read an excel file from a vb.net component without having to open the Excel application
i know that what you want to achieve is real time updating from GH, but if i just want to read values from a spreadsheet without needing any realtime update, how can i do it without opening excel ? On Jan 31, 9:41 pm, damien_alomar <[email protected]> wrote: > 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 -
