r formatting parameters, color, size, etc. from Grasshopper to Excel. Additionally Excel Charts can be produced directly from Grasshopper with a series of custom formatting options.
You can find the file at: http://neoarchaic.net/2011/01/gh-excel-suite/
It is based of the work by Damian Alamar of www.liquidtectonics.com
I hope you enjoy, find it useful, and look forward to any feedback, suggestions.…
Hi,
I have the same problem
I am using Windows 7, Excel 2010, Rhino 5, GH 0.9.0014. Both files are unblocked and in the same folder.
Any suggestions?
Thanks!
to associate via row. Some snaps to show what I mean:
I'm trying to make Column A represent the panel number from tree branch #1 (red), and then have the point sequence from branch #2 (red) become Column B.
Basically, I'm just not sure how to isolate those numbers in their correct sequence to be exported to Excel. (If it makes any difference, I am using Bumblebee as the exporter).
Many thanks,
-Ben
…
eterminate index that I will need to determine the mesh topology according to the output list from an FEM software.
how can I assign a determinate index to a list of point? what is the difference between list and monodimensional arrays?
here I post my code and a screenshot of the excel file I am working whit:
as you can see in the code I was able to turn the input cell content in a index, but then i do not know how to assign this as index to the determinate point of the list.
I have another question: because the FEM software starts to assign the index point from 1001 I was wondering if the list of point uses the first 1000 entries and, even if this entries are empty, do the list allocate some memories for these empty entries?
protected override void SolveInstance(IGH_DataAccess DA) {
string path = null;
if (!DA.GetData(0, ref path)) return; int sheet = 0; if (!DA.GetData(1, ref sheet)) return; ClosedXML.Excel.XLWorkbook workbook = new ClosedXML.Excel.XLWorkbook(path); var ws = workbook.Worksheet(sheet);
//This for-cycle reads the quad mesh point and WIP creates an index consinstent list of these
List<Point3d> meshPoints = new List<Point3d>();
for (int i = 2; i <= ws.LastCellUsed().Address.RowNumber; i++) { GH_Path p = new GH_Path(i - 1); GH_String cellData = new GH_String();
int index =new int(); cellData.Value = ws.Cell(i, 1).Value.ToString(); index = int.Parse(ws.Cell(i, 1).Value.ToString());
Point3d meshPt = new Point3d(); cellData.Value = ws.Cell(i, 2).Value.ToString(); meshPt.X = double.Parse(ws.Cell(i, 2).Value.ToString());
cellData.Value = ws.Cell(i, 3).Value.ToString(); meshPt.Y = double.Parse(ws.Cell(i, 3).Value.ToString());
cellData.Value = ws.Cell(i, 4).Value.ToString(); meshPt.Z = double.Parse(ws.Cell(i, 4).Value.ToString());
meshPoints.Add(new Point3d(meshPt));
}
DA.SetDataList(1, meshPoints); }
thanks a lot in advance for your help!
Matteo…
Excel plugin components but will GH 2 have its own? And has GH1 got an approved plugin component in your opinion?
I am letting others use the GH interface and remote control, and excel is another simple interface... and is connected to the future of design, as Phillipe Starck suggested which he believes will make us design 'coaches' and 'trainers' to hold the hands of the manufacturer or the end user and GH is emerging (for me) as the key. The skill I believe is choosing the best design drivers in the modelling and geometry, and I feel programmers will pride themselves in creating useful domains or ranges for clients to pick solutions from.
But how to do it now with GH1..? I have a handful of clients crying out for the simpler interface, so excel is important now (with live update). Any pointers would be good.
Thanks for the support.
J…
mensional constructs.
I'm really clueless at the moment on how to achieve the latter. I have compiled 3 excel datasets of my chosen painter - Rembrandt, in terms of his paintings and year they were produced, location coordinates of the places he lived and visited before, and paintings' location coordinates.
Is there any script file or tutorial that I can refer to? I have been trying my best to search for it or I can't find anything relevant.
I have attached two images to show the output of the task I'm supposed to produce. They depict the relationship between artificial and public spaces in the world, shown as 2D and 3D diagrams produced in Grasshopper and rendered in Rhino.
Any help is genuinely appreciated as my deadline is around the corner.…
Added by Richard Teh at 4:26pm on December 29, 2013
n esp. at the desired grid density.
My question is that is there a way I can save the results for future editing purposes. In simple terms I want to use Legend Parameters to change the display (gradient, low high bounds, etc.) when required. I have been searching on the forum but could not find anything.
What I tried is to bake the mesh and re-select it in gh, copied the sunlight hours results for that mesh in excel and pasted them back in a fresh panel... plugged the mesh and the results panel in custom preview with a gradient.... but the preview doesn't seem to match the original results mesh (test sample attached).
So is there any way I can save my analysis results and use it in future to process as required. I don't want to re run the analysis every time.
Thanks!!…
ch Grasshopper's default folder and you will find the file.
4. You can overwrite the defaults using several setThisandThat components. If you want to create your own program from scratch then you need to deal with text files and create your own. We don't have an automated process for that right now.
There is an excel file here that is used to generate .json file > https://github.com/NREL/openstudio-standards/blob/develop/resources/OpenStudio_Standards.xlsx…
i.mcneel.com/developer/dotnetplugins
(and there is a c++ version).
The way I've set up all my software structure is it's primarily driven by the C# rhino plug-in dll, including calling this library from my grasshopper components. No interaction with the command line. If you're trying to control Rhino externally (from say excel environment) then I believe COM is the only way to do so.
If the above doesn't make sense, I think we need to see a small example of your command line programming to point you in the right direction.
Cheers,
Jon…