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 :...............