×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

From excel to Catia

From excel to Catia

From excel to Catia

(OP)
Hello,

I want know if there is a way to generate a excel tabel into a draw, but here is the tricky thing, i want catia to write automaticlly what is in the 3d tree.
In other words when you have a assembly design and you have numbers assigned to each part i want catia to generate a tabel with the componence of the tree. Something like bill material.

With kind regards,
Cosirius.

RE: From excel to Catia

You can convert the excel file into .csv and insert it, then double click the field you want and right click to choose attribute links, switch window and pick the wanted parameter in spec tree or pick the part and find the part number.

RE: From excel to Catia

Hi,

Save as txt file, you will have the whole tree exactly like in CATIA.

Regards
Fernando

RE: From excel to Catia

and how do I insert a text file into a drawing?? I keep going around in circles and the closest I get is via an insert object, but this gives me an image that has to be resized and has a very sketchy quality to it...

any ideas? I want to do this via a macro...
thanx for your help

regards,
luis

RE: From excel to Catia

Can't you just copy the content of the txt file and paste it into the text editor??

RE: From excel to Catia

you can bring the text file in Excel and then save as CSV then import in CATDrawing.

or you can make a script.

Eric N.
indocti discant et ament meminisse periti

RE: From excel to Catia

hmmm, no azrael, I guess I didn't input you with the whole situation. I'm trying to dump the contents of a txt file into a table, via a macro, but I don't have access to excel on the workstation. for the moment I work around it by keeping all the values in arrays and then inputing them cell by cell, but it would be nice if I could just dump the whole txt file's contents into a table...
the txt is sepparated by tabs to make columns...

RE: From excel to Catia

mmmm... I did something similiar....I think... when I didn't have excel working. If the text file of .txt format then you can change the extension to .csv and use csv import on drawing.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources