Getting Empty response when connecting SharePoint 2016 Excel Web Service method via SOAP client

Question

We have a SharePoint 2016 farm and we programmatically try to connect the site and Excel web Service via SOAP client. When we use OpenWorkbook method for getting session ID, its working fine and the session ID is coming. With that session if we call other methods like GetCell, GetRange, GetRangeA1, SetCell, SetRange, SetRangeA1 we are getting empty response. The same methods are working fine in SharePoint 2010 sites but for 2016 sites this issue is happening. Using Powershell commands (New-WebServiceProxy) also getting the same empty response error.

PSMessageDetails : Exception : System.Management.Automation.MethodInvocationException: Exception calling "GetCell" with "6" argument(s): "Server was unable to process request. ---> The request failed with an empty response." ---> System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> The request failed with an empty response. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.PowerShell.Commands.NewWebserviceProxy.AutogeneratedTypes.WebServiceProxy1vti_bin_ex celservice_asmx_WSDL.ExcelService.GetCell(String sessionId, String sheetName, Int32 row, Int32 column, Boolean formatted, Status[]& status) at CallSite.Target(Closure , CallSite , Object , Object , String , Int32 , Int32 , String , PSReference ) --- End of inner exception stack trace --- at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext funcContext, Exception exception) at System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame) at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame) at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame) TargetObject : CategoryInfo : NotSpecified: (:) [], MethodInvocationException FullyQualifiedErrorId : SoapException ErrorDetails : InvocationInfo : System.Management.Automation.InvocationInfo ScriptStackTrace : at , : line 1 PipelineIterationInfo : {}

Answer 1

Hi @Babu M ,

For your issue, because SOAP is a third-party software, I don't know much about it, so I do some troubleshooting from the perspective of SharePoint:

1. Check the input parameters: Make sure that the input parameters you are passing to the Excel Web Services methods are correct and valid. Double-check the sheet name, row and column numbers, and other input parameters to ensure that they are accurate.
2. Verify authentication: Ensure that you have the appropriate permissions to access the Excel Web Services. Check that you are passing the correct credentials and that they are valid.
3. Check server configuration: Verify that the Excel Services application is properly configured on the SharePoint 2016 farm. Check that the Excel Services service is running and that the necessary services and features are enabled.
4. Check the ULS logs: Review the SharePoint Unified Logging Service (ULS) logs for any errors or warnings related to Excel Services. This may provide more information about the root cause of the issue.
5. Network issues: If there are network connectivity issues between the SOAP client and the SharePoint 2016 server, it may result in an empty response or an error.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.