ChangeTabNamedRegion

SOAP-запрос:

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">

<s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<ChangeTabNamedRegion xmlns="http://www.fsight.ru/PP.SOM.Som">

<nrMon xmlns="">

  <id>ILBNJNHKDBCAGOAEGGMCAJHIOKJPOKMEOIOADBDOFONILPAG!M!S!PAJBBFBIKDBCAGOAEJOAGHLNCNALCNCJEOLBLLFIDBFHIGLPO!Sheets!1!NamedRegions</id>

  </nrMon>

<Arg xmlns="">

<ids>

  <name>Данные</name>

  </ids>

<reg>

  <left>1</left>

  <top>11</top>

  <width>10</width>

  <height>12</height>

  <name>Итоги</name>

  </reg>

  </Arg>

  </ChangeTabNamedRegion>

  </s:Body>

  </s:Envelope>

SOAP-ответ:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

<soapenv:Body>

<ChangeTabNamedRegionResult xmlns="http://www.fsight.ru/PP.SOM.Som" xmlns:q1="http://www.fsight.ru/PP.SOM.Som" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <res xmlns="">1</res>

  <name xmlns="">Итоги</name>

  </ChangeTabNamedRegionResult>

  </soapenv:Body>

  </soapenv:Envelope>

JSON-запрос:

{
 "ChangeTabNamedRegion" : 
  {
   "nrMon" : 
    {
     "id" : "ILBNJNHKDBCAGOAEGGMCAJHIOKJPOKMEOIOADBDOFONILPAG!M!S!PAJBBFBIKDBCAGOAEJOAGHLNCNALCNCJEOLBLLFIDBFHIGLPO!Sheets!1!NamedRegions"
    },
   "Arg" : 
    {
     "ids" : 
      {
       "name" : "Данные"
      },
     "reg" : 
      {
       "left" : "1",
       "top" : "11",
       "width" : "10",
       "height" : "12",
       "name" : "Итоги"
      }
    }
  }
}

JSON-ответ:

{
 "ChangeTabNamedRegionResult" : 
  {
   "res" : "1",
   "name" : "Итоги"
  }
}

public static TabNamedRegionOpResult ChangeTabNamedRegion(string moniker, string changedRegionName, string newName, int leftCell, int topCell, uint bottomCell, uint rightCell)
{
    var somClient = new SomPortTypeClient(); // Прокси-объект для выполнения операций
    // Параметры выполнения операции
    var tChange = new ChangeTabNamedRegion()
    {
        nrMon = new NamedRegionsId() { id = moniker + "!Sheets!1!NamedRegions" },
        Arg = new ChangeTabRegionArg()
        {
            ids = new TabRegionIdentArg()
            {
                name = changedRegionName
            },
            reg = new TabNamedRegion()
            {
                left = leftCell,
                top = topCell,
                height = bottomCell,
                width = rightCell,
                name = newName
            }
        }
    };
    // Изменение именованного диапазона
    var result = somClient.ChangeTabNamedRegion(tChange);
    return result;
}