How to use MS excel function "ugattr"!

[snakemaster]

I want to use this or another function in a macro and I want to extract all the attributes (at least the attribute name and value). "ugattr" is in the form of:

UGATTR( "object_name", "attribute_title", attribute_type)

I believe, "object_name" = "part" and "attribute_type" is a number 1 thru 4. I do not know what "attribute_title" is.

Please advise, Thanks

 

[JohnRBaker]

'Object Name' is the name assigned to an object so that the Spreadsheet knows which object to look at. You can assign names via the object Properties dialog but be careful that you're getting the actual geometric object and NOT the feature.

As for the 'Attribute Title', this the NAME of the Attribute being accessed.

John R. Baker, P.E.
Product 'Evangelist'
Product Design Solutions
Siemens PLM Software Inc.
Industry Sector
Cypress, CA

http://www.siemens.com/plm

http://www.plmworld.org/museum/

To an Engineer, the glass is twice as big as it needs to be.

 

[snakemaster]

What I am extracting is information like "Customer No.", "Part No." and "Drawing No." not feature/object information. I want a function that is a direct replacement (same information) for the menu pick "Extract Attribute". Can you give me an example of the function "UGATTR" that would extract all attributes and it's values. When I use "ALLATTR", I get the attribute names and type. At a minimum I need names and values.

 

[JohnRBaker]

I don't think you can extract PART Attributes using the Spreadsheet.

John R. Baker, P.E.
Product 'Evangelist'
Product Design Solutions
Siemens PLM Software Inc.
Industry Sector
Cypress, CA

http://www.siemens.com/plm

http://www.plmworld.org/museum/

To an Engineer, the glass is twice as big as it needs to be.