how to import Excel data i,e. points (x,y) ?? UG-NX4
how to import Excel data i,e. points (x,y) ?? UG-NX4
(OP)
I have the data in excel format, consisting of (X,Y) coordinates,
how to import this coordinate data into cad model?
plz help me.
how to import this coordinate data into cad model?
plz help me.





RE: how to import Excel data i,e. points (x,y) ?? UG-NX4
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)
RE: how to import Excel data i,e. points (x,y) ?? UG-NX4
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
RE: how to import Excel data i,e. points (x,y) ?? UG-NX4
RE: how to import Excel data i,e. points (x,y) ?? UG-NX4
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
RE: how to import Excel data i,e. points (x,y) ?? UG-NX4