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"><TabRangePaste xmlns="http://www.fsight.ru/PP.SOM.Som"> <mon xmlns="">MGKDPJABAJEGGOAELIOKBIDEHDDAAAGEAJBDEOOOILGAFOPC!M!S!PEBIIJIBBAJEGGOAEEAPOAFJCAOCEDKJEEIODGHNJHMCAIENH!Sheets!1!G0:H3</mon>
<tArg xmlns=""><data><it type="1"> <data>ewAAAAMAAAB4nN2UzQ3CMAyFX5z0Z58OgLpJuSAhcWIBypEtmIAZGAAxEhAndgmpEMfSWnLb2G7ir091d7+c4I0QzYrz2iGxGwp/bbHHFmvsONTWQB+SPtUPi/Pm2jTNKnXdxDy94Ytx7tDhEZ/i4aYi3nd4zeQBygM2C5j0CNLI0ZAJONLXvPGU0SZ4tAw8ReN7qp4VPBOKuPifCdRTgZwQFKFoSg2QE2BMQNI4b8rNflbo9KBMpWI2KikfZSqVQuAmVqmkXyrpt9fJPVbJSgM635WxwiJGhcX7J0slrAUvSDyhhA4jCbOKFxefe7U=</data>
</it>
</data>
<mode>15</mode>
</tArg>
</TabRangePaste>
</s:Body>
</s:Envelope>
SOAP-ответ:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><TabRangePasteResult 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"> <result xmlns="">0</result>
</TabRangePasteResult>
</soapenv:Body>
</soapenv:Envelope>
JSON-запрос:
{
"TabRangePaste" :
{
"mon" : "MGKDPJABAJEGGOAELIOKBIDEHDDAAAGEAJBDEOOOILGAFOPC!M!S!PEBIIJIBBAJEGGOAEEAPOAFJCAOCEDKJEEIODGHNJHMCAIENH!Sheets!1!G0:H3",
"tArg" :
{
"data" :
{
"it" :
{
"@type" : "1",
"data" : "ewAAAAMAAAB4nN2UzQ3CMAyFX5z0Z58OgLpJuSAhcWIBypEtmIAZGAAxEhAndgmpEMfSWnLb2G7ir091d7+c4I0QzYrz2iGxGwp\/bbHHFmvsONTWQB+SPtUPi\/Pm2jTNKnXdxDy94Ytx7tDhEZ\/i4aYi3nd4zeQBygM2C5j0CNLI0ZAJONLXvPGU0SZ4tAw8ReN7qp4VPBOKuPifCdRTgZwQFKFoSg2QE2BMQNI4b8rNflbo9KBMpWI2KikfZSqVQuAmVqmkXyrpt9fJPVbJSgM635WxwiJGhcX7J0slrAUvSDyhhA4jCbOKFxefe7U="
}
},
"mode" : "15"
}
}
}
JSON-ответ:
{
"TabRangePasteResult" :
{
"result" : "0"
}
}
public static TabRangePasteResult PasteTabRange(string moniker, string sheetKey, string address, TabRangeClipboardItem[] pasteData)
{
var somClient = new SomPortTypeClient(); // Прокси-объект для выполнения операции
// Параметры выполнения операции
var tTab = new TabRangePaste()
{
mon = moniker + "!Sheets!" + sheetKey + '!' + address,
tArg = new TabRangePasteArg()
{
mode = 15,
data = pasteData
}
};
// Вставка диапазона ячеек
var result = somClient.TabRangePaste(tTab);
return result;
}