Overview

The SpreadsheetWeb Connector allows you to integrate SpreadsheetWeb Web Service applications with Designer applications. This concept is similar to Excel's External References in the way it allows using the data and calculations from another workbook. A SpreadsheetWeb Connector can be associated with Action Button controls, and the connection will be established when the button is pressed during runtime. The calculation results from another workbook that has been uploaded into SpreadsheetWEB as a Web Service can be retrieved by the designer application and used in calculations as defined in the SpreadsheetWeb Connector properties.

Creating a SpreadsheetWeb Connector

A SpreadsheetWeb Connector requires defining a connector Name, a target Web Service Application and the Input and Output bindings between the web service application named ranges and designer application named ranges.

Name

The Name property is simply a friendly identifier given to the connector to help you subsequently identify this event from the others.

Application

You must select a target SpreadsheetWeb Web Service Application from the Application list, which will be used for calculations when a SpreadsheetWEB Connector event is triggered by an Action Button.

SpreadsheetWeb Connector Properties

On the SpreadsheetWeb Connector Properties page you need to select the Inputs to be sent to the target SpreadsheetWeb Web Service, and outputs to be retrieved after the calculations are triggered.

Inputs

On the Inputs grid, you need to set the inputs of the designer application to be sent to the target Web Service application to retrieve the calculation results. Here, Target Named Ranges are named ranges that belong to the Web Service application being used, and Source Named Ranges are named ranges from the designer application you are creating the connector for. When a Target Named Range is selected, the Source Named Range list will be populated with named ranges that match the width and height of the selected target named range. A Target Named Range can have only one corresponding Source Named Ranges binding.

Outputs

On the Outputs grid, you need to set the outputs that will be retrieved after the Web Service application calculations are executed. When a SpreadsheetWeb Connector event is triggered, the calculation results for the associated Target Named Ranges will be inserted into the source named ranges and a recalculation will occur.Here, Target Named Ranges are named ranges that belong to the Web Service application being used, and Source Named Ranges are named ranges from the designer application you are creating the connector for. When a Target Named Range is selected, the Source Named Range list will be populated with named ranges that match the width and height of the selected target named range. A Target Named Range can have only one corresponding Source Named Ranges binding.