HEC-DSSVue tables offer several commands that allow you to print, copy or export data and then paste tables into other applications such as Microsoft Excel and Word. The following sections describe each in detail.

Printing Tables

Access the Print and Print Preview commands from either the File menu or from the shortcut menu of the table window.

In a table, the Print and Print Preview commands open the Properties dialog box which offers options on three tabs.

The Page tab allows you to specify the page Orientation, Scaling, and Selection. You can also choose to print the table as ASCII, Repeat Headers on every page, and print the Gridlines. On the Header/Footer tab you can type in the header and footer you want to appear on your printed pages. The Table Title tab offers a default title for the table based on the data source, which you can change. On the Properties dialog box, the Print command performs two functions, depending on whether you arrived at the dialog box via the Print command or the Print Preview command.

Exporting Tables

Tables can be exported and converted into a *.txt file. Once the table is in the form of a *.txt file, it can be opened in a different application such as Microsoft Excel or Word.

From the shortcut menu or the File menu, click Export, the Table Export Options dialog box will open.

In the Table Export Options dialog box, you can choose a Field Delimiter (TAB, SPACE, COMMA, COLON, or SEMI-COLON), specify Fixed-Width Columns, choose to display Quoted Strings, Include Column Headers, and opt to Print Gridlines and a Title.

Copying Tables to the Clipboard for Use in Other Applications

To copy a table to the clipboard, from a table dialog box, from the Edit menu, click Copy. You can also right-click inside the table and click Copy from the shortcut menu. To copy the entire table from the shortcut menu, click Select All and then click Copy. You can then paste the table as tab-separated values into another application such as Microsoft Excel or Word. Only the data is copied to the clipboard; the table gridlines are not copied. (Use the export options when you want to copy table gridlines.)  You can also highlight a portion of the table and then click Copy. This will copy the portion of the table that you highlighted to the clipboard. 

Tabulate and Editing using MS Excel (Optional)

If the Excel plug-in is loaded, you can tabulate (or export) data in Microsoft Excel and edit time series data in Excel. Simply select the data sets you wish to tabulate as you normally would and then either press the Excel tool in the toolbar, or from the Display menu, click Tabulate in Excel (assuming you have Microsoft Excel installed).  The figure below shows how the data is displayed in Excel.

To edit data in Excel, select your data sets and from the Edit menu, click Edit in Excel. This will load the selected data into an Excel spreadsheet and then read it back to DSS once you have saved it. In this mode, you may not add or delete rows or columns; you can only change the data. After you are finished, save the Excel spreadsheet and then click OK or Cancel from the dialog from HEC-DSSVue.

Note - Take caution with dates and time in Excel.  Excel doesn't support 2400 for an hour, instead a data value for midnight will show up as 2400 hours at the end of the day in HEC-DSS, while Excel will display that as 0000 hours for the next day. For daily data, the hours might not be shown in Excel and the data can be misinterpreted to be for the following day.