Accessing excel worksheet via Plaxis scripting

Question

Hi, 
 I am running a sensitivity analysis for an excavation after demolition of an existing structure. The analysis includes a number of pile elements and plate elements. The pile locations are updated by sometimes a 0.5m or so. Now, with Plaxis Input, I have to manually select each embedded beam row element and update the coordinates. This is quite cumbersome and takes quite some time. I have saved the pile coordinates in an excel workbook. Is there any way I can use Plaxis scripting to update the coordinates via excel? I have attached a sample input file for reference. 
 . STR Coordinates.xlsx

Stefanos Papavasileiou · Answer

Dear Laswin, 
 This is where Python scripting can become a powerful tool. With Python scripting you can connect with PLAXIS application and perform almost any task that can be done manually via a Python script. 
 If you need to start from somewhere I would say: 
 
 Read about the feature: https://communities.bentley.com/products/geotech-analysis/w/plaxis-soilvision-wiki/46005/using-plaxis-remote-scripting-with-the-python-wrapper 
 Check our examples: https://communities.bentley.com/products/geotech-analysis/w/plaxis-soilvision-wiki/45393/api-python-scripting---plaxis 
 Check our Reference manual appendix 
 Check our Scripting reference: https://communities.bentley.com/products/geotech-analysis/w/plaxis-soilvision-wiki/45447/scripting-reference-and-how-to-use-it 
 Reach out to our support for specific quesions: https://apps.bentley.com/srmanager/ProductSupport 
 
 Note that Python has modules that allow accessing and handling Excel data, too. There are plenty of examples that can be found online.

Accessing excel worksheet via Plaxis scripting

Top Replies