Skip to main content
1-Visitor
October 30, 2012
Solved

Can Creo 1 import excel x-y or point data to form a curve?

  • October 30, 2012
  • 3 replies
  • 9989 views

Hello all,

Let's say I have a bunch of X - Y data that forms a complex curve in Excel. Just 2 colums of data.

Now let's say, I want to bring that data into Creo 1 (M40), how would I do that?

Do I need to convert it to a CSV file?

Do I need to convert it to a 2D cad file first?

Do I need to use a special file with special syntax?

I need to take this data, probably as points and then form a datum curve to form a surface.

What do you think the easiest way to do this is? Keep in mind the original data is in Excel spreadsheet format.

Thanks in advance!

Peter


This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.
Best answer by Peter1

I have found an answer myself....

Search in the help section "To Read in Spline Coordinates from a File" or look for .pts file.

It works great. Thanks me.

Peter

3 replies

Dale_Rosema
23-Emerald III
October 31, 2012

From what I gather by this product suggestion, there is not a point table:

http://communities.ptc.com/ideas/1446

Thanks,

Dale

Peter11-VisitorAuthorAnswer
1-Visitor
April 16, 2013

I have found an answer myself....

Search in the help section "To Read in Spline Coordinates from a File" or look for .pts file.

It works great. Thanks me.

Peter

17-Peridot
April 16, 2013

There is also a way to do this with exporting curves to IGES and re-importing them as points. Very archaic.

But yes, in your case, formatting the data into a points file is relatively straight forward.

Peter11-VisitorAuthor
1-Visitor
April 16, 2013

Why would I export the data and then re-import it back in if I already have the geometry in Creo? The original question was how to import non-CAD points into Creo.

Patriot_1776
22-Sapphire II
April 16, 2013

Hey, no fair asking a question, and then answering it just to get the 3 points!

Peter11-VisitorAuthor
1-Visitor
April 16, 2013

Trust me, I wish I had found this out 6 months ago...