C++编程指南：Excel插件开发的艺术与性能优化

需积分: 10 66 浏览量更新于2024-07-23 收藏 3.13MB PDF 举报

《C++实现Excel插件开发指南》是一本针对想要创建强大且可靠的Excel扩展工具的专业书籍。随着Excel的广泛应用，许多开发者积累了一定的C和C++编程经验，用于编写自定义函数。然而，由于缺乏充足的教材和资源，这个过程常常充满了试错的成分。作者写作本书的初衷是提供一个系统化的解释，包括相关的技术原理、开发步骤、避免的陷阱以及一个实用的参考手册，帮助读者轻松跨越C/C++与Visual Basic的性能鸿沟，同时利用编译后的C/C++语言和Excel C API所带来的巨大性能优势。本书详细介绍了如何在C++中开发金融应用领域的Excel插件，特别是第二版的《使用C/C++进行Excel插件开发》，由Steve Dalton编著。该系列书籍是Wiley Finance系列的一部分，读者可以通过访问www.wiley.com/finance了解其他相关出版物。版权信息表明，此书受1988年英国版权法、设计法和专利法保护，未经John Wiley & Sons Ltd.书面许可，不得以任何形式复制、存储或传输，除非符合版权、设计和专利许可证的规定。书中涵盖的知识点包括但不限于： 1. **Excel C API理解**：深入理解Excel应用程序接口（API），它是C/C++插件与Excel交互的核心桥梁，允许开发者访问Excel的工作簿、工作表、单元格和数据结构。 2. **C++编程基础**：讲解如何将C++语言的高效性和结构化编程应用于Excel插件开发，包括内存管理、错误处理和异常处理。 3. **模块化与设计原则**：介绍如何设计模块化的插件，保持代码整洁，并确保良好的可维护性和可扩展性。 4. **动态链接库（DLL）和XLL技术**：区分并解释DLL和XLL（Excel加载库）的优缺点，以及如何创建和部署这两种类型的插件。 5. **金融应用示例**：本书着重关注金融领域，提供实际的案例，如财务模型、数据分析和公式扩展，使读者能够将理论知识应用于实际场景。 6. **性能优化**：讨论如何通过C++提高插件的运行速度，减少内存消耗，以及避免潜在的性能瓶颈。 7. **调试和测试**：讲解了测试策略，包括单元测试和集成测试，确保插件在各种情况下都能稳定可靠地工作。 8. **实战教程与项目指导**：通过逐步指南，帮助读者从头开始，构建一个完整的Excel插件，并提供必要的代码示例和调试技巧。《C++实现Excel插件开发指南》不仅提供了技术理论，还为开发者提供了一个实用的工具箱，使得使用C++开发Excel插件变得既有深度又易于实践，尤其是在金融应用方面。对于希望在这个领域深入探索的程序员来说，这是一本不可或缺的参考书籍。

Contents xiii

8.15.3 Trapping a worksheet data entry event: xlcOnEntry 358

8.15.4 Trapping a keyboard event:

xlcOnKey 358

8.15.5 Trapping a recalculation event:

xlcOnRecalc 360

8.15.6 Trapping a window selection event:

xlcOnWindow 360

8.15.7 Trapping a system clock event:

xlcOnTime 361

8.16 Miscellaneous commands and functions 361

8.16.1 Disabling screen updating during command execution:

xlcEcho 361

8.16.2 Displaying text in the status bar:

xlcMessage 361

8.16.3 Evaluating a cell formula:

xlfEvaluate 362

8.16.4 Calling user-deﬁned functions from an XLL or DLL:

xlUDF 363

8.16.5 Calling user-deﬁned commands from an XLL or DLL:

xlcRun 363

8.17 The

XLCallVer() C API function 364

9 Miscellaneous Topics 365

9.1 Timing function execution in VBA and C/C++ 365

9.2 Relative performance of VBA, C/C++: Tests and results 369

9.2.1 Conclusion of test results 372

9.3 Relative performance of C API versus VBA calling from a

worksheet cell 372

9.4 Detecting when a worksheet function is called from an Excel dialog 373

9.4.1 Detecting when a worksheet function is called from the

Paste Function dialog (Function Wizard) 374

9.4.2 Detecting when a worksheet function is called from the

Search and Replace dialog 375

9.4.3 Detecting when a worksheet function is called from either

the Search and Replace or Paste Function dialogs 375

9.5 Accessing Excel functionality using COM/OLE automation using

C++ 376

9.5.1 Initialising and un-initialising COM 377

9.5.2 Getting Excel to recalculate worksheets using COM 379

9.5.3 Calling user-deﬁned commands using COM 380

9.5.4 Calling user-deﬁned functions using COM 382

9.5.5 Calling XLM functions using COM 383

9.5.6 Calling worksheet functions using COM 383

9.6 Maintaining large data structures within the DLL 385

9.7 A C++ Excel name class example,

xlName 387

9.8 Keeping track of the calling cell of a DLL function 389

9.8.1 Generating a unique name 390

9.8.2 Obtaining the internal name of the calling cell 393

9.8.3 Naming the calling cell 394

9.8.4 Internal XLL name housekeeping 396

9.9 Passing references to Excel worksheet functions 398

9.9.1 Data references 398

9.9.2 Function references 398

Preface to Second Edition

Since the publication of the ﬁrst edition of this book late in 2004, Microsoft have

announced the release of Excel 2007 (version 12), one of the most important new releases

since Excel 97 (version 8). For those developing add-ins in C and C++ so little changed

between Excel 97 and Excel 2003 (version 11) that the entire ﬁrst edition applied almost

equally to versions 8, 9, 10 and 11. Excel 2007 introduces some important and long-

awaited changes that have a signiﬁcant impact on the text of this book, which has been

updated to reﬂect these new features.

For the ﬁrst time in many releases, the Excel team have updated parts of the C API

interface to allow XLL add-in writers to take advantage of some of these new features.

The three areas that have the biggest impact are the introduction of multi-threaded recal-

culation, a worksheet grid over 1,000 times larger than is supported in previous versions,

and support in the C API for 32Kbyte Unicode strings. The implications for XLLs of

these changes and others are fully explored in this edition.

Beyond matters relating to Excel 2007, this edition adds a great deal of new material

to the ﬁrst. There is a much expanded section of Excel’s recalculation logic, intended to

help you minimise calculation times and maximise control, as well as a new section that

spciﬁcally addresses optimisation of calculations, both in the add-in and in the workbook.

The example C++ class described in the ﬁrst edition that wraps the

xloper data type has

not only been enhanced to handle the new Excel 2007 data types but also to wrap calls

to the C API as well. There is a new section relating to add-in design, covering issues

such as good practice for the separation of interfaces, and techniques for controlling the

propagation of errors through a workbook.

There are numerous other small additions and modiﬁcations to the original text, not

signiﬁcant enough to warrant mention here. As you would expect, the known errors and

omissions in the original text have also been ﬁxed, although readers are asked to bear in

mind that the writing constraints of such a book mean that bug-free can only ever be a

goal not a promise where code samples are concerned.

Beyond this, new material relates to a few practical applications. These tend to be

those that are most relevant to the professional derivatives markets, but will I hope, still

provide some useful insights for people outside this world. There is a little more about

interpolation. The section relating to the Gaussian normal distribution is revised and now

takes a more sensible Excel version-speciﬁc approach, which also serves as an example

of backwards-compatible and version-aware add-in funtionality.

剩余586页未读，继续阅读

sinat_16570259

粉丝: 0

C++编程指南：Excel插件开发的艺术与性能优化

使用C/C++开发Excel Add-in：财务应用实战

C++ Excel 加载项开发：金融应用实践

C/C++开发Excel Add-in实战指南

Financial Applications Using Excel Add-in Development in C/C++

Financial Applications Using Excel Add-in development in C/C++

Add-in Express 8.1正式发布：Delphi Office插件开发新版本

Excel.Add.in.Development.in.C.and.C_in_excel_xll_

用C++和C开发Excel插件

VC操作word和EXCEL

Excel Addin XLL 开发书籍

最新资源