I was actually going to grab the color, but did not get around to it...this would not be too difficult though, its just done in a preview comp...would condense things a bit to base it off of that...
luis On Feb 19, 11:57 pm, damien_alomar <[email protected]> wrote: > 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://grou... > > > 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 -
