how to import Excel data i,e. points (x,y) ?? UG-NX4 3

[ravi1982]

I have the data in excel format, consisting of (X,Y) coordinates,

how to import this coordinate data into cad model?

plz help me.

 

[potrero]

try:

1. create a worksheet consisting of only the X, Y, and Z columns of data (no headers). If you don't have Z data, make a column of 0's equivalent in length to the X and Y data.

2. File > Save As > Save As Type > "Text (Tab Delimited)(*.txt)" > give it a name. This will write out a text tab-delimited file with the data points.

3. Change the file extension of the file you just created from *.txt to *.dat

4. In NX (Modeling): Insert > Curve > Spline > Through Points > Points From File (select the *.dat file)

 

[hudson888]

Ravi,

Potrero's answer is correct, but I'm not sure of your requirement from the wording of your question.

You can import point data from delimited text file into modelling using the steps he explains.

You can also create a table on a drawing of the co-ordinates using the drawing table function, and for that you can get the data from an excel file.

Cheers

Hudson

 

[cowski]

If you open your file in a simple text editor (eg notepad if you are on a PC), you will see that all the data is on one line. The method you used to export the point data apparently did not use the 'carriage return / linefeed' control character, rather it used some other delimiter that NX doesn't understand. If you have one point per line in the .dat file, it will work.

 

[NXdesign]

Hello,
I did the steps from potrero, and as a result I obtained an spline.
What I need is the points (non associative points).
I don't know if I had missed something.
Thanks

 

[cowski]

One way to get them back is by adding a 'point set'. Choose the 'spline defining points' option, pick the spline that was created through your points, and delete the spline.