Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

CATIA V5R17 doesn't write apropriate design table on xls 2

Status
Not open for further replies.
frztrb

frztrb

Mechanical
Sep 29, 2010
151
IT
Hi All

I am trying to create some parameters and write them on an excell file , CATIA creates the xls file , but excell can not read it , mentions it's another format , but when I open it , the file is empty , what's the problem ? office is 2010 btw

thank you very much
 
Replies continue below

Recommended for you

Sort by date Sort by votes
well I simply created a part with three parameters , as three of the dimensions are related to these parameters , once I have them , I can make a design table , right ? and create it by indicating the parameters I want to export and write on an excell or text file , among these two option , my Catia can export a txt file but not an excell file , then I need to open it with matlab and change the parameters , I want to know once I change the parameters of the excell file or txt file , do they also automatically change in Catia ? I have seen one video on youtube on this , but don't know how accurate it is , I also want to know if it is interactive , I mean after changing the dimensions , Matlab can receive the new file with new dimensions.
 
Upvote 0 Downvote
On solid7 blog was a very good tutorial about this but now that blog is not existing anymore...name of tutorial is Parameters and Formulas Tutorial , maybe with Google....

I've done in the past an Excel file which is communicating with CATIA (and back) but I have to remember where I post it :) ) , is doing somehow what you wan.

Regards
Fernando

 
Upvote 0 Downvote
thank you so much , I would be really looking forward for this post , the tutorial is in one of those sites that are not for free
 
Upvote 0 Downvote
That's great , thank you so much ! could you please put some comments on this ? like how to create it , is it interactive ? press buttons need some Macros ??

this is very much helpful , but I need to know , how to make this ... and how automatic it can be
 
Upvote 0 Downvote
Don't have so much time now but in short, you need to create a CATPart exactly how is looking in the picture, with formulas and parameters exactly as you saw there, then modify values in Excel and see what is going on.

By pressing the buttons you run the macros inside Excel file.

The excel vba is not protected, so you can take a look also in the code. I will try to find also that tutorial later.

Regards
Fernando

 
Upvote 0 Downvote
What release of Catia are you running?
What SP have you applied against Office?
 
Upvote 0 Downvote
@garzar : I am using catiaR17 , sp5 , office 2010

@fernando : thank you , still I will need help , well the Macro is in VB , just can I ask , this part is what you have written or it's made by excell while creating the cat file ? thanks a lot , I think I should wait to see if the tutorial could be found , thank you so much for you kind help and attention Fernando , it's a big help and big part of my work
 
Upvote 0 Downvote
just one thing that , in my Visual basic , when I click on references in tools , it's not even active ,what's the problem ?
 
Upvote 0 Downvote
The CATPart is created first as you see in picture manually, in Excel you just manipulate dimension (new dimensions which will modify the CATPart or retrieve dimensions when you will modify in CATIA).

There are possibilities to create automatically the parametric part with formulas, relations a.s.o. , eventually based on a predefined design table, I've done also an example in the past.

I hope this evening (in Bucharest is morning now) I will have time to find all of them.

To access Tools-References you need to stop debugging (this is the most common problem, trying to access when code is running and forget to stop running the code).

Regards
Fernando

 
Upvote 0 Downvote
Thanks a lot I am in Italy , I'll be checking the updates Fernando , thanks
 
Upvote 0 Downvote
This is a known issue with R17.
Check the Dassault Knowledgebase; but, I do not think they have a solution for it since they do not support releases that old.
They only support releases that are at most two release levels old.
 
Upvote 0 Downvote
Hi,

I would suggest to read first in help docs about design tables and parameters.

You have here solid7 tutorial, pity he is not so active now in the forum, you could learn a lot from him (as from many others here).

Now, copy this design table in C:\Temp folder , open an empty CATPart and run this macro (to create a prism, is a recorded macro, just for example).

With the prism created, you can run now macro to play with design tables configurations (by modifying the configuration you can modify dimensions also).

All macros are hard coded, just for exemplification, so you have to respect what is written inside :) .

Regards
Fernando

 
Upvote 0 Downvote
Thank you very much Fernando , just one question in which format should I save the first design table in C:\Temp folder ?
 
Upvote 0 Downvote
Thank you so much , but may I ask you , at the end , what about my question , that how would catia be controlled through excell output of this macro by Matlab for example ? thanks a lot for the tutorial , I think now I need to know how should I produce the macro files , this way , also there are some lines need debugging ( line 21 for example ) I am searching to see what happens
 
Upvote 0 Downvote
Sorry, can't help you, I'm not using anymore Matlab...that was long time ago :) but macros inside Excel file can read or modify CATIA parameters. I suppose you need to setup somehow link between Matlab and Excel (but I'm asking myself why not to connect directly to CATIA...).

The macro in Excel can have problems because of Office version, for me is still working fine (CATIA v5r21 , Office 2003).

Regards
Fernando

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

fall fever
  • Locked
  • Question
Design Table
Replies
1
Views
63
Wuzhee
Wuzhee
Nagaraj Metri
  • Locked
  • Question
CATIA V5 MACRO: Insert a table from existing CATDrawing file
Replies
2
Views
72
Nagaraj Metri
Nagaraj Metri
TiagoFigueiredo
  • Question
CATIA V5 mold tooling
Replies
0
Views
114
TiagoFigueiredo
TiagoFigueiredo
xPAIVAx
  • Question
Automatic Rename CATIA V5
Replies
0
Views
263
xPAIVAx
xPAIVAx
McMutli
  • Locked
  • Question
Catia VPN Licenses
Replies
0
Views
80
McMutli
McMutli

Part and Inventory Search

Sponsor

Back
Top