Building a model in FEMAP from excel can be useful for simple beam models where it is easy to define in excel the model parameters. Consider the following example from the direct stiffness example:

This code can be used to build this model in femap.

Running the script results in:

Running a static analysis on this model shows: