Uploading an Excel File
You can upload Excel spreadsheet (.xls/xlsx) files to Spectrum spatial repository and then add the data as a layer to your map. You can upload a new file or replace an existing file on the Spectrum Spatial repository.
Examine your data before uploading:
- Only Excel Workbook (*.xlsx) and Excel 97-2003 Workbook (*.xls) are supported. Previous XLS versions and Strict Open XML Spreadsheet (*.xlsx) are not supported.
- In an Excel workbook, each worksheet is a separate table.
- Make sure that a table doesn’t have a complex formatting (merged cells, double header, more sheets, font color etc.)
Spectrum Spatial Analyst allows you to add and update Geocoded addresses while uploading XLS/XLSX file. It reads the address information from the source file.
To upload .xls/xlsx file:
-
Click or touch the Add
icon on the upper right corner of the map to open the Add panel.
-
Click or touch the Add layer
icon.
-
Choose Upload Files to Spectrum Spatial (.TAB, .shp, .csv,
.xls).
The Upload files panel opens. This panel will guide you through the upload process. Follow the instructions given under Checklist before Upload to avoid error.
-
Click or touch the Choose file ... to browse your computer and select your data
file.
After you select the files, Spectrum Spatial Analyst verifies the selected files. In case of any validation error, you can click Choose different file... again to choose the correct files.
The Upload files panel opens. -
Choose one of the following options and click Next.
Option Description Coordinates Use this option if your source file contains X, Y or lon/lat columns. Spectrum Spatial Analyst automatically reads the correct column from the chosen source file and displays it. You can change Projection and X/Longitude or Y/Latitude from the drop-down list.
If required, specify projection from the Projection drop-down list. After the layer is added, the points will be directly shown on the map as a business layer.
Addresses Use this option if your source file contains a column with addresses. The addresses will be geocoded and points will be shown on map as a business layer. Spectrum Spatial Analyst automatically reads the correct column from the source file and displays it.
If required, specify address column from the Select address column drop-down list.
This option is available only when Global Geocoding or LI API geocoder module is selected as the Geocoder by the Administrator. For more information see, Geocoding the Address Data.
Non-spatial Use this option if your source file does not contain data for geometry. In this case the table on the repository is updated, however, the data is not plotted on the map.
-
Choose Create new table or Replace existing
table to specify whether you want to create a new table or replace an
existing table on the spatial repository. Based on your selection, follow the sub-steps
given in the table.
Options Sub-steps Create new table If you choose Create new table, follow these steps.
From the Named Connection drop-down list select a named connection type. There are two types of named connections, file-based and database.
- Choose the file-based connection for uploading data as TAB files.
- Choose the SQL-based connection for uploading data as SQL table.
Click
to specify the File system path.
- For file-based connection Spectrum Spatial Analyst displays the root folder. By default, Spectrum Spatial Analyst displays the name of first folder in the list on which the user has the write-access.
- For SQL-based connection, it shows the list of schemas. For more information see, Browsing the Spatial Repository.
- In the Datasource table name field, displays the name of the data source. If the name already exists, you can edit the table name.
- In the Named table name field, the name of selected table displays. If the table name already exists, you can edit the name.
-
Click
to specify the path of the repository folder on the Spatial Spectrum server. Your table will be saved in this folder.
Note: While browsing the repository folder, if you cannot locate a folder, check with your administrator to determine if restrictions have been placed at the file-server level. You must have Write permission to the folder that you select. Click Upload. You get a message that the files have been uploaded. If you wish, you can view the new named table by clicking the hyperlink in the message.
After the file is uploaded, you can choose to create layer and save it to repository with the default layer style or with your custom styles.
- The Add layer to project checkbox enables you to add the layer to your map project. By default, it is checked.
- If required, click
to browse the Spatial Spectrum repository and select another folder.
- (Optional) Select Define style override, to modify the style for the layer.
- Click or touch the Create Layer button to add the layer to the current map. When you save map project, the new layer is also saved.
Replace existing table If you choose Replace table, follow these steps.
-
In the Named Connection field, click
to browse the Spatial Spectrum repository and select the named table that you want to overwrite.
The selected named table should have the same column structure as the table being uploaded.
- Spectrum Spatial Analyst detects the Datasource name to which the table belongs and populates the Named connection and Datasource table name fields.
- Click Upload. You get a message that the files have been uploaded and the selected named table is updated. If you wish, you can view the updated named table by clicking the hyperlink in the message.
- Click Done to return to the Map legend panel. If a layer in your current map is based on the updated table, the map gets refreshed.