JungV
April 4, 2023, 6:19am
1
Hello
I'm looking to modify a list of materials (sldmat format) by using excel.
I manage to open the file by changing the extension to the XML format but I can't go back to a sldmat format.
How do I create or edit a material list?
Kind regards
Vincent
Following this link, he advises not to touch the original file but just to open it in read-only mode.
For those of you that need to document the custom materials for certification, reasons it may be easy to export your materials information from Solidworks. The data base can be directly opened by Excel. Depending on where you store the...
Est. reading time: 1 minute
And here via notepad++ (free software) it seems that this is feasible (untested) and without changing the file extension. On the other hand, I strongly advise you to make a backup of the file beforehand.
https://centralinnovation.com/technical-resources/learn/how-to-edit-the-solidworks-material-database/
Otherwise via VBA it must be feasible Exel/Solidworks link to be made, here it controls the material change via Excel/Solidworks API:
Or else since solidworks, certainly longer but much safer!
3 Likes
Hello
This is done very well via any basic text editor.
On the other hand, you have to pay close attention to the syntax and the beginning and end tags of the material. Start well with
and end up
The easiest way is to copy/paste a complete material between its two tags and then modify what needs to be modified (the name of the material of course to avoid duplication, and the properties)
7 Likes