How to export the components names to excel file

User: "Siddharth_21009"
Altair Community Member
Updated by Siddharth_21009

Hi, 

I Would like to Export the few components name as a excel file. it have two columns A and B,

The name from the Hyper mesh exported into A column, Then i will change the name in B column .
By using the same excel file i want replace the  all the names of A column to be replaced with B columns names.

Ex: 

Hyper Mesh file have components as below.

car

body

frame 

 

When I export these comp, It should be exported into excel file in A column

A B
car car_metal
body body_steel
frame frame_steel

B column entered by manually. then I need to run macro , It will replace the all A name with B name in the hyper mesh file.

Hyper Mesh file have components after bulk rename

car_metal

body_steel

frame_steel

 

Find more posts tagged with

Sort by:
1 - 2 of 21
    User: "Adriano Koga_20259"
    New Altair Community Member
    Updated by Adriano Koga_20259

    is it simply adding '_metal' after these, like your example, or you need something more complicated than that?

    Because if it is just adding the post-fix, it would be easier to do in using a tcl code.

     

    User: "Siddharth_21009"
    Altair Community Member
    OP
    Updated by Siddharth_21009

    Yes, It is complicated naming, Excel mean it easy to make the naming easily.
    I will add suffix for bulk components. each will be different .

    Example : 

    car  --> car-metal-p-shell

    similar to this.