Hii All,
I have many defined Groups of steel members in STAAD.Pro and the same defined groups I have copied to Excel and I have all the groups in excel dropdown.
Can I get Beam End Forces Summary in excel spreadsheet while changing the dropdown option in excel cell from STAAD.Pro.
I am not sure if I fully understood the question but you can filter any table from within the STAAD.Pro Post processing mode ( Utilization table or the Beam End Forces table ) based on certain members or groups. You may take your mouse cursor anywhere within the table and right click to chose Results Setup and you can choose the appropriate group from within the Range tab. The table results will then get filtered based on your selection. Subsequently you can select the table data from STAAD.Pro, copy it and paste it into Excel.
I didn't want to copy each group results from STAAD.Pro and then copy the same in excel.I would try to elaborate the query below:
I have all the defined groups in Excel dropdown list which are already defined as groups in STAAD.Pro.
I wanted to make it dynamic ( which links excel from STAAD.Pro).
Lets say if I select Group1 from dropdown list in excel, then it should display corresponding group1 results in excel.
And if I select group2 in dropdown list in excel, it should automatically update group 2 results (Beam End forces) in excel.
Without going to STAAD.Pro everytime to copy the results, can it directly extract the results from excel.
I wish I could explain my query now.
Seems like something that could only be handled by writing a macro using OpenSTAAD. I have requested some colleagues of mine who are more knowledgeable than me on this subject, to respond to your query.
Hi Sunny -
As Sye hinted, this is quite possible using the OpenStaad interface.
you’ll need to write a macro that will access the STAAD input/output from MS Excel. Please refer to the help for more information on how to use OpenStaad. If needed, I can provide a simple example next week to help.
Regards,
B. ZIANE