Excel to Rhino Script

[spada.giovanna (Giovanna)]

Hello,

I’m using Excel VBA for a project, which will generate a lines plan data on a worksheet.
My idea is to press a button on excel that will lead all this data to Rhinoceros. Then, I entend to work on Rhino Script to generate surfaces and everything with this point cloud.

I’m new to Rhino Script, but I’ve been working on VBA already…
Is it possible to develop this idea?

Do you guys have any information/tip for me?

Thank you

[dharman]

See this thread. There are examples

Rhino 6 COM Interface

Hello, Our program uses Rhino via COM interface using C#. In Rhino 5 it worked fine, but it doesn’t work in Rhino 6. A simple sample programs are shown below. In Rhino 5, it works fine: Type type = Type.GetTypeFromProgID("Rhino5x64.Application"); if(type == null) { MessageBox.Show("Cannot find the COM type of Rhino5x64.Application"); return; } else { try { object obj = Activator.C…

[dharman]

See this too
https://developer.rhino3d.com/api/rhinoscript/introduction/external_access.htm

[Ncik]

If you just want to get points from excel to rhino it is simpler than writing code. Although writing the code will help with learning for other uses.

1. In excel, fill in columns for x, y & z data
2. Create a single column with concatenation of the coords into “x,y,z”
3. Copy the column of “x,y,z”
4. In rhino, start the “_Points” command
5. Paste

The extension to this that can be achieved with rhinoscripting is that you can assign colours, names and layers to the points so that it is easier to group them for developing your curves and surfaces later.

There’s also this method.

Import from Excel

You cannot import data from an Excel file using basic Rhino import modules, however it can be done with a script. Oftentimes if it’s just a file containing point coordinates though, it’s easier to export it as a .csv which Rhino can import directly as point objects if the csv is formatted correctly. –Mitch