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">
<SetTabSheetData
xmlns="http://www.fsight.ru/PP.SOM.Som">
<tTabSheet
xmlns=" ">
<id>S1!M!S!E1!Tab</id>
</tTabSheet>
<tArg
xmlns=" ">
<TabSheetData>
<Cells>
<Cell SI="1" T="1" L="1">
<CD
FT=""
V="13.8386357"
VT="8"
/>
</Cell>
<Cell SI="2" T="1" L="2">
<CD
FT=""
V="13.4838968"
VT="8"
/>
</Cell>
<Cell SI="2" T="1" L="3">
<CD
FT=""
V="13.4838968"
VT="8"
/>
</Cell>
<Cell SI="2" T="1" L="4">
<CD
FT=""
V="13.4838968"
VT="8"
/>
</Cell>
</Cells>
</TabSheetData>
<range>
<left>1</left>
<top>1</top>
<width>4</width>
<height>1</height>
</range>
<setPattern>
<data>true</data>
</setPattern>
<getArg>
<pattern>
<data>true</data>
</pattern>
<range>
<left>1</left>
<top>1</top>
<width>4</width>
<height>1</height>
</range>
</getArg>
</tArg>
</SetTabSheetData>
</s:Body>
</s:Envelope>
SOAP-ответ:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<SetTabSheetDataResult
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">
<id xmlns=" ">
<id>S1!M!S!E1!Tab</id>
</id>
<sheet
xmlns=" ">
<TabSheetData>
<Cells>
<Cell L="1" T="1" SI="1">
<CD
FT="13.8386357"
VT="8"
V="13.8386357"
/>
</Cell>
<Cell L="2" T="1" SI="2">
<CD
FT="13.4838968"
VT="8"
V="13.4838968"
/>
</Cell>
<Cell L="3" T="1" SI="2">
<CD
FT="13.4838968"
VT="8"
V="13.4838968"
/>
</Cell>
<Cell L="4" T="1" SI="2">
<CD
FT="13.4838968"
VT="8"
V="13.4838968"
/>
</Cell>
</Cells>
</TabSheetData>
</sheet>
</SetTabSheetDataResult>
</soapenv:Body>
</soapenv:Envelope>
JSON-запрос:
{
"SetTabSheetData" :
{
"tTabSheet" :
{
"id" : "S1!M!S!E1!Tab"
},
"tArg" :
{
"TabSheetData" :
{
"Cells" :
{
"Cell" :
[
{
"@T" : "1",
"@SI" : "1",
"@L" : "1",
"CD" :
{
"@V" : "13.8386357",
"@FT" : "",
"@VT" : "8"
}
},
{
"@T" : "1",
"@SI" : "2",
"@L" : "2",
"CD" :
{
"@V" : "13.4838968",
"@FT" : "",
"@VT" : "8"
}
},
{
"@T" : "1",
"@SI" : "2",
"@L" : "3",
"CD" :
{
"@V" : "13.4838968",
"@FT" : "",
"@VT" : "8"
}
},
{
"@T" : "1",
"@SI" : "2",
"@L" : "4",
"CD" :
{
"@V" : "13.4838968",
"@FT" : "",
"@VT" : "8"
}
}
]
}
},
"range" :
{
"left" : "1",
"top" : "1",
"width" : "4",
"height" : "1"
},
"setPattern" :
{
"data" : "true"
},
"getArg" :
{
"pattern" :
{
"data" : "true"
},
"range" :
{
"left" : "1",
"top" : "1",
"width" : "4",
"height" : "1"
}
}
}
}
}
JSON-ответ:
{
"SetTabSheetDataResult" :
{
"id" :
{
"id" : "S1!M!S!E1!Tab"
},
"sheet" :
{
"TabSheetData" :
{
"Cells" :
{
"Cell" :
[
{
"@T" : "1",
"@L" : "1",
"@SI" : "1",
"CD" :
{
"@V" : "13.8386357",
"@FT" : "13.8386357",
"@VT" : "8"
}
},
{
"@T" : "1",
"@L" : "2",
"@SI" : "2",
"CD" :
{
"@V" : "13.4838968",
"@FT" : "13.4838968",
"@VT" : "8"
}
},
{
"@T" : "1",
"@L" : "3",
"@SI" : "2",
"CD" :
{
"@V" : "13.4838968",
"@FT" : "13.4838968",
"@VT" : "8"
}
},
{
"@T" : "1",
"@L" : "4",
"@SI" : "2",
"CD" :
{
"@V" : "13.4838968",
"@FT" : "13.4838968",
"@VT" : "8"
}
}
]
}
}
}
}
}
public static SetTabSheetDataResult ChangeTabData(EaxId eax, TabRange range, TabData newData)
{
var somClient = new SomPortTypeClient(); // Прокси-объект для выполнения операции
// Параметры выполнения операции
var tSet = new SetTabSheetData()
{
tArg = new SetTabSheetDataArg()
{
setPattern = new TabSheetPattern()
{
data = true,
},
//Изменяемый диапазон ячеек
range = range,
//Новые данные ячеек
TabSheetData = newData,
getArg = new GetTabSheetDataArg()
{
pattern = new TabSheetPattern()
{
data = true,
},
range = range
}
},
tTabSheet = new TabSheetId() { id = eax.id + "!Tab" }
};
// Выполняем изменение диаграммы
var result = somClient.SetTabSheetData(tSet);
return result;
}