The HEC-DSS Excel Data Exchange Add-In is no longer supported as of 2018. The reason for the removal of this Add-in is due to HEC-DSSVue containing import and
export capabilities of data between Excel and HEC-DSS file formats via the Excel plug-in in HEC-DSSVue.
Detailed training materials for using the Excel plug-in in DSSVue can be found here: Water
Resources Data Management with HEC-DSSVue
An example of using the HEC-DSSVue Excel Import plugin is shown below:
From HEC-DSSVue’s menu, select Data Entry -> Import -> Excel. You will then select the Excel file you wish to import.
In order to use the plug-in, you will be using right-clicks on rows and columns to assign the data. For the example here we will:
- Select the ordinate cell for the first row; this should have the number “1” in it. Right click and select “Pathname Parts Row” -> C Part
- Select the ordinate cell for the first row; this should have the number “1” in it. Right click and select “Pathname Parts Row” -> B Part (since each column is a separate location).
Select the upper left cell (above the “1”), where there is no label. Right click and select “Select all Data columns”.
- Select the header cell for the Date Column; This cell has the letter A in it, not the cell that has the word DateTime. Right click and select Date – Time Column -> Date and Time.
- Select the upper left cell (above the “1”), where there is no label. Right click and select “Select all Data columns”.
- For the dialog shown below, give an A, B, and F part that matches the location and type description of your data. In this case, we Leave the units blank since we are importing
multiple parameters for a single location. Press the Import Now button.
This batch process can take a few minutes depending on your dataset.
