Exporting points from CATIA V5 to excel
Exporting points from CATIA V5 to excel
(OP)
I have a part which contains only points. They are all named to identify them. I am trying to export these and input them into an excel file. How do I easily export the values and names of these points?





RE: Exporting points from CATIA V5 to excel
Make a design table.
You'll have to select the design table icon, then multi-select the points from the tree. (it doesn't work by dragging a window - must use tree)
Next, when it asks for parameter values, I would suggest that you use the filters. Points have 3 components - X, Y, and Z values, and these are regarded as a "length" parameter. Multi-select the X, Y and Z parameters, and add them. When you click finish, your point values will be added to a spreadsheet.
From there, you can externally modify the layout. Remove the parameter names, cut and past them into a side-by-side arrangement, whatever. It's very easy to do.
Hope that helps.
**************
Check out CATBlog!
RE: Exporting points from CATIA V5 to excel
RE: Exporting points from CATIA V5 to excel
To nivlacburns: You seemed to have not selected the parameters. Check the documentation for design tables. I would suggest that you search your computer for the following files:
cfyugat3006.htm
cfyugat3320.htm
cfyugat3310.htm
cfyugat3330.htm
If you are new to this, it's a great opportunity to become savvy with a new set of tricks.
**************
Check out CATBlog!
RE: Exporting points from CATIA V5 to excel
Sorry about your Blog Solid7...but you know you can use / copy the code... ;)
I wrote an R14SP4 VBA script to get XYZ of points in a text file...
check CatiaV5Forum
go Download / General Script program
Enjoy !
indocti discant et ament meminisse periti
RE: Exporting points from CATIA V5 to excel
Thanks for the tip, Eric.
I didn't know that you had written a script to handle this sort of thing. I remember the points from excel to Catia, but having the reverse is a very cool thing.
Thanks for sharing. With your permission, I'll copy it over, and credit you...
**************
Check out CATBlog!
RE: Exporting points from CATIA V5 to excel
you gotta wait for the catiav5forum admin to make it available...
indocti discant et ament meminisse periti
RE: Exporting points from CATIA V5 to excel
**************
Check out CATBlog!
RE: Exporting points from CATIA V5 to excel
indocti discant et ament meminisse periti
RE: Exporting points from CATIA V5 to excel
http://w
have fun ...
indocti discant et ament meminisse periti