finds.dev

asavine/xlCppTutorial

Exporting C++ code to Excel : a quick and painless tutorial by Antoine Savine

View on GitHub

★ 21Cupdated Aug 2022

// the take

A short, no-nonsense tutorial (plus a PDF) by Antoine Savine on exporting C++ calculation code to Excel as XLL add-ins using the raw Excel SDK and the old-school XLOPER C API. It's for quants and C++ developers who need to expose native pricing/calculation code to Excel without a full COM/VSTO framework.

Gets straight to the point with a worked example (gaussians.h, xlExport.cpp) instead of abstract theory, so you can see exactly how an exported function maps to the XLOPER marshaling code. The included bsVba.xlsm gives a concrete Black-Scholes-style test case to validate the build against. The author added a detailed 64-bit porting note (SDK file list, FRAMEWRK.H casing fix, duplicate Excel12 symbol fix) that saves hours of trial and error anyone doing this today would otherwise hit blind.

Targets raw XLOPER/Excel C SDK and 32-bit Excel by default; the 64-bit path is a manual, undocumented-in-code workaround bolted on as README prose rather than a maintained build config, so you're patching header includes and renaming files by hand. No CMake or modern build system, no CI, and no sample .sln/.vcxproj checked in, so reproducing the build depends entirely on following prose steps in Visual Studio. Last pushed in 2022 with no commits since, and XLOPER-based XLLs are a dead-end API relative to newer approaches (COM add-ins, pywin32, or libraries like ExcelDna) that handle memory management and 64-bit targeting for you.

We read the README, the directory tree and a key source file in October 2026. Nobody pays to be listed. How we judge →

// at a glance

Stars
21
Forks
11
Language
C
Last commit
24 Aug 2022

// nearby

If xlCppTutorial isn't quite it.

All repos →