Product Description

Excel is the industry standard for financial modelling, providing a number of ways for users to extend the functionality of their own add-ins, including VB. C/C++. Excel Add-in Development in C/C++ - Applications for Finance is a how-to guide and reference book for the creation of high performance add-ins for Excel in C and C++ for users in the finance industry. Author Steve Dalton explains how to apply Excel add-ins to financial applications with many examples given throughout the book. It covers the relative strengths and weaknesses of developing add-ins for Excel in VB versus C/C++.

"This book is for anyone who wants to do any application development in Excel. Even for an old hand at Excel development such as myself, a brief skim through reveals valuable nuggets of information. Delving deeper into the text, richer veins are easily found. This book is destined to become an essential reference on Excel development."
Dr. Les Clewlow, Principal, Lacima Group Ltd.

"Programming Excel add-ins using the C API can be complex and difficult. Steve has done a masterful job of demystifying the process. After reading this book you'll be creating XLLs for all purposes with complete confidence. Highly recommended."
Rob Bovey, MCSE, MCSD, Excel MVP, President, Application Professionals

---

Product Details

Publisher	Wiley
ISBN	0470024690
Format	Hardcover
Author	Steve Dalton
EAN	9780470024690
UPC	723812747894
Label	Wiley
Dewey Decimal Number	005.54
Studio	Wiley
Number Of Pages	422
Title	Excel Add-in Development in C/C++: Applications in Finance (The Wiley Finance Series)
Publication Date	2004-12-15
Manufacturer	Wiley

---

Customer Reviews

Not received the product

Review by T. Krishnan, 2007-03-12

I have not even received the product yet. How am I to write a review!

---

ONLY book detailed on the Excel C API

Review by ET, 2006-02-02

This is the ONLY book that is written exclusively for the Excel C API. It is well written but the reader needs to have basic C knowledge first. Development of XLLs in C++ is a topic not well documented in litertaure except for the MSDN website which has an archived section on the Excel 97 SDK. In any case, the CD code that comes with the book helps a lot. For a quick start to build your own programs you may use some interface classes and headers from the CD.

Several quants purchase a separate software XLL+ for developing the Excel XLLs, but even the software is a series of headers and cpp files made easy. And when it comes to more complicated development like dialog or menus, the book is a useful reference.

---

learn to use the C/C++ API for Excel

Review by W Boudville, 2006-01-30

In this book you get detailed examples of how to access and extend the functionality within Excel. It is clearly a hands on programmer's book. The languages in which you can do this are C and C++.

Microsoft has provided a rich API in these languages, with which you can get at many objects within the spreadsheet. Like a reference to the currently active cell. Or a list of all open Excel documents. Or finding the formula of a cell, returned as text. Or trapping various events, like a recalculation or a window selection or a keyboard action.

As the book's title suggests, many of the examples are taken from finance. Apropos, given that this is a spreadsheet we're looking at. But the methods given can be applied in any context that you need Excel for.

---

Very useful

Review by bookreader99, 2005-06-09

It may be true that a lot, defintely not all, of the information can be found in various places on the internet, but the sources are all over the place, incomplete and often refer to older technologies. The book contains much more than just the bland facts from various sources. For a start, the fact that all of this information is in one reference is extremely valuable. (I bought hardcopy, which I much prefer for reference and reading). The book is full of practical help and notes so that you don't have to find out the hard way where the undocumented problems are. There are worked sections on name handling and multi-threading. There are well-presented discussions about memory management, data types and handling large data structures. I work in finance but still think that I would have found this book useful even if I was working in another industry where high-speed number crunching is important. I was able to write xll add-ins after a weekend when it would have taken perhaps months otherwise.

---

Not enough

Review by S. Chandramouli, 2005-06-08

I bought this in e-book format (it costs twice as much for some reason) and I did not get any of the code that comes on the CD with the hardcover.
I had written a scathing review of this book after reading the first four chapters which is simply VC++ documentation. Chapters 5-9 are a little more helpful though parts of it are also available free. Yet, I don't believe there is enough new material in here.

---