AnsweredAssumed Answered

Excel Services SetRange method is not working

Question asked by sivakumar on Aug 29, 2016
Latest reply on Mar 30, 2018 by poorva09

Through Excel service Set Range method call I have tried to set Excel file cells as a range.

I have faced issues with the <anyType>xml</anyType> and there are less number of references to make it works.

This is the required xml to update.

 

<?xml version="1.0" encoding="utf-8"?>

<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:m="http://schemas.microsoft.com/office/excel/server/webservices">

  <soap:Header>

  </soap:Header>

  <soap:Body>

    <m:SetRange>

      <m:sessionId>string</m:sessionId>

      <m:sheetName>string</m:sheetName>

      <m:rangeCoordinates>

        <m:Row>int</m:Row>

        <m:Column>int</m:Column>

        <m:Height>int</m:Height>

        <m:Width>int</m:Width>

      </m:rangeCoordinates>

      <m:rangeValues>

        <anyType>xml</anyType>

      </m:rangeValues>

    </m:SetRange>

  </soap:Body>

</soap:Envelope>

 

 

I don't have direction what would be the value or what type of value would be required.

I've tried lots of variations but nothing works. For example passing xml type values, string values with comma separated, string values with double quoted, string values with single quoted, string values without quoted, string values with semi colon separated, collection type of values. No luck at all.

If anyone have solution please share it. Thanks in advance and Happy Nintexing.

Outcomes