Catia Macro: How to Insert Excel Table inside CATDrawing Doc
Catia Macro: How to Insert Excel Table inside CATDrawing Doc
(OP)
I want to create Excel Table inside drawing doc using macro. Is it possible ?
Please guide me
Please guide me





RE: Catia Macro: How to Insert Excel Table inside CATDrawing Doc
CATIA already has a built in function that allows you to do this.
Regards,
Drew Mumaw
http://www.drewmumaw.com/
http://www.textsketcher.com/
RE: Catia Macro: How to Insert Excel Table inside CATDrawing Doc
See this image.
Regards,
Drew Mumaw
http://www.drewmumaw.com/
http://www.textsketcher.com/
RE: Catia Macro: How to Insert Excel Table inside CATDrawing Doc
RE: Catia Macro: How to Insert Excel Table inside CATDrawing Doc
Are you simply trying to automate this process ( Insert > Object )?
Regards,
Drew Mumaw
http://www.drewmumaw.com/
http://www.textsketcher.com/
RE: Catia Macro: How to Insert Excel Table inside CATDrawing Doc
RE: Catia Macro: How to Insert Excel Table inside CATDrawing Doc
I've never seen a way to do this in the API documentation. A possible workaround would be using CATIA.StartCommand "Object" and then SendKeys.
Regards,
Drew Mumaw
http://www.drewmumaw.com/
http://www.textsketcher.com/
RE: Catia Macro: How to Insert Excel Table inside CATDrawing Doc
RE: Catia Macro: How to Insert Excel Table inside CATDrawing Doc
It works in CATIA too.
Regards,
Drew Mumaw
http://www.drewmumaw.com/
http://www.textsketcher.com/
RE: Catia Macro: How to Insert Excel Table inside CATDrawing Doc
RE: Catia Macro: How to Insert Excel Table inside CATDrawing Doc
turn it on, then go to insert menu-object and try to import it with a manual action. then review the recorded macro and see if you can automate it (exact coords for docking the excel sheet might be tricky).
i also think that you can make a BOM from a CSV file.
RE: Catia Macro: How to Insert Excel Table inside CATDrawing Doc
It's not exposed to automation. That's why I suggested:
Or a standalone VB app that copy and pastes from the excel directly would work too.
Regards,
Drew Mumaw
http://www.drewmumaw.com/
http://www.textsketcher.com/
RE: Catia Macro: How to Insert Excel Table inside CATDrawing Doc
although i don't know if the values can be hardcoded into the drawing so that you don't need to copy also the csv file.
RE: Catia Macro: How to Insert Excel Table inside CATDrawing Doc
what's the best way to learn vb? are vb.net and c# also supported for scripts?
RE: Catia Macro: How to Insert Excel Table inside CATDrawing Doc
Start here in the Eng-Tips FAQ section.
Probably about 3 months.
Are you referring to learning vb or learning vb for CATIA's API?
I learned vb by taking this class and using Visual Studio to create vb applications. For VBScript (and VBA), I read this book.
If you are referring to vb for CATIA's API, then I used Google searches, COE.org, Eng-Tips.com, and various other online resources in addition to referencing the CATIA API documentation, recording my own macros to look at the code, and using object resolution. You may find this Eng-Tips thread helpful. And here's some other online resources (just use Google for more):
http://v5vb.wordpress.com/about/
http://www.scripting4v5.com/additional-articles/ca...
http://www.3dcadforums.com/catia-forum/4248-catia-...
If you develop an application in Visual Studio that accesses CATIA's API then you can use whatever object-oriented programming language that you want. If you are making a .catvba or .catvbs macro in CATIA V5 then you have to use vb. Also, I think CATIA has it's own internal scripting language called catscript, but I'm not familiar with it. And I heard that we will be able to program macros in CATIA V6 with vb and C#.
Regards,
Drew Mumaw
http://www.drewmumaw.com/
http://www.textsketcher.com/
RE: Catia Macro: How to Insert Excel Table inside CATDrawing Doc
Here's some more helpful sites:
http://www.gtwiki.org/mwiki/index.php?title=Main_P...
http://catiadesign.org/
http://catiav5automation.blogspot.fr/
http://ol.cadfamily.com/CATIA/English/online/CATIA...
Regards,
Drew Mumaw
http://www.drewmumaw.com/
http://www.textsketcher.com/
RE: Catia Macro: How to Insert Excel Table inside CATDrawing Doc
Here's a very helpful document:
http://yvonet.florent.free.fr/SERVEUR/COURS%20CATIA/CATIA%20Infrastructure/VBA_A/Student/EDU_CAT_EN_VBA_AF_V5R19_toprint.pdf
Regards,
Drew Mumaw
http://www.drewmumaw.com/
http://www.textsketcher.com/