How to create material palette using excel
The material palette feature in Pytha offers the convenience of assigning multiple part attributes with just one command. To create a material palette, you need a setting file in .txt format, which can be manually edited. This new method allows you to use an Excel spreadsheet to create the material palette along with its attributes. It gives the advantage of easy editing, allowing you to effortlessly add or remove materials as needed. Below is a step-by-step guide on creating and transferring the materials from Excel to the material palette in Pytha:
Step 1. Download and save the Input File to a convenient location on your computer.
Step 2. The Excel format is already organized. Fill in the required attributes and organize the material data in columns. Include attributes such as material name, core material, article codes, and any other relevant information. The list can be lengthy.
Step 3. Once the data is correctly filled in, a new sheet called “RUN” will be automatically added next to the input file.
Step 4. You will find a tab named “RUN MACRO”. Click on the tab.
Step 5. An OUTPUT FILE will be created. A message will be displayed indicating the location of the output file.
Note: The output file will be saved in the same location as the input file.
Step 6. The output file will be in .txt format (text file). Rename the output file as “pytha_werkstoff_new.txt” and replace the existing file in Pytha setting files.
Step 7. Open Pytha Central window and go to Extras → Edit Model Setting Files. Paste the “pytha_werkstoff_new.txt” in the setting files.
To verify if the Excel file data is correctly reflected in Pytha, open a new Pytha file, go to “Model→Attributes→Material Palette.” In the Name dropdown menu, you will find the entire material list that you just created. If you want to add or edit any materials, make the necessary changes in the input file and then follow the same process starting from Step 3.
By following these steps, you can efficiently create and transfer a material file from an Excel spreadsheet to the material palette in Pytha. This approach allows for easy editing and flexibility in managing your materials, providing a streamlined workflow for your design projects.
