How to export the components names to excel file
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
Answers
-
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.
0 -
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.
0