C/C++开发Excel插件实战：金融应用

EXCEl
5星 · 超过95%的资源 需积分: 30 33 下载量 178 浏览量 更新于2024-10-04 1 收藏 4.21MB PDF 举报
"Excel Add-in Development in C/C++ - Applications in Finance" 是一本由 Steve Dalton 撰写的书籍，旨在为读者提供创建强大且可靠的Excel插件的指南。本书聚焦于使用C和C++开发Excel自定义函数时可能遇到的问题，帮助读者避免试错过程，利用Excel C API实现高效性能。作者期望此书能成为类似《C编程语言》和《C语言数值分析》那样有价值的参考书籍。 在书中，Dalton假设读者具有坚实的C/C++基础、良好的Excel操作知识，以及一定的VBA经验（尽管不是必须的）。他还要求读者理解基本的软件开发概念和技术。书中介绍了编码风格，并附带了一个示例添加项目，该项目演示了书中描述的重要或复杂的概念，展示了能够真正操作Excel时的潜力。示例项目基于作者在金融市场的专业背景，但这些技术同样适用于其他领域。 尽管书中涵盖了大量主题，但Dalton承认仍有许多可以扩展或包含的内容，对于那些期待更全面覆盖的读者，他对此表示歉意，并希望未来的版本能够弥补这些不足。Dalton回忆起自己初次接触电子表格应用是在1984年的Visicalc，尽管当时的系统缓慢且用途有限，但他认为电子表格的基本设计自始至终都是正确的。随着多年的发展，电子表格已成为不可或缺的工具，对于某些用户而言，标准功能往往不够用，而这正是本书的目标受众。 本书主要涵盖以下知识点： 1. **Excel插件开发基础**：解释如何使用C和C++创建DLL和XLL资源，以及与Excel的交互机制。 2. **Excel C API**：详细讨论如何利用Excel的C应用程序接口来扩展其功能。 3. **C/C++编程技巧**：针对Excel插件开发的最佳实践和陷阱，帮助开发者编写高效且稳定的代码。 4. **金融应用示例**：展示在金融领域中如何使用插件解决实际问题，例如数据分析和建模。 5. **软件开发概念**：强调了在开发过程中需要掌握的基本软件工程原则和方法。 6. **示例项目**：提供了实际的代码示例和项目，帮助读者理解并应用书中介绍的概念。 这本书适合那些需要扩展Excel功能、提高计算效率或实现定制化解决方案的开发者阅读，无论他们是否来自金融行业。通过本书，读者将能够掌握在C/C++环境下构建高效Excel插件的技能。

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

2009-06-09 上传
This book is intended to provide the reader with a guide to the issues involved with creating powerful and reliable add-ins for Excel. With years of use, many people build up the experience and understanding needed to create custom functions for Excel in C and C++. However, given the very limited books and resources available, this can be a largely trial-and-error process. The motivation in writing this book is to create something I wish I had had through the years: a coherent explanation of the relevant technology, what steps to follow, what pitfalls to avoid, and a good reference guide. With these things at your side, writing C/C++ DLL and XLL resources can be almost as easy as writing them in Visual Basic, but yields the enormous performance benefit of compiled C/C++ and the Excel C API. In setting goals for this book, I was particularly inspired by two excellent books that I have grown to admire more and more over the years, as they have repeatedly proven their worth; The C Programming Language (Kernighan and Ritchie) and Numerical Recipes in C (Press, Teukolsky, Vetterling and Flannery), albeit that the style of C-coding of the latter can be somewhat dense. If this book achieves a fraction of the usefulness of either of these then you will, I hope, be happy to own it and I will be happy to have written it. This book is intended for anyone with at least solid C and/or C++ foundation skills, a good working knowledge of Excel, a little experience with VBA (though not necessary) and the need to make Excel do things it doesn’t really want to do, or do them faster, more cleanly, more flexibly. A reasonable grasp of basic software development concepts and techniques is assumed. (Section 1.1 Typographical and code conventions used in this book, on page 1, provides more detail of the coding style of the examples given.) The example add-in project included on the CD ROM is intended to demonstrate some of the most important or difficult concepts described in the book, as well as the possibilities that are opened up when you can really play with Excel. These reflect my professional background in the financial markets, although if you are not of that world, you should still find that the techniques described are very widely applicable. There is an enormous amount of material that could have been included in a book on this subject that has either been pared down to the briefest of coverage or omitted completely. I fully accept that there will be those who, perhaps rightly, feel that certain things should have been covered in a book that boasts such a title, and I can only apologise. Any future editions will, I hope, provide an opportunity to rectify the most heinous and unpopular of these shortcomings.

(base) C:\Users\Administrator>conda config --add channels https://mirrors.tuna.tsinghua.edu.cn/anaconda/pkgs/main/ Warning: 'https://mirrors.tuna.tsinghua.edu.cn/anaconda/pkgs/main/' already in 'channels' list, moving to the top

2023-06-03 上传
conda config --add channels https://mirrors.tuna.tsinghua.edu.cn/anaconda/pkgs/free/ conda config --add channels https://mirrors.tuna.tsinghua.edu.cn/anaconda/pkgs/r/ conda config --add channels ...

怎么把Excel Add-In添加到matlab中

2023-05-17 上传
6. 在MATLAB命令窗口中输入以下命令：`addpath('C:\Users\yourusername\Documents\MATLAB\Add-Ons\Toolboxes\Excel Add-Ins')`，将路径替换为Excel Add-In文件的实际路径。这将添加Excel Add-In文件的路径到MATLAB的...

Excel Add-In是什么，怎么装

2023-05-17 上传
Excel Add-In是一种Microsoft Excel的插件，它可以为Excel添加新的功能和工具。这些插件可以是宏、自定义函数、特殊的工具栏、菜单、向导等等。 要安装Excel Add-In，您可以按照以下步骤操作： 1. 打开Excel并选择...

These dependencies were not found: * diagram-js/lib/features/create in ./src/plugin/palette/index.js * diagram-js/lib/features/global-connect in ./src/plugin/palette/index.js * diagram-js/lib/features/hand-tool in ./src/plugin/palette/index.js * diagram-js/lib/features/interaction-events in ./node_modules/diagram-js-direct-editing/index.js * diagram-js/lib/features/lasso-tool in ./src/plugin/palette/index.js * diagram-js/lib/features/palette in ./src/plugin/palette/index.js * diagram-js/lib/features/space-tool in ./src/plugin/palette/index.js * diagram-js/lib/i18n/translate in ./src/plugin/palette/index.js

2023-05-25 上传
这个问题看起来是你的代码中缺少了一些依赖包。可以使用你的包管理器（比如npm或yarn）来安装这些依赖包。...yarn add diagram-js@0.27.5 ``` 这应该会解决你遇到的问题。如果还有其他问题，请告诉我。

* pdfjs-dist/es5/web/pdf_viewer in ./node_modules/vue-pdf-signature/src/pdfjsWrapper.js To install it, you can run: npm install --save pdfjs-dist/es5/web/pdf_viewer

2023-07-12 上传
This will install the package and add it as a dependency in your project's `package.json` file. After installing, you can import and use the `pdf_viewer` module in your Vue component by adding the ...

Untracked files: (use "git add <file>..." to include in what will be committed) ALL-SEASONS-job-recruitment-system/

2023-06-11 上传
要将这些未跟踪的文件添加到 Git 的版本控制中，可以使用 `git add` 命令。例如，如果要将目录 `ALL-SEASONS-job-recruitment-system/` 下的所有文件添加到版本控制中，可以使用以下命令： ``` git add ALL-SEASONS...

ERROR in ./src/main.js 3:0-38 Module not found: Error: Can't resolve 'ant-design-vue/dist/antd.css' in 'D:\untitled\src'

2023-10-06 上传
在这个错误信息中，ERROR in ./src/main.js 3:0-38 Module not found: Error: Can't resolve 'ant-design-vue/dist/antd.css' in 'D:\untitled\src' 意味着在你的项目中找不到 'ant-design-vue/dist/antd.css' 这个...

wsl2base环境中创建新环境提示：Collecting package metadata (current_repodata.json): - ERROR conda.auxlib.logz:stringify(155): [Errno Expecting value] : 0 Traceback (most recent call last): File "/home/user/anaconda3/lib/python3.9/site-packages/requests/models.py", line 910, in json return complexjson.loads(self.text, **kwargs) File "/home/user/anaconda3/lib/python3.9/json/__init__.py", line 346, in loads return _default_decoder.decode(s) File "/home/user/anaconda3/lib/python3.9/json/decoder.py", line 337, in decode obj, end = self.raw_decode(s, idx=_w(s, 0).end()) File "/home/user/anaconda3/lib/python3.9/json/decoder.py", line 355, in raw_decode raise JSONDecodeError("Expecting value", s, err.value) from None json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0) During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/user/anaconda3/lib/python3.9/site-packages/conda/auxlib/logz.py", line 149, in stringify requests_models_Response_builder(builder, obj) File "/home/user/anaconda3/lib/python3.9/site-packages/conda/auxlib/logz.py", line 125, in requests_models_Response_builder resp = response_object.json() File "/home/user/anaconda3/lib/python3.9/site-packages/requests/models.py", line 917, in json raise RequestsJSONDecodeError(e.msg, e.doc, e.pos) requests.exceptions.JSONDecodeError: [Errno Expecting value] : 0 ERROR conda.auxlib.logz:stringify(155): [Errno Expecting value] : 0

2023-06-07 上传
conda config --add channels https://mirrors.tuna.tsinghua.edu.cn/anaconda/pkgs/free/ conda config --add channels https://mirrors.tuna.tsinghua.edu.cn/anaconda/pkgs/main/ conda config --set channel_...

Add-in Express

2023-05-03 上传
Add-in Express is a software development platform that allows developers to create custom add-ins, plugins, and extensions for Microsoft Office applications, such as Excel, Word, and Outlook. With Add...
samsam598
  • 粉丝: 0
  • 资源: 13
上传资源 快速赚钱

最新资源