Dev Release 20.8.15-DEV9eef
A Wrapper for the Excel API

XLW - A Wrapper for the Excel API

XLW is an open source application that wraps the Excel C API in simple C++ and C# interfaces which you can use to customize Excel with your own worksheet functions and menu items.

XLW developers include Financial Engineering practitioners with extensive experience of developing quantitative analytics in the finance industry including Mark Joshi the author of The Concepts and Practice of Mathematical Finance and C++ Design Patterns and Derivatives Pricing.



The project's interface generation system seamlessly parses your C++ header files ... 

// Test.h

#ifndef TEST_H
#define TEST_H

//<xlw:libraryname=MyTestLibrary

std::wstring // Concatenate two strings
//<xlw:time
Concat(std::wstring str1,  // First string
       std::wstring str2); // Second string

double // Compute the circumference of a circle
//<xlw:time
Circ(double Diameter); // The circle's diameter

#endif
... and your C# ... 
namespace Example
{
  public class Class1
   {
    [ExcelExport("computes the circumference of a circle ")]
                                    public static double Circ(
        [Parameter("the circle's diameter")] double Diameter)
        {
                                    return Diameter * 3.14159;
        }

    [ExcelExport("Concatenates two strings")]
                                    public static string Concat(
        [Parameter("first string")] string str1,
        [Parameter("second string")] string str2)
        {
                                    return str1+str2;
        }

    }
}

...to automatically generate the corresponding XLW Excel addin (xll).

screenshot