Excel Services and Soap call.
javascript enabled web services can be used to get client side activites in Excel services.
Below is the code snippet for getRangeA1 -
request = new ActiveXObject("Microsoft.XMLHTTP");
var url = "http://localhost/_vti_bin/excelservice.asmx";
var envelope = "<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">"+
"<soap:Body>"+
"<getcella1 "+
"xmlns=\'http://schemas.microsoft.com/office/excel/server/webservices\'>"+
"<sessionid>"+ EwaGetSessionId('WebPartWPQ3') +"</sessionId>"+
"<sheetname>"+"Sheet1" +"</sheetName>"+
"<rangename>"+"B3"+"</rangeName>"+
"</GetCellA1></soap:Body></soap:Envelope>";
alert(envelope);
request.open("Post",url,false);
request.setRequestHeader("Content-Type","text/xml");
request.send(envelope);
alert(request.statusText);
No comments:
Post a Comment