🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

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.