I am trying to find a way how I can read a excel file into patran for my material creation.
Lets see in my excel file I have material values for Al 6061 (young's modulus, density and poisson's ratio) . how can I read them into patran so that I do not have input these values manually ?
Is there a specific excel format these values need to be in order for patran to read them and create the material tab?
If you have material data in Excel and want to import it to Patran, the easiest way, in my opinion, is to format the data into a Nastran card, such as MAT1, then import the data as a BDF.
However, if you really want to make so that you don't have to reenter it every time, there's a good SimCompanion article that discusses how to use and add to the Material Session File Library, which can be accessed through the Utilities menu:
To make anything into a Nastran card that can be read into Patran, such as MAT1, you'd have to follow the formatting definition as described by the Quick Reference Guide.
I took a screen shot of the page for MAT1 below.
In the Example, a material with a Young's Modulus of 3e7, Poisson's Ratio of 0.33, and other properties that are inserted into the proper field.
You would have to format your data in such a manner, following the spacing rules for the fields, or using commas to separate the fields.