Chapter 19. 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.All the examples discussed in this chapter assume that you are running Microsoft Visual C++.NET 2003. The accompanying CD contains complete versions of the sample project discussed below for both VC++ 6.0 and VC++.NET 2003 in the \Concepts\Chapter 19XLLs and the C API folder. If you are unfamiliar with C programming, you are strongly advised to open the sample files and follow along as you read. C is a very verbose programming language compared to VB/VBA, so we only have room to show the most important code contained in the sample. |
لطفا منتظر باشید ...
