points cloud

[Mirko]

I've been drawing an hull of the series 60, but my points are in a excel file, I don't want to copy them by hand, and I would create a points file to export under rhino, I tried to create three columns with the coordinates of the points, but rhino hasn't been able to open it...can you help me?

THANKS!

[Raggi_Thor]

You can create a script as a standard text file, it should look like
POINT 1,2,3
POINT 2,3,4
POINT 3,4,5
and so on

If you have three columns named x, y and z in excel you can make a new column with the formula = "POINT " & X &"," & Y "," & Z
or simmilar. This column can be pasted into the script file.
Then you can use the command LoadScript and RunScript.
After the point objects are created you can make it into a point cloud.

[DMacPherson]

One quick way to do this is to save your excel page as a CSV comma-delimited file. Save just the points in X-Y-Z in three columns - make sure there is no other text or data. (The first row needs to be data.) Then Open this as a Points file (CSV) in Rhino. It will create a point cloud. Check the Rhino help for "points file import". (I also use this technique to plot data with 3 variables for visualization.)

Don MacPherson

[Raggi_Thor]

Thanks Don, that seems to be a much faster way.

[Mirko]

I tried to save the points cloud as cvs file, but for exporting it in rhino all coordinates have to be in the same column...my coordinates are in three different colums, I tried to join them, but after the colums have been joined excel shows only the datas of the left side...

best regards...

forgive my english

[DaveB]

Hey,

Can you post the file? (text or excel)

I think it would be easier to help you that way...

Best regards,

Dave

[Mirko]

I've never posted a file...would you mind showing me the way...thanks!!!

[CGN]

Follow this:

"Post reply", click on "manage attachements" a small window will pop up and click on "browse", find the file that you want to upload (click "upload"), once is loaded, click on "close this window" and your file will be ready to be posted with your reply.

[Tim B]

Ok, copy all the values you need into a new sheet in excel. Save this sheet as a *.CSV file. Open it in Notepad, you should get:

xxx,yyy,zzz
xxx,yyy,zzz
etc.

If you are using Rhino 2 or 3 goto File->Import then choose "points file (*.txt,*.csv...." and select your file. You will get a dialogue box asking about the exact format, choose "Comma Delimited" and click ok.

If you are using Rhino version 1, edit the file so that...
Points
xxx,yyy,zzz
xxx,yyy,zzz
etc.
xxx,yyy,zzz
Enter

Then rename the file to *.txt Import it into Rhino using ReadCommandFile.

Tim B.

[Mirko]

I'm sorry for my late reply, but I was studing for the exam of security of the ship...Tim, I'm going to try the way you showed me...I'll reply soon!

BEST REGARDS

[Mirko]

Tim, I've to thank you, the way you showed me has worked!

BEST REGARDS!

MIRKO!