AnsweredAssumed Answered

How to search and map the request and response parameters in an excel sheet

Question asked by ReshmiRamanathan on Feb 20, 2017
Latest reply on Feb 23, 2017 by Rick.Brown

Does anyone know the java script to search for the request parameters of a dynamic request in an excel sheet and return the corresponding response parameters from the same row?

For Eg:

Consider the calculator WSDL with request parameters X and Y for the Addition operation.I have an excel sheet with three columns X,Y and Z, where X and Y are request parameters and Z is the response parameter.When I pass a request X=5 and Y=6 in my virtual service request,the service has to search for the row where X=5 and Y=6 and return the corresponding 'Z value' in the response.

 

Could anyone help with the java script for this? I tried the following:

 

 

var excel = new ActiveXObject("Excel.Application");
var wb = excel.Workbooks.Open("D:/LISA/MISC/XYZ.xlsx");
var ws = wb.Sheet1;
var cell = ws.Cells.Find("10");
return(cell.Row);
//excel.Quit();

 

But it gave error saying:   Unknown class: ActiveXObject : at Line: 1 :...............

Outcomes