I am trying to figure out how to use Excel as a dynamic diagramming tool. The idea is that I could use incoming data to draw certain relationships, say floorplate locations, on top of which I could draw, lets say opening locations which would then trigger certain code.
Its fairly easy to convert formating, a cell with a certain color, to code, so in a way I would be using excel as a super basic cad program to manage lists of data.
In order to do this I need to be able to call some Excel commands from Rhino and to add some functionality to LAN's rhino to excel script (http://www.livearchitecture.net/archives/1516
I would like to be able to get the Ubounds and dimension of an array or a list. . . ie somehow get the equivelenat number of rows and columns of an incoming list of data and then use this to generate some graphics in excel but . . . .
It seems that the sytax for excel Vb script via interoperability
marshaling is a bit different:
1)I can not use
the set command ie Set range
2) it does not allow me to use the typical excel
syntax such as:
I get the following errors
Error: Method arguments must be enclosed in parentheses. (line 114)
Error: Name 'xlThick' is not declared. (line 114)
Is their an alternate way to write the Excel commands? Or is there something I need to do in Rhino? Any advice would be appreciated.