Importing and Exporting
Microsoft Excel and “.CSV” Data
Importing, exporting and editing data with Microsoft Excel is accomplished in HEC-DSSVue
by the “plug-in” “Excel.jar”, stored in the HEC-DSSVue Plugins directory.
Plug-ins can be updated without having to update the HEC-DSSVue program itself. Refer
to the HEC-DSSVue plug-ins web page for updates at:
http://www.hec.usace.army.mil/software/hec-dss/plug-ins.htm.
At this time, only time-series data can be imported into HEC-DSS. Check the web site above for updates. Both time series and paired data can be exported to Excel but only time-series data can be edited in Excel.
You can also import time-series data in a comma separated format (.csv) or data separated by blank spaces, using the same procedure with the “Time Series Wizard”. This plug-in is in a development stage; check the plug-ins web page for updates.
Note: Excel uses beginning of period dates, whereas HEC-DSS uses end of
period. Thus, the average data for a day will show at 0000 hours in Excel and 2400
hours in HEC-DSS. This can cause a time shift by a day if the data is not imported or
exported carefully; Check your data after the operation. You can shift data to the
correct times by using the Time
Functions tab in the Math Functions screen.
Exporting Data to Microsoft Excel
Editing
Data in Microsoft Excel
Importing Data from
Microsoft Excel or ".csv" files using Data Entry
Importing Data from Microsoft Excel or ".csv" files using Time Series
Wizard