I am attempting the same thing (inputting points into Catia v5r13 from an excel file). I searched for pointsplineloft and that turned up no results. I want to use the points to make a spline, so anyone have a more detailed way of doing this?
Search the Help Documentation files for Create Elements from an external file, this will explain it all.
"PointSplineLoft" is an Excel file that can be downloaded from there and inside it, select Enable Macros. On the front Excel Sheet is some sample data. Select Tools => Macro => Macros, this will open a list of several Macros, select Feuil.Main.
Run that Macro and this appears;
Type in the kind of entities to create (1 for points, 2 for points and splines, 3 for points, spline and loft):
In the already opened CatPart the Points whose coordinates are on the front sheet will be created.
This has all been covered in this Forum, see thread560-39970, Mar12 2003.
I did as you said and got the GSD_ElementsFromExcel.xls file, but what I ran the Feuil.Main Macro, choosing option 3, it kept reading beyond the "End" and the computer thought for a while. It stopped after a couple minutes and a message came up from Visual Basic saying "Overflow" and apparently it kept reading done to line 32,767 in Excel. I didn't modify the original file I downloaded, and I did have an existing .CATPart file open in Catia. Do I need to modify the Macro and tell it to stop reading lines? I have experience programming in C, but not in Visual Basic.
Greg, try using option 1 first, to load points. If that works, then option 2 for a spline. Don't use option 3 unless the submitted data is for more than one spline, the minimum to make a Loft is two section curves.
Eric, yes, the syntax on the Excel front sheet has to be exactly correct, in this case it is End.
Also, More Haste, Less Speed ...
Thanks for all your help, but I am stil having problems. At one point I could get all the points to plot (Option 1), but did not get a spline to form (Option 2). I started all over and now when I try to run the macro in excel (I have Catia running with a current .CATPart file), no matter which option I choose, a Microsoft Visual Basic message pops up and says "Object doesn't support this property or method." I am using v5r13, not sure if this makes a difference. I am also using Windows XP.
My guess is some lingo isn't correct. Online I found both a GSD_ElementsFromExcel.xls and an ElementsFromExcel.xls. While I don't want to use the loft feature I noticed in one it says StartLoft and in another it says StartMulti-SectionSurface. Can I just delete this since I only want to plot points and make a spline?
Greg, that's interesting, the same thing happened to me earlier this year when I tried to do this on a machine that was running V5 R12. Whatever I did it would not do any more than create Points, it gave the error message you've seen,so I forgot about it and and have been using a R9 machine since.
Can you get access to a V5 R9 machine and try it, I've never had any trouble with this Release for this work ?
I think I need to talk to our networking guys. Today it is working (as far as plotting points), but just like you said, I can't make a spline.
It goes through all the points though and doesn't come up with the error until it gets to "EndCurve" and then the error comes. In Catia it has all the points as errors. Could there be another command besides EndCurve? Maybe it was an update in after the v5r9 version and had continued until now. It seems to be just the commands such as Start..., or End... that are giving the errors. Any ideas for other names Catia may have switched to?
I tried Spline, but this will still work with just plotting the points, but when I try to choose option two, it reads about 20 lines, pauses and jumps to the end while nothing was actually done in Catia.
Kapitan,
I have similar problem as IsoGreg, even worst.
I cannot Enable Macros in the GSD_PointSplineLoftFromExcel.xls, I chose the GSD_PointSplineLoftFromExcel.xls!Feuil1.Main, and run it, but error message come up "The macros in this project are disabled.
Why, Why, Why???