How can I read in an Excel spread sheet into CreoPro5

[mrubino]

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

[mmueller-2]

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

[mrubino]

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

[mmueller-2]

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)

Choose Import and then the .pts file.

That's it.

[mrubino · Accepted solution]

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!

Mike

[mmueller-2]

Hello Mike,

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

Then it works.

Brgs,

Michael

[mrubino]

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

[mmueller-2]

you can use the curve trough points button.

See the part i added.

[mrubino]

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

Mike