Create Spline from MS Excel Imported Points in Siemens NX by Journal

Small vb journal to demonstrate how to import arbitrary points from MS Excel into NX work part and create a studio spline.
Sample excel file and the journal can be downloaded from here:
drive.google.com/drive/folder...

[@crystalman3239]

Thank you very much! You realy cool dude!

[@SabbelSeyl]

This is so great, thank you for sharing.

[@shin9877]

Hello I would like to ask, if I would like to position the curve (with only X and Y coordinates) on the datum that I've create (could be any angle), what should I write in the journal?

[@lemongraz8207]

Is there a way to modify the script, so that it get a spline that is G2-Continous?
I'm struggling achieving that, I would really appreciate any help! Thanks a lot!

[@CADTutorialsSGT]

Hello Lemon,
from the .net api reference for the AutoConstraintType enumeration:
Member name Value Description
None 0 No automatic constraint
Tangent 1 Tangent(G1)
Curvature 2 Curvature(G2)
CurvatureDerivative 3 Curvature derivative(G3)
Find the row in the script:
geometricConstraintData(i).AutomaticConstraintType = Features.GeometricConstraintData.AutoConstraintType.None
Change the None to Curvature and try to run the macro.
Hope this helps!

[@amatistacastaneda1881]

hey, do you still h ave the files? the link is broken. thanks!

[@CADTutorialsSGT]

Hello Amatista,
what do you mean on broken link? I've just tested the link now, I can see the files in the google drive folder and the files are downloadable. Can you see the files, or you have 444 error in your browser?