The SmartConnect Excel Add-In allows SmartConnect maps to be called from within Excel, with Excel data passed to the map.
The SmartConnect Excel Add-In for Excel adds functionality to the previous Excel Add-Ins. It requires the installation of the SmartConnect WCF REST service.
Once the Excel Add-in has been installed the following options are available from the eOne Solutions tab within Excel:
| • | Service settings enables users to maintain the connection and credentials for the SmartConnect WCF service. |
| • | Get data allows users to return the data source associated with a SmartConnect map into Excel. |
| • | Configuration enables users to set up and maintain the configuration details for sending data from Excel back to SmartConnect |
| • | The validate option checks that required information is present before attempting to pass data back to SmartConnect |
| • | Run map will create a data table from within Excel, pass the data to the SmartConnect WCF REST service and run the configured map. |
| • | Get columns returns a list columns required by the specified map. |
| • | Online help takes users to the SmartConnect help on the eOne solutions website. |