importeerGEFinExcel

This tool imports a GEF file into an Excel spreadsheet. In order to able to use this tool, you should have Excel running on your computer. The GEF file is split into two parts, which will be converted into two worksheets. The first worksheet consists of all information in the header of the file. The second worksheet has all information present in the data block.

Installation

You can dowload the program by clicking with the right mouse button on 'download it now'. Installation is straight forward, more or less non-existent: create a subdirectory on any disk you like and copy the file you just have downloaded into this directory. That's all. Optionally you can create a shortcut on your desktop. If you are not familiar with this technique, ask your administrator how to do it, or let him do it.

Usage

Run the program from the command line or double click it. A window will pop up:

Press the button "Converteer". A file dialog will popup. This will allow you to browse and choose a GEF file.
When you have chosen the input file, a "Save as" file dialog will popup to choose your output file.
You can stop the program by pressing the button "Beeindigen", or abort it by "Afbreken".

Remarks

A GEF file has no hard limit on the number of scans, other than less than 2 billion (=2³¹). An Excel file is limited to 65000 rows (=2¹⁶). Scans with a number exceeding 65000 are not saved into the spreadsheet. If your file is longer than 65000 scans, you are advised either to delete or skip scans. The program GEFhandelingen will enable you to delete scans. To skip scans, e.g. keep only the scans with an odd number, choose skipscans.