Interface Introduction [Q14212]

	Browse		Search		Login

Home : Interface Introduction

Q14212 - INFO: Interface Introduction

The Hach WIMS Direct Server-Side Interface to Excel Data Forms reads results from Excel (.XLS, .XLSX & .XLSM) files and imports the values into Hach WIMS variables. The files must be .xls (Microsoft Excel 97-2003 Worksheet file) or .xlsx/.xlsm (Microsoft Excel 2007 Workbook) files. The cell comment in Excel is used to link the cell to a variable in WIMS and specifies the associated date cell. This interface will attempt to process all files in the folder specified in the configuration. The input file is copied to a local 'cache' folder and processed. Once finished it moves the file to an 'archive' folder with a date and time stamp added to the file name.