can not open them, he says: "file read failed".
Is it possible that it is because I work with the updated version of Pachyderm in September 2017? (and not the last one I saw you put in December 2017?).
If not, what can it be?
Thank you again,
Kind regards
Giulia…
nd then writes some data to a certain range of cells, but currently I am missing the small bit of code to save the file and then close that certain excel workbook. One other thing to note is that I'm writing into another excel file concurrently from another set of VB componenets, which must remain open, so I don't want to save & close that file. - Only the file which I'm writing data to from this VB component needs to be saved & closed. Any help would be appreciated.
Here is the current bit of code:
Rhino.Runtime.HostUtils.DisplayOleAlerts(False)If _write = True Then'Dim val As DoubleDim row As IntegerDim column As IntegerDim Pole As StringDim Angle As DoubleDim cellValue As StringDim rowstart As Integer
Dim xlApp As ObjectxlApp = System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application")Dim wb As Object = xlApp.Workbooks.Open("W:\Bay Bridge Aiming\Knuckle Plate Aiming\Re-work_Field-Aim_20m.xlsx")Dim sheet As Object = wb.Worksheets("Factory-Aim")
rowstart = 0
Dorowstart += 1cellValue = sheet.cells(rowstart, 1).valueLoop Until cellValue = ""
row = rowstartcolumn = 1For Each Pole In Pole_IDsheet.Cells(row, column).value = Polerow = row + 1Next
row = rowstartcolumn = 2For Each Angle In KnucklePlt_Anglesheet.Cells(row, column).value = Anglerow = row + 1Next
End IfA = 0
Much thanks,
Joel…
Added by Joel DeBoef at 12:29pm on October 23, 2012
dim xlApp as Excel.Application
dim xlRange as Excel.Range
xlRange = xlapp.Range(Cells(1,10))
Whereas it seems in Rhino, and with using the SDK, you would have to first create your plug in and create a custom call within a class in your plug-in which inherits the MRhinoCommand class and give a unique GUID to this call - "get points" for instance. This class also becomes a command line in Rhino which can be accsessed by typing "get points".
In other API's/SDKs ive used you dont have to do this. You access the program directly based on the object for each application using COM. This may be because these programs dont use command lines.
Am I missing something? WHen you call your commands you still have to run the command using rhino script I presume form within you external dll to get the data form Rhino?…
ight. Note that i added the Ladybug component to simplify the inputs...
Here are some functions i'd love to see:
1. Ability to cull down to a partial year / date range AND hours range. Currently the DSchedule component can only truncate time of day. But if for example i want to look at averages just during the summer months between 9am - 6pm, i have to do that in the excel .ill file. It seems that the components may allow this already, just not sure which settings need to be set (seems that the reporting frequency has something to do with this...)
2. I'd also like to be able to look at a subset of the points to look at averages in a part of the grid. The easiest i presume would be just to pull item #s; maybe there's a way to add visual identifiers to the selection option? Again, have been doing this in the .ill file.
3. Provide, as an alternative to the .pts file, the option to input the point geometry directly from the rhino file - maybe this would help with #2?
4. I read up on your explanation on showing point-in-time values but can't seem to get that working. Would love to be able to do slider animations of the point-in-time calcs over a day like the bottom right of this (here i used Ladybug but the DA output would be more accurate).
5. Visualization Bounds doesn't seem to work on the daylighting side - would like to be able to manually change.
6. Showing the peaks is a fantastic addition! But all that information is bundled in the python script - would love a way to parse it out to just show the peak numbers for example.
7. Similarly to how DIVA shows data, it'd be great to add a component that visualizes the simulation parameters and color scale in the Rhino viewport...:)
i'm sure there's more as i continue to use it...
great script.
dan
…
he two, including project information, materials, etc.
I'm looking at embedding Ecotect information within VB (or possibly C#) components and was looking for the most efficient connection.
It looks like I have 2 main options:
1. XML database-centric model of which both GH + ECO write to the XML document.
2. LUA scripting from within GH and ECO.
XML would be the first choice as it seeks to contain data purely outside of both apps, however, the redundant code that ECO needs to read / write gbXML files may be a headache to script the content.
Another question I had was to whether I can populate data (such as weather, location, materials, etc) directly from the Ecotect libraries (.lib) to feed into the GH components or would I need to decompile these first.…
ata to excel. What is the most effective way to do so?]
TNX!
my function:
Format("sky, {0} ,ground, {1} ,sidewalks, {2} ,trees, {3} ,offices, {4} ,commerce, {5} ,buildings, {6}",sky,Ground,Sidewalks,Trees,Offices,commerce,buildings)
i tried to use the VBscript from this discussion, but it didnt went well:
http://www.grasshopper3d.com/forum/topics/how-to-add-enter-in-a-text-grasshopper-to-processing
…
nes. I haven't tried any of the other family components yet. Here are the problems I am encountering.
1. Units- apparently everything is decimal feet, and on the to-do list?
2. Data formatting in excel:
This seems to be very inconsistent, and I don't quite understand how this works. If I have an arc-like curve, it reads it as a nurbs curve, even thought it is an arc-curve. Are all curves recognized as interpolated / nurbs curves?
Then, I have issues with the data formatting in excel. Basically, I have 8 profile curves, but 16-17 lines of data for these curves.
The curves I am attempting to bring in are not complex (a rectangle with filleted corners) but the model-builder in Revit either hangs on the first floor, or fails to create the extrusions at all. I was able to bring a single floor (rectangle only) in, but that was it.
Anyone experiencing similar issues / have a fix?…
weights using Human:
1. Line thickness in Grasshopper Display. For this, use the "Custom Preview Lineweights" component, and supply the lineweights you want and the curves/lines you want to display. It has two modes - Relative (the default) where the supplied number is a pixel width, regardless of zoom, and Absolute, where the supplied number is provided in the units of your document, so that a line will always display as "20 cm" thick and scale with your zoom.
2. Line thickness in Rhino object Attributes. For this, use "Create Attributes" and supply your desired lineweight to the "plot width" input - then feed both these created attributes and your geometry to a "Bake" component. This will bake your geometry to the Rhino doc with the proper plotweight - which will show when you print, or if you enable "PrintDisplay" in the rhino command line.
Hope this helps - if not please supply a little more information so I can get closer to the problem at hand.…
)... the data is like that:
lat
long
+37 35.9040
-000 58.6545
I want to draw the track points and I have done a try, (using google earth refernce points with decimal degrees ) following the discusions I found in gHowl forum, but I dont know what I'm doing wrong....
I hope you could help me soon!!!...
thank you!
Carlos B.M.…
Added by Carlos B.M. at 10:02am on January 1, 2013