ArcGIS "GISconnector for Excel" toolbar


Description and explanation of every button for the toolbar in ArcGIS.
 
ArcGIS "GISconnector for Excel" toolbar
1

Create data connection

The "Create connection" button opens the connection wizard. It enables creating connections to Excel data either by exporting ArcGIS data to Excel or to establish a connection to already existing Excel data.
2

Active connection

2. Active connection
For the selected connection data and functions can be transferred.
3

Transfer all data

Transfer all attribute data from the connected feature-class or table to the corresponding Excel table. The transfer only applies to those columns that have been specified for transfer in the Connection settings respectively which the GISconnector for Excel manages for this transfer direction. If very large amounts of data need to be transferred, it is advisable to transfer only those columns in which alterations have resulted (see also "Transferring data: General Information").
4

Edit connection settings

Opens the dialogue "Edit connection settings". This represents the most important menu of the GISconnector for Excel. To understand how the GISconnector for Excel works, you should carefully read through the chapter on this dialogue.
5

Current layer

5. Current layer
The layer to be used for the transfer of selections or definition queries to Excel is speficied in the drop-down menu "Current layer". All layers which refer to the same data source (feature-class that was submitted in the connection) are specified here. Each connection always has at least one layer belonging to it. For connections to ArcGIS tables the drop-down menu remains empty. If the same feature-class is added twice to the Table of Contents (TOC), definition queries and selections can be created or transferred separately for each layer. In this case, a choice can be made in the drop-down menu "Current layer" for which layer the selection or the definition query should be transferred to Excel.
6

Transfer selected data

Transfer only data for the selected features to Excel. The transfer only applies to those columns that have been activated for transfer in the Connection settings or which are managed for this transfer direction by the GISconnector for Excel (see also "Transferring data: General Information").
7

Transfer filtered data

Transfer those data to Excel which corresponds to the definition query in the layer. The transfer only applies to those columns that have been activated for transfer in the Connection settings, or which are managed for this transfer direction by the GISconnector for Excel (see also "Transferring data: General Information").
8

Transfer selection

The "Transfer selection" button transfers the selection of features from the selected layer to Excel.
 
A special feature of this function is the ability to select data sets in Excel that do not exist in ArcGIS.  If no features are selected in ArcGIS and you press the button "Transfer selected data” in ArcGIS, those data sets are selected in Excel that do not exist in ArcGIS. Conversely, this works the same way. Basically this means, that you are able to compare your ArcGIS and Excel data with each other.
 
9

Transfer selection as filter

The selection of features in the selected layer is transferred to Excel as a filter. The filter in Excel is created on the bases of the primary key column ( GCEX_ID).
 
A special feature of this function is the ability to filter data sets in Excel that do not exist in ArcGIS.  If no features are selected in ArcGIS and you press the button “Transfer selection to Excel Filter” in ArcGIS, those data sets are filtered in Excel that do not exist in ArcGIS. Conversely, this works the same way. Basically this means, that you are able to compare your ArcGIS and Excel data with each other.
 
10

Transfer definition query as filter

Transfers the definition query of a layer as a filter to Excel. The filter in Excel is produced via the primary key column ( GCEX_ID).
11

Remove definition query

With this button you can remove the definition query of the associated ArcGIS layer.
12

Switch to Excel

With this button, you can directly start the connected Excel file and activate the connected spreadsheet. If it is already open, the corresponding Excel window and spreadsheet will be activated.
13

Export

Opens the "Export" dialogue. The attribute table of a feature-class or a table can be exported to a new Excel document or as a new spreadsheet into an existing Excel document. The export can be carried out in either XLSX or XLS format. On exporting, no connection is created. This feature is free, you can export more than 100 rows to a new Excel spreadsheet.
14

Manage connections

The "Manage connections" menu serves to administer connections between ArcGIS feature-classes or tables and Excel tables. Existing connections can be edited, deleted or duplicated .
 
15

Settings

In the dialogue "Settings" you can configure the basic and the default settings of the GISconnector for Excel as required.
16

Help

Opens the GISconnector  Help. You can also use our online help.

Tipp: In the Start menu under "GI Geolabs GmbH" you can also find the manual as a PDF document.

17

About

Opens the GISconnector About-dialogue with informations regarding the version and contact information to GI Geolabs GmbH