While Excel is open, you can use "GetObject" to attach to the first running instance (a COM requirement). The example script will attach to the open Excel and if your coordinates are in the format as shown in the below image, nodes will be created. Note that "lastRow" is hard-coded and can be manually updated or otherwise written in a way that checks the number of Rows.
Don't forget to right-click in the FEMAP API pane and include the Microsoft Excel reference.
See this post about something similar, going from Excel to FEMAP.