The attached API assigns element properties by location using a spreadsheet as shown below.
To run this API, you'll have to assign a reference to the Excel version you are using in the API pane.
Note that when using Cylindrical or Spherical coordinate systems (CSys), you will have to have seperate entries for locations less than 180 degrees and more than 180 degrees as values for Ymin and Ymax for a Cylindrical CSys and Zmin and Zmax for a Spherical CSys.
I've also attached a sample test model as a Femap Neutral file. The image below shows the model before and after running the API with the test model and the sample .csv file.
Best Regards, Chip Fricke Principal Applications Engineer - Femap Product Development