Hey Damien... I messed a bit with your definition and wrote a very simple value filter...
http://groups.google.com/group/grasshopper3d/web/thumb.png http://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 -
