Microsoft Excel Integration

AgilePoint NX v8.0 provides several new points of integration with Microsoft Excel.

Lookups in eForm Builder

You can create lookups for Microsoft Excel in eForm Builder and form-based apps.

A lookup is an automated procedure that retrieves data from an external data source, such as a database or third-party service, to display runtime. For example, you can use a lookup to populate the options in a list on an eForm.

For more information, refer to Microsoft Excel Auto-Lookup configuration.

Figure: A drop-down list populated from a lookup

A drop-down list populated from a lookup
Figure: Sample lookup configuration screen

Configure Lookup Screen

This image is only one example configuration screen from the Auto-Lookup form control. It does not show all the configuration options, and lookups can be configured and executed in multiple ways. The Auto-Lookup control can perform a lookup for eForms or other controls. However, many other form controls have built-in lookup capabilities — for example, the Drop-Down List form control. For information about how to configure lookups, refer to eForm Controls.

Data Source for Process-Based Apps

You can use Microsoft Excel as a primary data source for your process-based app. A primary data source provides a default data model for your app.

For more information, refer to Process-based app data source.

Figure: How do you want to set up your entity? > Configuration tab

Configuration tab

Data Source for Form-Based Apps

You can use Microsoft Excel as a primary data source for your form-based app. A primary data source provides a default data model for your app.

For more information, refer to Form-based app data source.

Figure: How do you want to set up your entity? > Configuration tab

Configuration tab

Import and Export Entities or Entities in Data Entities

You can use a Microsoft Excel file to import records to or export records from an existing entity in Data Entities. This function can be used to create a new entity, update an existing entity, or export the data and metadata for an existing entity.

For more information, refer to:
Figure: Import Data screen

Import Data screen
Figure: Export Data screen

Export Data screen

Export Entity Model in Data Entities

You can use a Microsoft Excel file to download an entity model, which is is the metadata for an entity, from Data Entities.

For more information, refer to Export Template screen.

Figure: Export Entity Model screen

Export Entity Model screen

Import and Export Picklists and Picklist Items in Data Entities

You can use a Microsoft Excel file to import or export picklists or picklist items in Data Entities.

For more information, refer to:

.

Figure: Import Picklist screen

Import Picklist screen
Figure: Import Picklist Items screen

Import Picklist Items screen
Figure: Export Picklist screen

Export Picklist screen
Figure: Export Picklist Items screen

Export Picklist Items screen