7 Replies Latest reply on Oct 6, 2017 4:01 PM by Edward Poole

    Edit Custom Materials Database - Excel

    Raymond Yau

      Hi,

       

      I'm looking for a way to create/edit Custom Materials library i.e. adding new materials, updating properties and so on. I know that it is possible to edit the .SLDMAT file in Notepad as an XML file, but Ideally I'm looking for a way to import custom materials data into Solidworks using Excel spreadsheets, however I can't find a solution anywhere.

       

      I've tried opening the .SLDMAT file as an XML file in Excel but that somehow messes up the mapping and no longer works once saved back into .SLDMAT.

       

      I came across this post which encountered a similar problem a year ago:

      https://forum.solidworks.com/message/528491?tstart=0#528491

       

      What is the best way for creating/editing large material databases?

       

      Many thanks,

       

      R