Spreadsheet PIE version 1.2 (Nov. 2 07)

This PIE is intended for importing a list of scattered points, specified in a spreadsheet-like text file, into Data or Information layers. As of Argus ONE version 4.2.0f the PIE is installed with Argus ONE.

Data Format

UnFormated file Example:

Formated file Example:

The first field is an integer field named "Point Number", the quotes are required since the name contains a space. The second and third fields list the coordinates for each data point. A Real type is assumed by default. The fourth field is a String field named "Name". String values can be given with or without quotes. Use quotes if the string contains a space or Tab characters.

How to Install the PIE

As of Argus ONE version 4.2.0f the PIE is installed with the application. You can download it if you deleted it and need to restore it.

Download the PIE from the Argus ONE site

To install the Spreadsheet PIE, copy the file "Spreadsheet.dll" into the directory "ArgusPIE" that is inside the Argus directory. If you installed on your C drive using the default installation, this should be at: "C:\Program Files\Argus Interware\ArgusPIE\".

How to run the PIE

  1. Import Into Current Layer:

    To import data points into the current layer, use the "Import Points List..." command from the "Import" item of the "File" menu. A dialog box will appear, asking for input file. Choose the file you want to read and click the Open button:

    After selecting a file, the PIE will present a dialog box asking for the fields to be read from the file. The window will list all the fields found in the header, except for the X and Y fields (which are always read). When importing into a Data layer, String fields will be omitted as well (since Data layer can't handle string values). Click on the fields you want to read to select them. Click again to deselect:

    After marking the required fields, click the OK button to begin import.

  2. Import into a New Layer:

    To import data points into a new layer, select the "Read Points List..." item from the "PIEs" menu. The sequence of events is then similar to importing into the current layer, except for an extra dialog box that will show after choosing the file to be read. This dialog box will prompt you to choose where you want to bring the data into: