Excel to Catia input for Part Properties
Excel to Catia input for Part Properties
(OP)
Hello All way smarter than me, I want to start again by saying this website is awesome and full of amazing people!
I was wondering if anyone has ever heard of a way to back-feed catia an excel sheet of info for things like property names and such. I thought since Catia is so user friendly with excel and you can save out to excel don’t you think there would be a way to fill out an excel form and transfer it into catia with some Macro that finds the Part name and then inserts properties based on your excel sheet/part name column?
Thanks in advance, any response is appreciated!
I was wondering if anyone has ever heard of a way to back-feed catia an excel sheet of info for things like property names and such. I thought since Catia is so user friendly with excel and you can save out to excel don’t you think there would be a way to fill out an excel form and transfer it into catia with some Macro that finds the Part name and then inserts properties based on your excel sheet/part name column?
Thanks in advance, any response is appreciated!





RE: Excel to Catia input for Part Properties
I am sure that if you provide all necessary information you can build an assembly from a BOM in excel.
Can you detail what you are looking for?
Before you do any code, it is always nice ( read recommended / critical) to define what you need:
what is the output
...
indocti discant et ament meminisse periti
RE: Excel to Catia input for Part Properties
I have another company that requesting all different custome part properties and it would be nice if I could type it out in an excel format and then send it to Catia to fill out internally...
RE: Excel to Catia input for Part Properties
a VBA script could get info from your file and build the assembly in CATIA but you will have to position elements by hands...
indocti discant et ament meminisse periti
RE: Excel to Catia input for Part Properties
RE: Excel to Catia input for Part Properties
As Eric said, yes, you can insert products or parts in an existing CATIA session, and even positioning them with the condition to know their matrix position in the product where you want to heve it, otherwise you have to position them manually.
All this can be done in a CATIA or Excel macro. Properties names will help you eventually in programming.
Regards
Fernando
https://picasaweb.google.com/102257836106335725208
https://picasaweb.google.com/103462806772634246699...
RE: Excel to Catia input for Part Properties
What I mean is when you go into the properties of a catpart and type in all of the parts added properties like the definition lets say. Instead of going into each part and filling out the definition is there a way to just fill out an excel form for the entire job, for each part and product. Fill out the definition in the excel sheet complete then transfer that excel sheet into your job and let IT fill out the properties in the data rather than the reverse?
RE: Excel to Catia input for Part Properties
Take in consideration the time to develop something like this and see if worth the money or not.
Regards
Fernando
https://picasaweb.google.com/102257836106335725208
https://picasaweb.google.com/103462806772634246699...