Your Rating:

Thanks for voting!

Please Wait

Results:

4

rates

Overview

This section shows you how to write your first RTD or UDF application using the GigaSpaces-Excel integration.

See some basic and advanced code examples for working with UDF and RTD.

Prerequisites

Before you begin, make sure:

• GigaSpaces XAP.NET is Installed .
  Please note: the Excel Space Viewer supports only GigaSpaces version 6.5.1.
• Microsoft Office Excel 2003 with Primary Interop Assemblies is installed.

In case the Primary Interop Assemblies are not installed, install one of the following:

• For Office 2003:
  • Microsoft Office Excel 2003 with Primary Interop Assemblies (requires the Office Installation CD).
  • Redistributable Primary Interop Assemblies Package for Office 2003 (does not require the Office Installation CD).
  • Update for Office 2003 (KB907417)
• For Office 2007:
  • Redistributable Primary Interop Assemblies Package for Office 2007 (does not require the Office Installation CD).

Writing Your First RTD/UDF Application

1. In Visual Studio, create 2 new Class Library projects, one for UDF and one for RTD.
2. Add the <GigaSpaces Root>\Bin\GigaSpaces.Core.dll reference.
3. In the COM tab, select Microsoft Excel 11.0 Object Library.
4. In the .NET tab, select System.configuration.
5. Office runtime:
   • For Excel 2003 - in the COM tab, add the Microsoft Office 11.0 Object Library.
   • For Excel 2007 - in the COM tab, add the Microsoft Office 12.0 Object Library.
     
6. Build the projects.
7. Make sure GigaSpaces.Core.dll and GigaSpaces.NetToJava.dll exist in your Release folder.
8. Run the following command from the Release folder:

   %WinDir%\Microsoft.NET\Framework\v2.0.50727\RegAsm.exe \[MY_RTD_CLASSNAME\].dll /Codebase
   

9. Save the excel.exe.config file in your Excel runtime folder. For example: C:\Program Files\Microsoft Office\OFFICE11
10. Open Excel.
11. To add the UDF function:
    1. In Excel, go to Tools > add ins > automation.
    2. Scroll down to [MY_UDF_CLASSNAME], select it and click OK. You might get a dialog at this point about mscoree.dll. Click No to this dialog (Yes will delete the add-in from the list).
12. Start a space: <GigaSpaces Root>\Bin\Gs-ui.exe.
13. To call a UDF, click the Function icon, and look for the [MY_UDF_CLASSNAME] functions.
14. To call a RTD, write in any Excel cell:

    =RTD("[MY PROG ID]",,[MY PARAMETERS])
    

What's Next?

See the GigaSpaces-Excel Market-Data Example.

Back to The Excel that Scales Solution section.