cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X

How can I read in an Excel spread sheet into CreoPro5

mrubino
1-Newbie

How can I read in an Excel spread sheet into CreoPro5

How can I read an Excel spread sheet with x,y,z coordinates into CreoPro5 to create a section?

1 ACCEPTED SOLUTION

Accepted Solutions

Michael,

The file was a big help!

When I open a new part file and select "Offset CSys Datum points" the import button is grayed out. What am I missing?

Thanks again!

MikePresentation1.gif

View solution in original post

8 REPLIES 8

Make 4 columns Nr. X Y Z and type in the data.

Save as txt file with tabstop.

Open the txt and replace "," with "."

Put a blank behind each number

Save and rename the file to .pts

This can be read from Pro/e

Hope this helps

Hi Michael, Thanks for answering my Excel question.

Could you also explain how to read this Excel file into Creo?

Is there any online information about this subject?

I'm a new Creo user, formerly an I-Deas user.

I appreciate your time,

Mike

Hello Mike,

let see if I can help you.

In the attachment I put a .pts file that you can see how it is formatted.

Here a screenshot how to get in Creo (I use Creo Elements/Pro in german)

1.JPG

Choose Import and then the .pts file.

That's it.

Michael,

The file was a big help!

When I open a new part file and select "Offset CSys Datum points" the import button is grayed out. What am I missing?

Thanks again!

MikePresentation1.gif

Hello Mike,

you have to select a reference Csys in the "Reference" field.

Then it works.

Brgs,

Michael

That worked!

Thank you

I was going to post this question also but thought I'd ask you first.

Is there way to connect these points or bring in these points as a multi point spline?

What I'm trying to do is use these points to create sections. From these sections I wanted to use "Boundary blend" function to drive a surface through these sections. When finish I was going to use "solidify" the make the surface into a solid.

Should I post this again?

Mike

you can use the curve trough points button.

See the part i added.

1.JPG

Thanks, for all your help I think this should work!

Mike

Announcements
Business Continuity with Creo: Learn more about it here.

Top Tags