brudgers Posted January 18, 2010 Share Posted January 18, 2010 I want to read from a worksheet without creating an image of the worksheet on the drawing, but cannot find a way to get a handle to it. Quote Link to comment
Kool Aid Posted January 18, 2010 Share Posted January 18, 2010 I know how to do it. How much are you willing to pay for me to tell? Quote Link to comment
brudgers Posted January 18, 2010 Author Share Posted January 18, 2010 Well I found a kludge (I think); http://techboard.nemetschek.net/ubbthreads/ubbthreads.php?ubb=showflat&Number=54572&Searchpage=3&Main=12755&Words=%2Bworksheet+%2Bhandle&Search=true#Post54572 Anyone got a better way? Quote Link to comment
Kool Aid Posted January 18, 2010 Share Posted January 18, 2010 How much will you pay for the better way? Quote Link to comment
JBenghiat Posted January 18, 2010 Share Posted January 18, 2010 Before this thread devolves to a state worthy of moderator intervention... If you know the name of the worksheet: worksheetHandle:=GetObject('Name_of_worksheet_in_Resource_Browser'); -Josh 1 Quote Link to comment
Vectorworks, Inc Employee klinzey Posted January 18, 2010 Vectorworks, Inc Employee Share Posted January 18, 2010 brudgers, Just use h := GetObject('WorksheetName'); Where 'WorksheetName' is the name of the worksheet. You don't need an image to get the handle to the worksheet just the name of the worksheet. Quote Link to comment
Kool Aid Posted January 18, 2010 Share Posted January 18, 2010 Hello! When will I ever get free support of this kind? Why does NNA support one commercial operator and not another? Looks like a vectorscirpt job. How much would you pay for it? Quote Link to comment
brudgers Posted January 18, 2010 Author Share Posted January 18, 2010 Many thanks. Quote Link to comment
Kool Aid Posted January 18, 2010 Share Posted January 18, 2010 Did you pay? Do you even have VW 2010? Quote Link to comment
brudgers Posted January 18, 2010 Author Share Posted January 18, 2010 Hello! When will I ever get free support of this kind? Why does NNA support one commercial operator and not another? Looks like a vectorscript job. How much would you pay for it? I was referencing several aspects of the Vectorworks community in the other thread: 1. That the requested feature was probably doable in Vectorscript. 2. That the work entailed in doing so was slightly more than trivial. 3. That requesters tend not to place a value on their request. 4. That there are probably people who could and would code it if there was a market for it. 5. That there probably is not a market for it. I'm sure you could code it more quickly than I can, and I doubt - to the degree that a pattern of past events predicts future events - you would code it gratis. Commercial development of Vectorscripts I suspect is quite limited since...as you know...there's really no good way protecting scripts. That's not to say commissions aren't viable, but writing for sale scripts is pretty much dead...you can encrypt them and protect your code (at least from someone who doesn't want to be bothered cracking what appears to be very simple encryption) but you can't really keep people from sharing it broadly. So for sale scripts have to be priced high enough to earn a return from a few honest people rather than everyone who uses it...which drives down sales volume...which discourages development. BTW, anyone who wanted such a script could pay for it with their own time writing it. Quote Link to comment
Kool Aid Posted January 18, 2010 Share Posted January 18, 2010 you can't really keep people from sharing it broadly. But I can! You can't. Quote Link to comment
brudgers Posted January 18, 2010 Author Share Posted January 18, 2010 (edited) Well I supose I could too if I tied each copy to the last six digits of the user's serial number at compile time. Of course that means more work on the fullfillment side leading to a higher cost to produce, a higher price, and therefore lower sales. There are some nice utities out there for 20 bucks or more, but people aren't inclined to buy them. Partially, it's just the demographic for Vectorworks is already inclined not to spend money...otherwise they'd probably be using ArchiCad, AutoCAD, or something in a similar price range. Edited January 18, 2010 by brudgers Quote Link to comment
brudgers Posted January 18, 2010 Author Share Posted January 18, 2010 Actually I should reprhase that: It would substantially be more work for me on the fullfillment side since NNA doesn't provide any interface to Windows which allows automation of the Vectorscript compile cycle. Despite all the pablum about equal platform support. Quote Link to comment
lucioing Posted February 9, 2022 Share Posted February 9, 2022 On 1/18/2010 at 3:32 PM, JBenghiat said: worksheetHandle:=GetObject('Name_of_worksheet_in_Resource_Browser'); You can't imagine, how helpful has been your answer! Thank you so much L. 1 Quote Link to comment
lucioing Posted February 9, 2022 Share Posted February 9, 2022 Now... what if I need to get the name of the selected sheet? Or get the Resource name? Thank you L. Quote Link to comment
lucioing Posted February 9, 2022 Share Posted February 9, 2022 Anyway... I wonder: why, it doesn't works? SelectObj(T=WORKSHEET); WS_Handle:=FSActLayer; ObjectName:=GetName(WS_Handle); L. Quote Link to comment
MullinRJ Posted February 9, 2022 Share Posted February 9, 2022 @lucioing, GetWSFromImage(FSActLayer); { will return a handle to the WS Resource, when FSActLayer points to a worksheet image on the drawing. } GetName(GetWSFromImage(FSActLayer)); { will return the name of the WS resource, when FSActLayer points to a worksheet image on the drawing. } HTH, Raymond 1 Quote Link to comment
lucioing Posted February 10, 2022 Share Posted February 10, 2022 Hi, Raymond! It does works fine! Thank you so much! This is the very first time I manage the WS via Vectorscript... Thank you again! Have a nice day Lucio PS. HTH... Of course! A great help! Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.