Windows HPC Server 2008 R2环境中的Office 2010服务器端自动化 [英] Office 2010 server side automation in a Windows HPC Server 2008 R2 Environment
问题描述
我知道来自微软和微软的服务器端Office自动化的考虑因素它清楚地列出了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.
(我不是在寻找Spreadsheet Gear，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屋！
