Is there a way to get the numerical value of Mass in my Excel design table. I can only get the linking syntax to show up in the Excel table eg:SW-Mass@Standard Wall Panels.SLDPRT but i'm chasing the value of 30kg.
--
---------------------------- Couray Sheetmetal
9 Apsley Plc. Seaford Melbourne. Australia. PH 03 97861609---------------------------
Damian
It looks like you are missing the configuration indicator. e.g. SW-Mass@@Default@Standard Wall Panels.SLDPRT
If you are doing a design table and want each config. pick up the mass you need to add three quotation marks at the start & the end of the above statement - this allows excel to insert this into its cell with a single quotation mark at each end. e.g."""SW-Mass@@Default@Part Name.SLDPRT"""
HTH
Merry :-) Perth, WA
Sorry, it looks like I misinterpreted your question as I cannot see a real use for having the numerical figure in the design table (so long as the mass shows correctly in the BOM or drawing sheet).
I have never tried to do it so I have no idea if it can be done.
Merry :-)
Reason that i need this is i have quite a few sheets in my design table full of data that is coming from sheet 1. These sheets are linked to a database(Access) in wich we can build kits of the goods that we make. Weight is just another piece of data that we use. Anyway i shall keep trying Thanks Damian
Logically, the mass is a RESULT of a design table : the design table specifies dimensions and suppression states, then SW creates a body from this and the mass is obtained. So you logically cannot put the mass back in the design table.
If you want to get the mass in Excel, you could generate a BOM (of a dummy assembly containing 1 sample of each part you want to track) with a mass column.
Another approach could be to export your model in XML with the tools available on
PolyTech Forum website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.