Opening the HEC-RAS Controller in Excel
- First, access the HEC-RAS API by opening the Excel Visual Basic Editor. You can do this by clicking Alt+F11 while in Excel. The Visual Basic Editor will open,
- Next, click Tools on the top menu. Then click References.
- Then select HEC River Analysis System from the Available References as shown below. If you have multiple HEC-RAS versions on your computer, you may see HEC River Analysis System listed several times. If this is the case, look at the bottom of the screen to determine which version you are selecting. After you have selected the appropriate version, click Ok.
- Next, click View on the top menu. Then click Object Browser. Alternatively, you can click the F2 button. Then select RAS506 from the libraries menu as shown below. If you have a different version of HEC-RAS, the library name will be slightly different. For example, the name will be RAS505 for HEC-RAS version 5.0.5.
- Finally, click around the Object Browser to see what subroutines and functions are available. Later, I will publish a post outlining the steps for writing a simple program using some of these procedures.
参考:https://www.paigebrue.com/using-the-hec-ras-controller-to-automate-hec-ras/