文档介绍：Excel Add-in Development in C/C++
Applications in Finance
Steve Dalton
Contents
Preface xv
Acknowledgements xvii
1 Introduction 1
Typographical and code conventions used in this book 1
What tools and resources are required to write add-ins 2
VBA macros and add-ins 3
C/C++ DLL add-ins 3
C/C++ DLLs that can access the C API and XLL add-ins 4
C/C++/C# .NET add-ins 4
To which versions of Excel does this book apply? 4
About add-ins 5
Why is this book needed? 6
How this book anised 7
Scope and limitations 8
2 Excel Functionality 9
Overview of Excel anisation 9
A1 versus R1C1 cell references 9
Cell contents 10
Worksheet data types and limits 10
Excel input parser 12
Data type conversion 12
The unary = operator 13
The unary − operator (negation) 13
Number-arithmetic binary operators: + - */^ 13
Percentage operator: % 13
String concatenation operator: & 13
Boolean binary operators: =, <, >, < =, >=, <> 13
Conversion of single-cell references 14
Conversion of multi-cell range references 14
Conversion of defined range names 15
Explicit type conversion functions: N(), T(), TEXT(), VALUE() 16
vi Contents
Worksheet function argument type conversion 16
Operator evaluation precedence 18
Excel terminology: Active and current 19
versus functions in Excel 19
Types of worksheet function 21
Function purpose and return type 21
Array formulae – The Ctrl-Shift-Enter keystroke 21
Required, optional and missing arguments and variable
argument lists 22
functions mands 22
Data Tables 22
Goal Seek and Solver Add-in 23
Excel recalculation logic 24
Marking dependents for recalculation 25
Triggering functions to be called by Excel – the trigger
argument 26
Volatile functions