Professional Excel Development [Electronic resources] : The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA® نسخه متنی

Additional Resources

The Excel 97 SDK on MSDN

An extensive resource on creating XLLs using plain C code, the Excel 97 SDK covers a much wider variety of topics than this chapter. In addition, the source files that go with it include a handy framework for easing some of the repetitive chores involved in building an XLL. Just note that in a number of places, this framework attempts to directly modify string literal values. This is undefined behavior in C++ and therefore you must modify these instances to use char arrays instead. The text of the Excel 97 SDK can be found in the MSDN library at [ http://msdn.microsoft.com/library/ ].

Under:

Office Solutions Development

Microsoft Office

Microsoft Office 97

Product Documentation

Excel

Microsoft Excel 97 Developer's Kit

You can find the files that go with the SDK at [ http://download.microsoft.com/download/excel97win/Install/1.0/W9XNT4XP/EN-US/excel97sdk.exe ].

Excel Add-in Development in C/C++: Applications in Finance

Authored by Steve Dalton

ISBN 0470024690Wiley

An excellent book-length discussion on creating XLLs in C and C++, this title is highly recommended for anyone who wants to pursue this topic further.

William Hooper's Web Site

[ http://www.whooper.co.uk/excelstuff ]

Excellent discussion and examples on various advanced XLL topics.

Laurent Longre's Web Site (French Only)

[ http://longre.free.fr/ ]

More excellent discussion of XLL creation for those who can read French.

The Microsoft Excel Public Newsgroups

Point your newsreader to [ msnews.microsoft.com ]. You'll find experts in a wide array of topics willing to answer your questions for no charge. Most discussions related to XLL development will be found in the microsoft.public.excel.programming and microsoft.public.excel.sdk newsgroups. The microsoft.public.vc.language newsgroup is the best choice for C/C++ specific questions.

Planatech XLL+

[ http://www.as-ltd.co.uk/main/ ]

If you develop any significant number of XLLs, you owe it to yourself to buy a copy of XLL+. This is absolutely the best object-oriented XLL development framework available. It eliminates all the grunt work involved in creating XLLs and provides many advanced features in an easily accessible format. In addition, the help file for XLL+, although specific to the XLL+ development framework, is probably the best basic XLL development tutorial available. (Note: The authors have no financial incentive for this recommendation, it is based purely on the merits of the product.)

Keith Lewis' Freeware Object-Oriented C++ Wrapper for the Excel C API

[ http://sourceforge.net/projects/xll ]

An open source implementation of an object-oriented wrapper for the Excel C API.

ManagedXLL

[ http://managedxll.net ]

Similar to Planatech XLL+ but designed to work specifically with the .NET programming languages.