Great stuff Luis. I particularly like grabbing the color from the Excel cell. My goal was to just to open the gates for the Excel connection not to lead the charge as to what it could really lead to. Its really great to see it in action other than the horrible point formulas that I used in my video example.
Best Regards, Damien On Feb 19, 12:44 pm, fraguada <[email protected]> wrote: > Hey Damien... I messed a bit with your definition and wrote a very > simple value filter... > > http://groups.google.com/group/grasshopper3d/web/thumb.pnghttp://groups.google.com/group/grasshopper3d/web/LaN_excelField.zip > > Zip file has a sample excel and the definition... > Posted some further examples on our site:http://www.livearchitecture.net > > Could be useful for someone? > Luis > > On Feb 1, 5:45 pm, damien_alomar <[email protected]> wrote: > > > I would say that its certainly possible, but I have no idea how to do > > it. I would imagine that it would be quite "messy" since you'd have > > to parse the file yourself. The one thing I can suggest is to simply > > "hide" the excel file so that its not visible. You could write a > > special component to open an instance of excel that was hidden and > > load up a given file...then have the one that actually reads the file. > > > This was the only link that I found after a quick search that seamed > > any goodhttp://www.dotnetspider.com/forum/ViewForum.aspx?ForumId=28885 > > > -Damien > > > On Feb 1, 8:15 am, baldino <[email protected]> wrote: > > > >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: > > > > > > > > > AwesomeDamien...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 onDamien'scool new blog: > > > > > > > > > > > > > >http://liquidtectonics.blogspot.com/ > > > > > > > > > > > > > > Based onDamien'sinformation 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 -
