its probably worth.
The easiest way to read Excel files would be through gHowl, which is a collection of interop componets. You can check out the post below for more info, but just send a request to gHowlcomponents[at]gmail[dot]com and we'll get you set up. We've got some example files that come along with it, but I've also got an example that I've cooked up for your specific case that I'll send along as well.
http://www.grasshopper3d.com/forum/topics/ghowl-interoperability…
ings" [every person on the experiment is one ring] which show the time duration. The outer sphere is divided in 11 segments [which are basically the segments of a human brain] I hav imported the data so far but what i aim is to find a way to connect each moment[time, second] from the inner sphere to a number of points from a specific segment in the outer. For example for Person number1, at 5th second the segments that are activated are 4th , 6th, 11th with 2, 3, 2 points.
It could be done manually but since the connections are a few thousands and i got the lists, i wonder whether there is a better way.
Any help is appreciated, i do not attach files since you need the excel files aswell. If anyone would like to help i can email the files.
Thanks in advance.…
I can't really see any reason why your code wouldn't work (except possibly the way your setting the range, but I'm not sure). Since the connection to excel is just going through COM as opposed to referencing the proper libraries, or working directly in Excel, there's likely some methods that won't work as expected (sorry for thinking that they would...I haven't run into any, but its obvious that you're doing things differently that I have).
My best advice would be that if you keep away from "complex" variable types (anything other than a string or a number would be considered "complex" here), then you'll have better chance for success. Personally, I always write my cells one by one using the Cells(intRow, intColumn).Value method. It may require a few more lines of code, but its always worked for me. I suspect that trying to pass the array through COM is not working and throwing up an error.
As to using excel constants, you just can't do that unless you have a reference to the excel library. Since you don't here, then only way to do this would be to use the actual enumeration value that the constant represents. There's a list of these somewhere, so I'll try and see if I can track them down.…
Added by Damien Alomar at 10:06am on February 28, 2010
eady there for EnergyPlus. I assume you are asking for the daylighting component. I will consider to provide it. It could be really useful. I'm thinking to do something similar to TT's export to excel component: (http://www.grasshopper3d.com/video/animated-writing-of-grasshopper-data-in-excel)
4. I'm planning to use OpenStudio Libraries for Honeybee so you will be able to apply more than only ideal system. They already have the standard ASHRAE systems implemented which is pretty cool. You should be able to customize all the inputs that you said. Very good point!
-Mostapha…
ngs work manually, but I can't think of a way to filter through the branches with a step of 2.
What I would like to do is go through the branches like photo and example below. This is important because the amount of points varies in some branches. The image shows the logic.
{0}
{1}
Create points, etc etc
{2}
{3}
Create points, etc etc
{3}
{4}
Create points, etc etc
Hope that is clear.
Under the pump,
Liam…
in that particular file.
Something else, maybe useful for others too.
There is a gotcha in Excel to create the semi colon separated values as export, because within Excel options is not possible to do it (or at least I was not able) So it is needed to go to the Control Panel:
1. Control Panel2. Region, Region and Language Option3. In Tab Format, click customize this format4. List separator, change from comma (,) to semicolon (;)5. Ok, -Finish-
Then the usual things with Excel, save the file as CSV and it will be saved with the ";" separators.
Credit to this guy where I found this:
https://social.technet.microsoft.com/wiki/contents/articles/10305.how-to-convert-format-excel-to-csv-with-semicolon-delimited.aspx
Regards, Balazs…
uld 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:
Worksheets("Sheet1"). Range("A1:D4").BorderAround
ColorIndex:=3, Weight:=xlThick
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.
Best,
Ben…
Added by Ben Fortunato at 11:10am on February 27, 2010
do its thing, but that should be easy enough.
So there is Lunchbox, which has some great components for Excel stuff (and many other cool things)
Also gHowl has Excel read/write components
And I am certain I have seen more as well, but those 2 should be sufficient.…
Added by Armin Seltz at 7:21am on September 8, 2016
cy of design communication and the control of information-flow are as important as the creativity of ideas. In response to the concurrent digital evolution emerging in the architectural industry world-wide, the Faculty of Architecture at The University of Hong Kong will host a two week intensive summer program named Digital Practice.Led by professors from The University of Hong Kong, as well as invited practitioners with expertise in practice of cutting edge digital techniques, the program offers participants opportunities to experience applications of computational tools during different stages of an architectural project, i.e. concept design, form finding and optimization, delivery, management and communication of design information under the team-based working environment. By learning advanced computational techniques through case studies in the context of Hong Kong, participants are expected to go beyond the conventional perception of technology, considering users and tools as a feedback-based entity instead of a dichotomy. The program, which is taught in English, includes a series of evening lectures related delivered by teaching staff and invited local architects.對於高品質的建築專案,創意之外,專案過程中高效的設計資訊管理和交流成為項目設計深化和實施必不可少的環節。今天,數字化技術不但改變了建築師的繪圖工具,影響了設計的過程,而且提供了工程建造和管理實施的更有效、更高效的手段。針對建築的數位化演進,香港大學建築學院將於2011年暑假期間,在香港大學建築學院舉辦“數位化實踐”國際研習班。在香港大學建築學院教授及有著相關豐富經驗的外聘實踐建築師的指導下,學員將有機會體驗在專案的不同階段(如概念設計、設計形式的生成、優化,設計資訊的管理和交流),如何有效地應用各種運算智慧化技術(從設計的數位化生成和建築資訊類比到物理模型),提升設計實施的品質,增加設計團隊對於方案的控制。我們將挑戰對於“技術”的傳統認知,即相對於使用者它不僅是工具,更是與使用者互動的媒介,二者形成一個有機的合體。研習班期間會安排系列講座,展現數位化技術在實踐工程中的廣泛應用。…