SOAPНиже приведен пример использования операции GetWbkMd для получения диаграммы рабочей книги. В запросе передаются: экземпляр открытой рабочей книги, параметры получения различных видов диаграмм для рабочей книги. В ответе приходят запрошенные диаграммы.
<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">
<GetWbkMd xmlns="http://www.fsight.ru/PP.SOM.Som">
<tWbk
xmlns=" ">
<tArg
xmlns=" ">
<pattern>
<getLanerChart>
<pattern>
<asImage>
<getModellingChart>
<pattern>
<asImage>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<GetWbkMdResult
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=" ">
<meta
xmlns=" ">
<obInst>
<obDesc isShortcut="0" isLink="0">
<series
count="4">
<lanerChart>
<series>
<it>
<it>
<it>
<it>
<it>
<it>
<it>
<it>
<it>
<it>
<it>
<it>
<it>
<it>
<it>
<it>
<it>
<it>
<it>
<getLanerChart>
<id>
<meta>
<getModellingChart>
<id>
<meta>
{
"GetWbkMd" :
{
"tWbk" :
{
"id" : "S1!M!S!W5"
},
"tArg" :
{
"pattern" :
{
"obInst" : "true",
"lanerChart" : "true",
"getLanerChart" :
{
"pattern" :
{
"data" : "false",
"decoration" : "false",
"hiChart" : "false",
"asImage" :
{
"width" : "400",
"height" : "300",
"dpi" : "96",
"format" : "image\/png"
}
}
},
"getModellingChart" :
{
"pattern" :
{
"data" : "false",
"decoration" : "false",
"hiChart" : "false",
"asImage" :
{
"width" : "400", "height" : "300", "dpi" : "96", "format" : "image\/png" } } } } } } }
{
"GetWbkMdResult" :
{
"id" :
{
"id" : "S1!M!S!W5"
},
"meta" :
{
"obInst" :
{
"obDesc" :
{
"@isShortcut" : "0", "@isLink" : "0", "i" : "WBK_CALC", "n" : "Вычисляемые ряды", "k" : "5541", "c" : "2827", "p" : "5471", "h" : "0" } },
"dirty" : "1",
"windowsPosition" : "Vertical",
"hasPivot" : "0",
"hasLaner" : "1",
"series" :
{
"@count" : "4",
"its" : ""
},
"lanerChart" :
{
"type" : "Simple",
"series" :
{
"it" :
[
{
"type" : "Simple",
"available" : "0",
"visible" : "0"
},
{
"type" : "Factor",
"available" : "0",
"visible" : "0"
},
{
"type" : "Fact",
"available" : "0",
"visible" : "1"
},
{
"type" : "Modeling",
"available" : "0",
"visible" : "1"
},
{
"type" : "Forecast",
"available" : "0",
"visible" : "1"
},
{
"type" : "Residuals",
"available" : "0",
"visible" : "1"
},
{
"type" : "UpperConfidenceLevel",
"available" : "0",
"visible" : "0"
},
{
"type" : "LowerConfidenceLevel",
"available" : "0",
"visible" : "0"
},
{
"type" : "DUpperConfidenceLevel",
"available" : "0",
"visible" : "0"
},
{
"type" : "DLowerConfidenceLevel",
"available" : "0",
"visible" : "0"
},
{
"type" : "B01",
"available" : "0",
"visible" : "1"
},
{
"type" : "D10",
"available" : "0",
"visible" : "1"
},
{
"type" : "D11",
"available" : "0",
"visible" : "1"
},
{
"type" : "D12",
"available" : "0",
"visible" : "1"
},
{
"type" : "D13",
"available" : "0",
"visible" : "1"
},
{
"type" : "Aggregation",
"available" : "0",
"visible" : "1"
},
{
"type" : "Factors",
"available" : "0",
"visible" : "1"
},
{
"type" : "Weights",
"available" : "0",
"visible" : "1"
},
{
"type" : "CompositionRelevance",
"available" : "0",
"visible" : "1"
}
]
}
},
"getLanerChart" :
{
"id" :
{
"id" : "S1!M!S!W5!wbkChart"
},
"meta" :
{
"asImage" : "iVBORw0KGgoAAAANSUhEUgAAAZAAAAEsCAYAAADtt+XCAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAA8aSURBVHhe7dqBjptKEgVQPj1\/npVX8gshgIvrxgyuM5KlTEw11OkSV4w9\/fZDgAABAgQCgSmoUUKAAAECBH4LEENAgAABApGAAInYFBEgQICAADEDBAgQIBAJCJCITREBAgQICBAzQIAAAQKRgACJ2BQRIECAgAAxAwQIECAQCQiQiE0RAQIECAgQM0CAAAECkYAAidgUESBAgIAAMQMECBAgEAkIkIhNEQECBAgIEDNAgAABApGAAInYFBEgQICAADEDBAgQIBAJCJCITREBAgQICBAzQIAAAQKRgACJ2BQRIECAwFsBMk3b5Y\/3nq8n8\/J3\/AQIECBwX4E4QF6FwTJc5r\/vBc99KV05AQIEegnEAfJg2gqCraeP+ZNIL2bdEiBA4PsETguQZVh4Avm+4dERAQK9BU4JkDnpMziSAPn169dvLwZmwAyYgc\/PQCUaTwmQtbBIAmTewGOA\/BAgQIDA+QLV++3QAFmGxNrv6Qfo1YbOp3UGAgQIfLdA9X77VoAsCdNwqGxFtaHKWo4hQIAAgW2B6v12aICcuSHVhs68BmsTIECgg0D1fitAOkyDHgkQIHBAQIAcwHIoAQIECPwRECCmgQABAgQiAQESsSkiQIAAAQFiBggQIEAgEhAgEZsiAgQIEBAgZoAAAQIEIgEBErEpIkCAAAEBYgYIECBAIBIQIBGbIgIECBAQIGaAAAECBCIBARKxKSJAgAABAWIGCBAgQCASECARmyICBAgQECBmgAABAgQiAQESsSkiQIAAAQFiBggQIEAgEhAgEZsiAgQIEBAgZoAAAQIEIgEBErEpIkCAAAEBYgYIECBAIBIQIBGbIgIECBAQIGaAAAECBCIBARKxKSJAgAABAWIGCBAgQCASECARmyICBAgQECBmgAABAgQiAQESsSkiQIAAAQFiBggQIEAgEhAgEZsiAgQIEBAgZoAAAQIEIgEBErEpIkCAAAEBYgYIECBAIBIQIBGbIgIECBD4SIBM07Qp\/Xhv+f7a\/1W3qtpQdT3HESBAgMC6QPV+u50AL2T3wmAeHM9\/r\/3fkc2rNnRkTccSIECAwL8C1fttHCCPU249gQgQI0mAAIH7CgiQ++6dKydAgMClAl8RII8mtl6X6jo5AQIEvljgKwJkvj\/Vhr54T7VGgACBjwhU77dDPwOZf2C+\/JD9+fveN7f2ZKoNfUTXSQgQIPDFAtX77VsBsvRLw6GyD9WGKms5hgABAgS2Bar326EBcuaGVBs68xqsTYAAgQ4C1futAOkwDXokQIDAAQEBcgDLoQQIECDwR0CAmAYCBAgQiAQESMSmiAABAgQEiBkgQIAAgUhAgERsiggQIEBAgJgBAgQIEIgEBEjEpogAAQIEBIgZIECAAIFIQIBEbIoIECBAQICYAQIECBCIBARIxKaIAAECBASIGSBAgACBSECARGyKCBAgQECAmAECBAgQiAQESMSmiAABAgQEiBkgQIAAgUhAgERsiggQIEBAgJgBAgQIEIgEBEjEpogAAQIEBIgZIECAAIFIQIBEbIoIECBAQICYAQIECBCIBARIxKaIAAECBASIGSBAgACBSECARGyKCBAgQECAmAECBAgQiAQESMSmiAABAgQEiBkgQIAAgUhAgERsiggQIEBAgJgBAgQIEIgEBEjEpogAAQIEBIgZIECAAIFIQIBEbIoIECBAQICYAQIECBCIBE4PkGmafj9eWz\/P9+fHvKrZ67TaUKSliAABAgT+E6jeb7cTYAdzGQprhy7DpVIjQEwwAQIErhe4NEC2nj6eLHtPLlt01Yaup3cFBAgQuLdA9X57yhPI2tNG8gTyaGLrde\/tcfUECBD4uQKXBsic5RkcSYDM16k29HO3xJURIEDgHgLV++2PfgIRIPcYNldJgMB3CZweIGvfqNr7xtXa5yJHyKsNHVnTsQQIECDwr0D1fhs9gWyBJx+OVzev2lB1PccRIECAwLpA9X47NEDO3IxqQ2deg7UJECDQQaB6vxUgHaZBjwQIEDggIEAOYDmUAAECBP4ICBDTQIAAAQKRgACJ2BQRIECAgAAxAwQIECAQCQiQiE0RAQIECAgQM0CAAAECkYAAidgUESBAgIAAMQMECBAgEAkIkIhNEQECBAgIEDNAgAABApGAAInYFBEgQICAADEDBAgQIBAJCJCITREBAgQICBAzQIAAAQKRgACJ2BQRIECAgAAxAwQIECAQCQiQiE0RAQIECAgQM0CAAAECkYAAidgUESBAgIAAMQMECBAgEAkIkIhNEQECBAgIEDNAgAABApGAAInYFBEgQICAADEDBAgQIBAJCJCITREBAgQICBAzQIAAAQKRgACJ2BQRIECAgAAxAwQIECAQCQiQiE0RAQIECAgQM0CAAAECkYAAidgUESBAgIAAMQMECBAgEAkIkIhNEQECBAicHiDTNP1+vLZ+1t5\/VbO3bdWGbD0BAgQIvCdQvd9uJ8DO+efBsRYia++\/qnnVbrWhV+t4nwABAgT2Bar3WwFikggQIEDgL4GvCJBHE1sv+02AAAEC5wh8RYDMaaoNncNpVQIECPQRqN5v\/Qmrz0zolAABAiWB0wNk61tWj6t7vrf84Ny3sEp75yACBAhcKnBqgGx1tve13nc1qg29ex71BAgQ6C5Qvd9Gf8K6Arfa0BXX5pwECBD4JoHq\/VaAfNOu64UAAQIDBATIAERLECBAoKOAAOm463omQIDAAAEBMgDREgQIEOgoIEA67rqeCRAgMEBAgAxAtAQBAgQ6CgiQjruuZwIECAwQECADEC1BgACBjgICpOOu65kAAQIDBATIAERLECBAoKOAAOm463omQIDAAAEBMgDREgQIEOgoIEA67rqeCRAgMEBAgAxAtAQBAgQ6CgiQjruuZwIECAwQECADEC1BgACBjgICpOOu65kAAQIDBATIAERLECBAoKOAAOm463omQIDAAAEBMgDREgQIEOgoIEA67rqeCRAgMEBAgAxAtAQBAgQ6CgiQjruuZwIECAwQECADEC1BgACBjgICpOOu65kAAQIDBATIAERLECBAoKOAAOm463omQIDAAAEBMgDREgQIEOgoIEA67rqeCRAgMEBAgAxAtAQBAgQ6CgiQjruuZwIECAwQECADEC1BgACBjgICpOOu65kAAQIDBATIAERLECBAoKPARwJkmqbfj9fWz\/P9+TGvarbWqjbUcbP1TIAAgZEC1fvt9t3\/xdUsQ2Ht8GW4VGoEyMgxsBYBAgSOC1weIFtPH89W9p5c1tqtNnScSgUBAgQIzAWq99vTnkDWnjaOPoE8mth62W4CBAgQOEfglACZf35xJAyexx6pWbJUGzqH06oECBDoI1C93\/7oJ5DkkarPFuuUAAEC5wh8JEDWvlG1942rtc9Fqu1XG6qu5zgCBAgQWBeo3m\/jJ5At+KMfjlc3sNpQdT3HESBAgMAPC5CzNkSAnCVrXQIECPwtUL3fDn8COWsjqg2ddX7rEiBAoItA9X4rQLpMhD4JECBQFBAgRSiHESBAgIA\/YZkBAgQIEBgg4AlkAKIlCBAg0FFAgHTcdT0TIEBggIAAGYBoCQIECHQUECAdd13PBAgQGCAgQAYgWoIAAQIdBQRIx13XMwECBAYICJABiJYgQIBARwEB0nHX9UyAAIEBAgJkAKIlCBAg0FFAgHTcdT0TIEBggIAAGYBoCQIECHQUECAdd13PBAgQGCAgQAYgWoIAAQIdBQRIx13XMwECBAYICJABiJYgQIBARwEB0nHX9UyAAIEBAgJkAKIlCBAg0FFAgHTcdT0TIEBggIAAGYBoCQIECHQUECAdd13PBAgQGCAgQAYgWoIAAQIdBQRIx13XMwECBAYICJABiJYgQIBARwEB0nHX9UyAAIEBAgJkAKIlCBAg0FFAgHTcdT0TIEBggIAAGYBoCQIECHQUECAdd13PBAgQGCAgQAYgWoIAAQIdBQRIx13XMwECBAYIfCxApmnavNzHe8v31\/6v0m+1ocpajiFAgACBbYHq\/Xb77l\/Q3QuDeXA8\/732f4XT\/P+QakPV9RxHgAABAusC1fvtWwHyOPXWE4gAMZoECBC4p8BXBMijia3XPbfFVRMgQODnC5wSIFufaaxxeAL5+UPiCgkQILAmcEqAvAqK+fsCxGASIEDgngKXBcj8A\/PlE8vz971vbm1xVxu653a5agIECPwcger99u0P0ZctJ+FQYas2VFnLMQQIECCwLVC93w4PkLM2pdrQWee3LgECBLoIVO+3AqTLROiTAAECRQEBUoRyGAECBAj8LSBATAQBAgQIRAICJGJTRIAAAQICxAwQIECAQCQgQCI2RQQIECAgQMwAAQIECEQCAiRiU0SAAAECAsQMECBAgEAkIEAiNkUECBAgIEDMAAECBAhEAgIkYlNEgAABAgLEDBAgQIBAJCBAIjZFBAgQICBAzAABAgQIRAICJGJTRIAAAQICxAwQIECAQCQgQCI2RQQIECAgQMwAAQIECEQCAiRiU0SAAAECAsQMECBAgEAkIEAiNkUECBAgIEDMAAECBAhEAgIkYlNEgAABAgLEDBAgQIBAJCBAIjZFBAgQICBAzAABAgQIRAICJGJTRIAAAQICxAwQIECAQCQgQCI2RQQIECAgQMwAAQIECEQCAiRiU0SAAAECAsQMECBAgEAkIEAiNkUECBAg8LEAmaZpU\/vx3vP1PGj5e3Wrqg1V13McAQIECKwLVO+323f\/guyrMFiGy\/z3veBZO3W1ocJlO4QAAQIEdgSq99u3AuRx\/q0g2Hr6mD+JHNnBakNH1nQsAQIECPwrUL3fnhogy7A4+gTyaMKLgRkwA2bg8zNQCdZDAbL2J6vKn6KexxwNkEoDjiFAgACBawQOBcjaJe79CevdJ5BrSJyVAAECBCoCwwNk+ZSx9nvlqaVy8Y4hQIAAgesE3g6Q5aULh+s205kJECDwSYHhAfLJi3cuAgQIELhOQIBcZ+\/MBAgQuLWAALn19rl4AgQIXCcgQK6zd2YCBAjcWkCA3Hr7XDwBAgSuExAg19k7MwECBG4tIEBuvX0ungABAtcJCJDr7J2ZAAECtxYQILfePhdPgACB6wQEyHX2zkyAAIFbCwiQW2+fiydAgMB1AgLkOntnJkCAwK0FBMitt8\/FEyBA4DqB\/wG7gU7950YJDgAAAABJRU5ErkJggg==",
"toolTipImageMap" : ""
}
},
"getModellingChart" :
{
"id" :
{
"id" : "S1!M!S!W5!wbkModChart"
},
"meta" :
{
"asImage" : "iVBORw0KGgoAAAANSUhEUgAAAZAAAAEsCAYAAADtt+XCAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAx\/SURBVHhe7dVBbmNHEAVBHl03l8GtVx\/tfgapjAG0IwusqMbk69c\/AgQIECBwIPA6+I6vECBAgACBXwHxCAgQIEDgSEBAjth8iQABAgQExBsgQIAAgSMBATli8yUCBAgQEBBvgAABAgSOBATkiM2XCBAgQEBAvAECBAgQOBIQkCM2XyJAgAABAfEGCBAgQOBIQECO2HyJAAECBATEGyBAgACBIwEBOWLzJQIECBAQEG+AAAECBI4EBOSIzZcIECBAQEC8AQIECBA4EhCQIzZfIkCAAAEB8QYIECBA4EhAQI7YfIkAAQIEBMQbIECAAIEjAQE5YvMlAgQIEBAQb4AAAQIEjgQE5IjNlwgQIEDgawLy8\/Pz64+BN+ANeAP\/zxt4ksevCsiThXyGAAECBP6bwDvST\/4JyBMlnyFAgEBIQEBCx7YqAQIEbgoIyE1NswgQIBASEJDQsa1KgACBmwICclPTLAIECIQEBCR0bKsSIEDgpoCA3NQ0iwABAiEBAQkd26oECBC4KSAgNzXNIkCAQEhAQELHtioBAgRuCgjITU2zCBAgEBIQkNCxrUqAAIGbAgJyU9MsAgQIhAQEJHRsqxIgQOCmgIDc1DSLAAECIQEBCR3bqgQIELgpICA3Nc0iQIBASEBAQse2KgECBG4KCMhNTbMIECAQEhCQ0LGtSoAAgZsCAnJT0ywCBAiEBAQkdGyrEiBA4KaAgNzUNIsAAQIhAQEJHduqBAgQuCkgIDc1zSJAgEBIQEBCx7YqAQIEbgoIyE1NswgQIBASEJDQsa1KgACBmwICclPTLAIECIQEBCR0bKsSIEDgpoCA3NQ0iwABAiEBAQkd26oECBC4KSAgNzXNIkCAQEhAQELHtioBAgRuCgjITU2zCBAgEBIQkNCxrUqAAIGbAgJyU9MsAgQIhAQEJHRsqxIgQOCmgIDc1DSLAAECIQEBCR3bqgQIELgp8CcD8l7KHwNvwBvwBvZv4EmQXk8+9AmfeVrET\/itfgMBAgS+WeDp\/7cC8s1X9tsJECAwEBCQAaqRBAgQKAgISOHKdiRAgMBAQEAGqEYSIECgICAghSvbkQABAgMBARmgGkmAAIGCgIAUrmxHAgQIDAQEZIBqJAECBAoCAlK4sh0JECAwEBCQAaqRBAgQKAgISOHKdiRAgMBAQEAGqEYSIECgICAghSvbkQABAgMBARmgGkmAAIGCgIAUrmxHAgQIDAQEZIBqJAECBAoCAlK4sh0JECAwEBCQAaqRBAgQKAgISOHKdiRAgMBAQEAGqEYSIECgICAghSvbkQABAgMBARmgGkmAAIGCgIAUrmxHAgQIDAQEZIBqJAECBAoCAlK4sh0JECAwEBCQAaqRBAgQKAgISOHKdiRAgMBAQEAGqEYSIECgICAghSvbkQABAgMBARmgGkmAAIGCgIAUrmxHAgQIDAQEZIBqJAECBAoCAlK4sh0JECAwEBCQAaqRBAgQKAgISOHKdiRAgMBAQEAGqEYSIECgICAghSvbkQABAgMBARmgGkmAAIGCgIAUrmxHAgQIDAT+ZEDeS\/lj4A14A97A\/g086dLryYc+4TNPi\/gJv9VvIECAwDcLPP3\/VkC++cp+OwECBAYCAjJANZIAAQIFAQEpXNmOBAgQGAgIyADVSAIECBQEBKRwZTsSIEBgICAgA1QjCRAgUBAQkMKV7UiAAIGBgIAMUI0kQIBAQUBACle2IwECBAYCAjJANZIAAQIFAQEpXNmOBAgQGAgIyADVSAIECBQEBKRwZTsSIEBgICAgA1QjCRAgUBAQkMKV7UiAAIGBgIAMUI0kQIBAQUBACle2IwECBAYCAjJANZIAAQIFAQEpXNmOBAgQGAgIyADVSAIECBQEBKRwZTsSIEBgICAgA1QjCRAgUBAQkMKV7UiAAIGBgIAMUI0kQIBAQUBACle2IwECBAYCAjJANZIAAQIFAQEpXNmOBAgQGAgIyADVSAIECBQEBKRwZTsSIEBgICAgA1QjCRAgUBAQkMKV7UiAAIGBgIAMUI0kQIBAQUBACle2IwECBAYCAjJANZIAAQIFAQEpXNmOBAgQGAgIyADVSAIECBQEBKRwZTsSIEBgICAgA1QjCRAgUBAQkMKV7UiAAIGBgIAMUI0kQIBAQeBPBuS9lD8G3oA34A3s38CTUL6efOgTPvO0iJ\/wW\/0GAgQIfLPA0\/9vBeSbr+y3EyBAYCAgIANUIwkQIFAQEJDCle1IgACBgYCADFCNJECAQEFAQApXtiMBAgQGAgIyQDWSAAECBQEBKVzZjgQIEBgICMgA1UgCBAgUBASkcGU7EiBAYCAgIANUIwkQIFAQEJDCle1IgACBgYCADFCNJECAQEFAQApXtiMBAgQGAgIyQDWSAAECBQEBKVzZjgQIEBgICMgA1UgCBAgUBASkcGU7EiBAYCAgIANUIwkQIFAQEJDCle1IgACBgYCADFCNJECAQEFAQApXtiMBAgQGAgIyQDWSAAECBQEBKVzZjgQIEBgICMgA1UgCBAgUBASkcGU7EiBAYCAgIANUIwkQIFAQEJDCle1IgACBgYCADFCNJECAQEFAQApXtiMBAgQGAgIyQDWSAAECBQEBKVzZjgQIEBgICMgA1UgCBAgUBASkcGU7EiBAYCAgIANUIwkQIFAQEJDCle1IgACBgYCADFCNJECAQEFAQApXtiMBAgQGAgIyQDWSAAECBQEBKVzZjgQIEBgI\/MmAvJfyx8Ab8Aa8gf0beNKl15MPfcJnnhbxE36r30CAAIFvFnj6\/62AfPOV\/XYCBAgMBARkgGokAQIECgICUriyHQkQIDAQEJABqpEECBAoCAhI4cp2JECAwEBAQAaoRhIgQKAgICCFK9uRAAECAwEBGaAaSYAAgYKAgBSubEcCBAgMBARkgGokAQIECgICUriyHQkQIDAQEJABqpEECBAoCAhI4cp2JECAwEBAQAaoRhIgQKAgICCFK9uRAAECAwEBGaAaSYAAgYKAgBSubEcCBAgMBARkgGokAQIECgICUriyHQkQIDAQEJABqpEECBAoCAhI4cp2JECAwEBAQAaoRhIgQKAgICCFK9uRAAECAwEBGaAaSYAAgYKAgBSubEcCBAgMBARkgGokAQIECgICUriyHQkQIDAQEJABqpEECBAoCAhI4cp2JECAwEBAQAaoRhIgQKAgICCFK9uRAAECAwEBGaAaSYAAgYKAgBSubEcCBAgMBARkgGokAQIECgICUriyHQkQIDAQEJABqpEECBAoCAhI4cp2JECAwEBAQAaoRhIgQKAgICCFK9uRAAECAwEBGaAaSYAAgYLAnwzIeyl\/DLwBb8Ab2L+BJ6F8PfnQJ3zmaRE\/4bf6DQQIEPhmgaf\/3wrIN1\/ZbydAgMBAQEAGqEYSIECgICAghSvbkQABAgMBARmgGkmAAIGCgIAUrmxHAgQIDAQEZIBqJAECBAoCAlK4sh0JECAwEBCQAaqRBAgQKAgISOHKdiRAgMBAQEAGqEYSIECgICAghSvbkQABAgMBARmgGkmAAIGCgIAUrmxHAgQIDAQEZIBqJAECBAoCAlK4sh0JECAwEBCQAaqRBAgQKAgISOHKdiRAgMBAQEAGqEYSIECgICAghSvbkQABAgMBARmgGkmAAIGCgIAUrmxHAgQIDAQEZIBqJAECBAoCAlK4sh0JECAwEBCQAaqRBAgQKAgISOHKdiRAgMBAQEAGqEYSIECgICAghSvbkQABAgMBARmgGkmAAIGCgIAUrmxHAgQIDAQEZIBqJAECBAoCAlK4sh0JECAwEBCQAaqRBAgQKAgISOHKdiRAgMBAQEAGqEYSIECgICAghSvbkQABAgMBARmgGkmAAIGCgIAUrmxHAgQIDAQEZIBqJAECBAoCAlK4sh0JECAwEPiTAXkv5Y+BN+ANeAP7N\/CkS68nH\/IZAgQIECDwbwEB8SYIECBA4EhAQI7YfIkAAQIEBMQbIECAAIEjAQE5YvMlAgQIEBAQb4AAAQIEjgQE5IjNlwgQIEBAQLwBAgQIEDgSEJAjNl8iQIAAAQHxBggQIEDgSEBAjth8iQABAgQExBsgQIAAgSMBATli8yUCBAgQEBBvgAABAgSOBATkiM2XCBAgQEBAvAECBAgQOBIQkCM2XyJAgAABAfEGCBAgQOBIQECO2HyJAAECBATEGyBAgACBIwEBOWLzJQIECBAQEG+AAAECBI4EBOSIzZcIECBAQEC8AQIECBA4EhCQIzZfIkCAAAEB8QYIECBA4EjgH9A8Ekmkt7oyAAAAAElFTkSuQmCC",
"toolTipImageMap" : ""
}
}
}
}
}
Функция GetWbkChart получает различные виды диаграмм для рабочей книги. Входные параметры:
wbk. Экземпляр рабочей книги.
После выполнения функция возвращает результат извлечения данных. В окно консоли выводится информация о рядах диаграммы.
public static GetWbkMdResult GetWbkChart(WbkId wbk)
{ // Задаем параметры получения диаграммы
GetChartArg ChartPtn = new GetChartArg()
{
pattern = new ChartMdPattern()
{
data = false,
decoration = false,
hiChart = false,
asImage = new ImageProperties()
{
format = "image/png",
width = 400,
height = 400,
dpi = 96.0
}
}
};
// Задаём параметры выполнения операции
var tOp = new GetWbkMd
{
tWbk = wbk,
tArg = new GetWbkMdArg
{// Задаём шаблон извлечения данных
pattern = new WbkMdPattern
{
getLanerChart = ChartPtn, lanerChart = true, getModellingChart = ChartPtn } } }; // Создаем прокси-объект для выполнения операции var somClient = new SomPortTypeClient(); // Выполняем операцию var gRes = somClient.GetWbkMd(tOp);
// Сохраняем диаграммы в виде изображений
if (chartSave(gRes.meta.getLanerChart.meta.asImage, "C:\\LanerChart.png"))
{ Console.WriteLine("Диаграмма рабочей книги сохранена в файл 'LanerChart.png'"); }
else { Console.WriteLine("Диаграмма рабочей книги отсутствует"); };
if (chartSave(gRes.meta.getModellingChart.meta.asImage, "C:\\ModellingChart.png"))
{ Console.WriteLine("Диаграмма вычисляемого ряда сохранена в файл 'ModellingChart.png'"); }
else { Console.WriteLine("Диаграмма вычисляемого ряда отсутствует"); };
// Выводим данные о диаграмме рабочей книги в окно консоли
WbkChart lanerCh = gRes.meta.lanerChart;
switch (lanerCh.type)
{
case WbkChartType.DetermAggregation:
Console.WriteLine("Диаграмма для данных, полученных в результате расчёта агрегации");
break;
case WbkChartType.Simple:
Console.WriteLine("Диаграмма для данных в таблице");
break;
case WbkChartType.SpliceMethod:
Console.WriteLine("Диаграмма для данных, полученных в результате сращивания рядов");
break;
case WbkChartType.StatMethod:
Console.WriteLine("Диаграмма для данных, полученных в результате расчёта статистического метода");
break;
};
int avable = 0;
int vivsible = 0;
List<string> series = new List<string>();
foreach (WbkChartSerie ser in lanerCh.series)
{
if (ser.available.Value) { avable++; series.Add(ser.type.ToString()); };
if (ser.visible.Value) { vivsible++; };
};
Console.WriteLine("Общее количество рядов, доступных для отображения: " + vivsible);
Console.WriteLine("Из них в текущей диаграмме доступны:");
foreach (string s in series) { Console.WriteLine("".PadRight(3) + s); }
Console.WriteLine("".PadRight(3) + "Итого рядов: " + avable);
return gRes;
}
// Функция сохранения диаграммы в файл
public static bool chartSave(byte[] chart, string name)
{
if (chart.Length !=0)
{
MemoryStream fs = new MemoryStream(chart);
Bitmap img = new Bitmap(fs);
img.Save(name);
img.Dispose(); fs.Dispose();
return true;
}
else { return false; };
}
См. также: