ManagedXLL - The Solution for .NET Excel Add-Ins


What is ManagedXLL for Excel?

Custom Excel worksheet functions with a single [WorksheetFunction] attribute.

Or to put it another way: a RAD environment for Excel that integrates (possibly real-time) data and numerical calculations, designed for finance, derivatives trading and engineering. ManagedXLL provides a seamless integration with the .NET managed run-time and worksheet functions can be exported to Excel 97-2003 in a non-intrusive way:

Visual Basic
' Call from Excel: =EuropeanCallOption(100,100,0.05,0.03,1,0.4)
<WorksheetFunction()> _
Public Shared Function EuropeanCallOption( _
    ByVal underlying As Double, ByVal strike As Double, _
    ByVal dividendYield As Double, ByVal riskFreeRate As Double, _
    ByVal timeToMaturity As Double, ByVal volatility As Double _
) As Double

    ' function body left out

End Function
C#
// Call from Excel: =EuropeanCallOption(100,100,0.05,0.03,1,0.4)
[WorksheetFunction]
public static double EuropeanCallOption(
    double underlying, double strike, 
    double dividendYield, double riskFreeRate, 
    double timeToMaturity, double volatility )
{
    // function body left out
}
C++
// Call from Excel: =EuropeanCallOption(100,100,0.05,0.03,1,0.4)
[WorksheetFunction]
public: static double EuropeanCallOption(
    double underlying, double strike, 
    double dividendYield, double riskFreeRate, 
    double timeToMaturity, double volatility )
{
    // function body left out
}
Java (J#)
/** Call from Excel: =EuropeanCallOption(100,100,0.05,0.03,1,0.4)
    
    @attribute WorksheetFunction() 
 */
public static double EuropeanCallOption(
    double underlying, double strike, 
    double dividendYield, double riskFreeRate, 
    double timeToMaturity, double volatility )
{
    // function body left out
}

Additionally, .NET objects can be instantiated and called from the worksheet. Instance methods, properties and operators are, of course, available. Your existing class libraries can be exported to Excel an re-used by other applications (GUI, web services) without any performance penalties. There is typically no need to incorporate Excel or automation specific data types or error handling.

Array data is treated like an object as well. Every method returning arrays can be entered as an array function, returning the actual data, or as a simple worksheet function returning a handle to the array data. Every method accepting an array can be passed actual spreadsheet data or a handle. Using array handles for intermediate results or large input arrays can give your applications a performance boost as the actual array data does not need to be marshaled.

Read more:

Contact  en de fr  stochastix gmbh
Recherche Recherche approfondie
Log-in-client
Nom d'utilisateur:
Mot de passe:
Registre
Partenaires Microsoft Certified Partner
http://www.stochastix.com/solutions/excel/managedxll/latest/
© Copyright 2001 - 2010 stochastix GmbH, Germany