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">
<GetTabSheetData
xmlns="http://www.fsight.ru/PP.SOM.Som">
<tTabSheet
xmlns=" ">
<id>S1!M!S!E1!Tab</id>
</tTabSheet>
<tArg
xmlns=" ">
<pattern>
<data>true</data>
<styles>Get</styles>
</pattern>
<range>
<left>1</left>
<top>1</top>
<width>4</width>
<height>1</height>
</range>
</tArg>
</GetTabSheetData>
</s:Body>
</s:Envelope>
SOAP-ответ:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<GetTabSheetDataResult
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="1,38"
VT="8"
V="1.38386357"
/>
</Cell>
<Cell L="2" T="1" SI="2">
<CD
FT="1,35"
VT="8"
V="1.34838968"
/>
</Cell>
<Cell L="3" T="1" SI="2">
<CD
FT="1,35"
VT="8"
V="1.34838968"
/>
</Cell>
<Cell L="4" T="1" SI="2">
<CD
FT="1,35"
VT="8"
V="1.34838968"
/>
</Cell>
</Cells>
<Styles>
<Style B="">
<Text
HA="0"
VA="1"
WW="1"
M="7.56
5.67 7.56
5.67"
/>
<NumberFormat
F="#,##0.00"
FT="1"
/>
<Fill
C="#FFFFFF"
/>
<Font
F="Arial"
S="8"
C="#000000"
A="0"
/>
<Borders
/>
<Hyperlink
T=""
A=""
E="false"
C="#000000"
U="true"
ST="false"
HT="0"
/>
</Style>
<Style B="">
<Text
HA="0"
VA="1"
WW="1"
M="7.56
5.67 7.56
5.67"
/>
<NumberFormat
F="#,##0.00"
FT="1"
/>
<Fill
C="#FFFFFF"
/>
<Font
F="Arial"
S="8"
C="#000000"
A="0"
/>
<Borders>
<Border
I="2"
S="0"
C="#BBBBBB"
W="2"
/>
<Border
I="3"
S="0"
C="#BBBBBB"
W="2"
/>
</Borders>
<Hyperlink
T=""
A=""
E="false"
C="#000000"
U="true"
ST="false"
HT="0"
/>
</Style>
<Style B="">
<Text
HA="0"
VA="1"
WW="1"
M="7.56
5.67 7.56
5.67"
/>
<NumberFormat
F="#,##0.00"
FT="1"
/>
<Fill
C="#FFFFFF"
/>
<Font
F="Arial"
S="8"
C="#000000"
A="0"
/>
<Borders>
<Border
I="2"
S="0"
C="#BBBBBB"
W="2"
/>
</Borders>
<Hyperlink
T=""
A=""
E="false"
C="#000000"
U="true"
ST="false"
HT="0"
/>
</Style>
</Styles>
</TabSheetData>
</sheet>
</GetTabSheetDataResult>
</soapenv:Body>
</soapenv:Envelope>
JSON-запрос:
{
"GetTabSheetData" :
{
"tTabSheet" :
{
"id" : "S1!M!S!E1!Tab"
},
"tArg" :
{
"pattern" :
{
"data" : "true",
"styles" : "Get"
},
"range" :
{
"left" : "1",
"top" : "1",
"width" : "4",
"height" : "1"
}
}
}
}
JSON-ответ:
{
"GetTabSheetDataResult" :
{
"id" :
{
"id" : "S1!M!S!E1!Tab"
},
"sheet" :
{
"TabSheetData" :
{
"Cells" :
{
"Cell" :
[
{
"@T" : "1",
"@L" : "1",
"@SI" : "1",
"CD" :
{
"@V" : "1.38386357",
"@FT" : "1,38",
"@VT" : "8"
}
},
{
"@T" : "1",
"@L" : "2",
"@SI" : "2",
"CD" :
{
"@V" : "1.34838968",
"@FT" : "1,35",
"@VT" : "8"
}
},
{
"@T" : "1",
"@L" : "3",
"@SI" : "2",
"CD" :
{
"@V" : "1.34838968",
"@FT" : "1,35",
"@VT" : "8"
}
},
{
"@T" : "1",
"@L" : "4",
"@SI" : "2",
"CD" :
{
"@V" : "1.34838968",
"@FT" : "1,35",
"@VT" : "8"
}
}
]
},
"Styles" :
{
"Style" :
[
{
"@B" : "",
"Text" :
{
"@VA" : "1",
"@HA" : "0",
"@M" : "7.56 5.67 7.56 5.67",
"@WW" : "1"
},
"NumberFormat" :
{
"@F" : "#,##0.00",
"@FT" : "1"
},
"Fill" :
{
"@C" : "#FFFFFF"
},
"Font" :
{
"@A" : "0",
"@S" : "8",
"@C" : "#000000",
"@F" : "Arial"
},
"Borders" : "",
"Hyperlink" :
{
"@A" : "",
"@C" : "#000000",
"@T" : "",
"@E" : "false",
"@U" : "true",
"@ST" : "false",
"@HT" : "0"
}
},
{
"@B" : "",
"Text" :
{
"@VA" : "1",
"@HA" : "0",
"@M" : "7.56 5.67 7.56 5.67",
"@WW" : "1"
},
"NumberFormat" :
{
"@F" : "#,##0.00",
"@FT" : "1"
},
"Fill" :
{
"@C" : "#FFFFFF"
},
"Font" :
{
"@A" : "0",
"@S" : "8",
"@C" : "#000000",
"@F" : "Arial"
},
"Borders" :
{
"Border" :
[
{
"@S" : "0",
"@C" : "#BBBBBB",
"@W" : "2",
"@I" : "2"
},
{
"@S" : "0",
"@C" : "#BBBBBB",
"@W" : "2",
"@I" : "3"
}
]
},
"Hyperlink" :
{
"@A" : "",
"@C" : "#000000",
"@T" : "",
"@E" : "false",
"@U" : "true",
"@ST" : "false",
"@HT" : "0"
}
},
{
"@B" : "",
"Text" :
{
"@VA" : "1",
"@HA" : "0",
"@M" : "7.56 5.67 7.56 5.67",
"@WW" : "1"
},
"NumberFormat" :
{
"@F" : "#,##0.00",
"@FT" : "1"
},
"Fill" :
{
"@C" : "#FFFFFF"
},
"Font" :
{
"@A" : "0",
"@S" : "8",
"@C" : "#000000",
"@F" : "Arial"
},
"Borders" :
{
"Border" :
[
{
"@S" : "0",
"@C" : "#BBBBBB",
"@W" : "2",
"@I" : "2"
}
]
},
"Hyperlink" :
{
"@A" : "",
"@C" : "#000000",
"@T" : "",
"@E" : "false",
"@U" : "true",
"@ST" : "false",
"@HT" : "0"
}
}
]
}
}
}
}
}
public static GetTabSheetDataResult GetTabData(EaxId eax)
{
var somClient = new SomPortTypeClient(); // Прокси-объект для выполнения операции
// Параметры выполнения операции
var tGet = new GetTabSheetData()
{
tArg = new GetTabSheetDataArg()
{
pattern = new TabSheetPattern()
{
data = true,
styles = ListOperation.Get
},
range = new TabRange()
{
left = 1,
top = 1,
height = 1,
width = 4
}
},
tTabSheet = new TabSheetId() { id = eax.id + "!Tab" }
};
// Получаем диаграмму
var result = somClient.GetTabSheetData(tGet);
return result;
}