Chapter 27. XLLs and the C API
This chapter in no way attempts to provide a complete guide to programming Excel using the C API. That would be a book-length topic in its own right. A skilled C++ programmer with an in-depth knowledge of the Excel C API can create add-ins that can do anything a VBA add-in can do.
Instead, this chapter focuses on the core strength of the C API, and what is arguably the most common use for it in Excel development, programming custom worksheet functions. Even this topic is too large to be covered in a single chapter, so we get you started with solid fundamentals and then point you to additional resources at the end of the chapter.
Please note that this chapter only demonstrates XLL development using the small grid data ...
Get Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
