Excel2007新知：轻车绕便道，题外不言他 #3 Excel在XLL方面所做

Quick detour #3: Updates we have made to XLLs轻车绕便道，题外不言他 #3：Excel 12在XLL方面所做的更新In the past few months, I have written a couple of articles (big grid, multi-threaded calculation) that prompted comments and questions along the lines of “what about XLLs?” Since the email questions have actually been picking up in frequency (I guess a lot of readers are also XLL authors), I thought I would write a quick article that outlines the changes we are making in this area to support new functionality.在过去几个月里，围绕“XLL将会怎样”的主题我有写过两篇文章（《更大的表格》、《多线程计算》），给出了一些相关的注解及问题。由于我收到的邮件中关于这方面的提问至今仍有相当的频度（我估计这其中的许多读者也是XLL加载宏的作者），我想我还是得再写上一篇简短的文章，来给大家描绘一下我们在新函数的支持方面所作的变更。Stepping back for a minute, let me briefly explain XLLs. An XLL is a DLL that is written so that Excel can open it directly. XLLs can be used for a number of things, but (in my experience at least) the most common use of XLLs is creating user-defined worksheet functions (UDFs) to supplement Excel’s intrinsic functions. Developers who write XLLs do so for a number of reasons, the paramount being performance.先耽搁您几分钟时间，让我来简要地介绍一下XLL为何物。XLL文件实际上就是一个能够让Excel直接打开的DLL(动态链接库)文件。虽说XLL文件可以用来做很多事情，不过，至少在我的经验中是这样，其最通常的应用是创建用户自定义工作表函数，以扩充Excel的内置函数。（译者注：就这一点而言，用VBA也可以做，那为什么还要编译成XLL文件呢？）开发人员这样做的原因有很多，其中一个最重要的原因就是为了提高执行效率。We have made three changes to XLLs in Excel 12, primarily to give developers access to new functionality. With Excel 12, XLL authors will have support for·The bigger grid