SP 2013 Excel Services - excelservice.asmx [英] SP 2013 Excel Services - excelservice.asmx

问题描述

我们在调用excel文件的c＃代码中使用excelservice.asmx传入数据，然后从那里获取计算输出，

一切正常"单个服务器"在测试环境中，测试环境具有在单个服务器中托管的Share Point 2013 WFE，Share Point 2013 App Services和Share Point数据库（SQL 2012）。 

我们计划迁移到生产环境低于配置。

1。 2个服务器用于Sharepoint 2013 WFE并通过启用了粘性会话的F5负载均衡器进行负载均衡

2。 2适用于Sharepoint 2013 Appserver的服务器，负载均衡由sharepoint处理。

3。 SQL 2012 - 标准。版本

以下是我的问题..

1。 excelservice.asmx在哪里运行？它是在WFE还是应用服务器上？

2。如果它在共享点应用服务器上运行，那么如何处理负载平衡？我的理解是，共享点按照https：//blogs.office.com/2008/12/12/understanding-excel-services-load-balancing-options/提供负载均衡。

3。如果我想启用粘性会话，我需要选择哪些负载均衡选项。  参考：  https://blogs.office.com/2008/12/12/understanding-excel-services-load-balancing-options/

---

Raghu

解决方案

1，excelservice.asmx在运行Excel Calculation Services的服务器上运行，我们可以在服务器服务器上管理服务来检查这一点。我建议您最好在App服务器上托管该服务。

2，您提供的文章是正确的，如果服务部署在应用服务器上，您可以选择工作簿URL和循环法。

3，如果您希望启用粘性会话，则从文章中选择的选项类似，因为此会话属于基于会话ID的会话。

最好的问候，

Andy Wu

We are using excelservice.asmx in c# code that calls a excel file passes in the data and then gets the calculated output from there,

everything works fine in "single server" test environment, the test environment has Share Point 2013 WFE , Share Point 2013 App Services and Share Point database (SQL 2012)hosted in a single server. 

We are planning to move to a production environment which has below configuration.

1. 2 Servers for Sharepoint 2013 WFE and load balanced through F5 Load Balancer with sticky session enabled

2. 2 Server for Sharepoint 2013 Appserver, with load balancing handled by sharepoint.

3. SQL 2012 - Std. edition

Below are my questions ..

1. Where does the excelservice.asmx run ? is it on WFE or the App Servers ?

2. If it runs on share point app servers then how load balancing is handled ? my understanding is that share point offers load balancing by itself as per https://blogs.office.com/2008/12/12/understanding-excel-services-load-balancing-options/.

3. What are the load balancing options I need to choose if I want sticky session enabled.  ref to : https://blogs.office.com/2008/12/12/understanding-excel-services-load-balancing-options/

---

Raghu

解决方案

Hi，

1，The excelservice.asmx runs on the server where Excel Calculation Services runs and we can go to Manage services on server of server to check this. I suggest you'd better to host the service on App server.

2, The article you provide is correct and if service deployed on app server, you can select workbook URL and round robin.

3, If you want sticky session enabled, the options which you select from the article are similar because this session belongs to based on session ID.

Best Regards,

Andy Wu

这篇关于SP 2013 Excel Services - excelservice.asmx的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！