HydroExcel: WaterOneFlow Excel Client


HydroExcel is an Excel spreadsheet that provides direct access to WaterOneFlow web services, serving data both from national data providers and universities. The spreadsheet uses VBA macros and an object library called HydroObjects to communicate with and retrieve data from WaterOneFlow web services.

Before you begin:

  • Enable Excel macros. Your security settings may prevent the macros in this spreadsheet from running. If macros are disabled, and you don't see an option to enable them, you may need to go into Excel's security settings and allow macros or at least disable macros with notification. You will likely then have to close the spreadsheet and reopen it in order for the macros to work.
  • HydroExcel uses HydroObjects, an object library for communicating with the WaterOneFlow web services. So if you want to use HydroExcel, get and install HydroObjects.
  • HydroObjects requires the .Net Framework 2.0 from Microsoft. If you are using Office 2003, then Service Pack 3 for Microsoft Office 2003 is also required.

HydroExcel Version 1.1.6 Resources:

This version of HydroExcel fixes some compatability issues with WaterML 1.1. Note: HydroExcel is not compatible with the 64-bit version of Microsoft Office 2010.

© 2008-2010 CUAHSI-HIS

This material is based upon work supported by the National Science Foundation (NSF) under Grant Nos. 04-12975, 041-3265, and 06-22374.
Any opinions, findings and conclusions or recommendations expressed in this material are those of the author(s) and do not necessarily reflect the views of the NSF.