How to Transfer Data from EXCEL to STAAD.Pro


  
 Applies To 
  
 Product(s):STAAD.Pro
 Version(s):All
 Environment: N/A
 Area: General Solutions
 Subarea: General Information
 Original Author:Bentley Technical Support Group
  

Can you please tell me how to transfer data from EXCEL to STAAD-PRO?

The only data which can presently be transferred from Excel to STAAD is the geometry information, namely, joint coordinates, member incidences, plate element incidences, and solid element incidences. To do this, first select the cells in Excel where you have the numbers, and choose Copy from Excel's edit menu.

Next, come into the STAAD program. The data may be brought into a new STAAD file or an existing STAAD file. Accordingly, open a new file or an existing file.

Select the Geometry page from the left side of the screen, and choose the Beam, Plate or Solid sub-page depending upon the type of information you wish to bring in.

If you are looking to bring it into a New file, close the Snap/Node dialog box which is open on the right hand side of the screen.

For copying the joint coordinate data, click on the appropriate starting cell in the Node Tables grid on the right side, and type Ctrl+V or select paste from the Edit menu.

For beam incidence, plate incidence or solid incidence data, click on the appropriate starting cell in the Beam Tables, Plate Tables or Solid Tables grids on the right side, and type Ctrl+V or select paste from the Edit menu. You should see the numbers you copied from Excel appear in those cells.