ArcGIS "GISconnector for Excel" toolbar
Description and explanation of every button for the toolbar in ArcGIS.
 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.
|
 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").
|
 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.
|
 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").
|
 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").
|
 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. |
 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. |
 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).
|
 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.
|
 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 . |
 Settings
In the dialogue "Settings" you can configure the basic and the default settings of the GISconnector for Excel as required.
|
