The following figures describe the process on how to prepare a template file for converting an Excel file to a dfs0 file. The subsequent use of this template to batch-convert a number of Excel files work in similary way to a batch conversion of ASCII files.
The time series data file used in this example contains measured water levels in four tidal station. The file ‘Sound_WL.xlsx’ is installed as a part of the MIKE Zero Example ‘Sound’ located in e.g.
.\Examples\MIKE_Zero\Projects\Sound\External Data\Measurements.
Figure 24.23 Selected input data file as displayed in Excel
Select tool and single file for input data
Define template for Excel file
Specify output data and convert single file
