Windows HPC Server 2008 R2 环境中的 Office 2010 服务器端自动化 [英] Office 2010 server side automation in a Windows HPC Server 2008 R2 Environment

问题描述

我知道 Microsoft 和它清楚地列出了 2010 套件中的产品.

I am aware of of the infamous Considerations for server-side Automation of Office from Microsoft and it clearly lists products from the 2010 suite.

但是，今天，一位 IT 运营技术人员让我相信 Office 2010 不会遇到该文章中提到的问题，并且可以在服务器环境中正常使用.我一直无法找到任何可以证实该声明的参考或支持文档.(我会就此与他联系，但他肯定指的是其他服务器端技术)我的直觉告诉我他在抽他的袜子！

However, today I was made to believe by an IT ops techie that Office 2010 does not suffer from the issues mentioned in that article and can be used without issues within a server environment. I have been unable to find any reference or supporting doc that would substantiate the claim. (I will follow up with him on this, however he must have been referring to some other server side technique) My gut tells me he was smoking his socks!

是否有基于 Microsoft 的 Office 2010 服务器端自动化解决方案?如果是，请提供支持该声明的相关链接.

Is there an Microsoft based solution for server side automation for Office 2010? If yes, can you please provide a relevant link that supports the claim.

(我不是在寻找电子表格设备、OpenXML SDK、OpenXML 等相关答案)

(I am not looking for a Spreadsheet Gear, OpenXML SDK, OpenXML etc. related answer)

推荐答案

看起来技术人员并没有那么遥远，实际上他的主张有一定的道理.我向您推荐 Windows HPC Server 2008 R2 处理高性能计算(所以这不适用于我猜大多数人处理的工厂类型工作簿的运行).考虑到我工作的公司是保险业，这确实是有道理的.注意:这只适用于高性能计算服务器

It would seem that the techie was not that far off and there actually was some validity to his claim. I refer you to Windows HPC Server 2008 R2 which deals with High Performance Computing (so this does not apply to your run of the mill type workbooks that I guess most people deal with) . This does make sense considering the company I am working at is with the insurance sector. Note: this only works for for a High Performance Computing server

我向您推荐 微软技术白皮书

Windows HPC Server 2008 R2 现在支持在 Windows HPC 群集中运行 Excel 2010 的多个实例，其中每个实例都使用不同的数据集运行同一工作簿的独立计算或迭代.许多复杂且长时间运行的工作簿以迭代方式运行——也就是说，它们对不同的输入数据集执行多次单一计算.这些工作簿可能包含包含在多个工作表中的密集数学计算，或者可能包含复杂的 Microsoft Visual Basic for Applications (VBA) 函数.

Windows HPC Server 2008 R2 now enables running multiple instances of Excel 2010 in a Windows HPC cluster, where each instance is running an independent calculation or iteration of the same workbook with a different dataset. Many complex and long-running workbooks run iteratively—that is, they perform a single calculation many times over different sets of input data. These workbooks might include intensive mathematical calculations contained in multiple worksheets, or they might contain complex Microsoft Visual Basic for Applications (VBA) functions.

...

可能需要修改工作簿才能使用此解决方案.Excel 2010 在服务器上运行时，不支持用户交互.Windows HPC Server 2008 R2 包含一个全面的弹出管理器，可以处理偶尔出现的对话框和弹出消息，但它不支持交互式 Excel 2010 功能

workbooks may need to be modified to work with this solution. When Excel 2010 runs on the server, it does not support user interaction. Windows HPC Server 2008 R2 includes a comprehensive pop-up manager that can handle occasional dialog boxes and pop-up messages, but it is not designed to support interactive Excel 2010 features

还有另一个文档:使用 Windows HPC Server 2008 R2 加速 Excel 2010:为 Windows HPC 集群构建 VBA 应用程序和工作簿，其中详细介绍了如何为 HPC 服务器构建 Excel 解决方案.

There is also another doc: : Accelerating Excel 2010 with Windows HPC Server 2008 R2: Building VBA applications and workbooks for a Windows HPC Cluster which goes into detail as to how to building Excel solutions for a HPC server.

这篇关于Windows HPC Server 2008 R2 环境中的 Office 2010 服务器端自动化的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！