API Code Assistance

Hi,

I’m looking for some help with coding a script that can extract information (such as section type and associated loads) from an external source, like Excel, and import it into a developed Mathcad sheet. The goal is to check section capacity in accordance with the relevant codes and standards.

I appreciate this request may be a bit broad, and I am aware some example codes exist here: Code Examples. However, as I’m new to this, I would greatly appreciate any guidance or assistance in streamlining the script.

Kind regards,
Iain

Note, I am using Mathcad Prime 10.0.0.0 

Edit: 

We are looking to create Mathcad files based on an original worksheet, using externally sourced data from Excel.