Connector for Excel components

Service

Located in %SOAM_HOME%\5.0\Integrations\ConnectorForMsExcel\service. The service acts as a wrapper to Excel, and uses the information passed from the client: spreadsheet name, macro name and two parameters for the macro to invoke Excel on the compute host and execute the macro.

The VBA macro formats its result message and returns the result to the service. The service then sends the result back to the client. The service closes Excel upon completion of the task.

Note:

Output messages generated by the service are quite large, approximately 1 KB in size. Take this into account when examining performance.

The service also contains ConnectorForExcel.dll, which is a service DLL used to invoke Excel.

ConnectorForExcelDemo.xls

Located in %SOAM_HOME%\5.0\Integrations\ConnectorForMsExcel\samples\spreadsheets. Actual spreadsheet that contains the business logic to perform calculations in Excel. Contains the MyMacro VBA function. The client sends this spreadsheet as common data for the ConnectorForMsExcel Service to process.The demo spreadsheet can be used as a template for modifying your own spreadsheets to work with the ConnectorForMsExcel service.

DialogSniffer.exe

Used for troubleshooting. Parameters for DialogSniffer are configured in the application profile. Detects dialog boxes that appear during the execution of a task, and writes the dialog box text to a log file. Can dismiss dialogs based on text patterns specified in the application profile so that Excel can continue calculations.

VBAMacroTest.xls

Autonomous spreadsheet used to debug a macro in your own spreadsheet. Uses ConnectorForExcel.dll directly as a COM-object without Symphony. Packaged with the service so that you can test spreadsheets on compute hosts if needed.