GetTabRangeComment

Syntax

TabRangeComment GetTabRangeComment(string mon)

Parameters

mon. Moniker for working with table cell.

Description

The GetTabRangeComment operation gets a comment specified for a cell.

Comments

To execute the operation, in the mon field specify moniker for working with a cell in the following format: Regular report instance moniker!Sheets!Sheet key!absolute address. If the cell range moniker is specified, the operation is executed for the upper left cell in the range.

The operation results in the obtained cell comment.

Example

Below is the example of getting a cell comment. The request contains moniker for working with a cell. The response contains the obtained comment.

SOAP request:

<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">
<GetTabRangeComment xmlns="http://www.fsight.ru/PP.SOM.Som">
  <mon xmlns="">HBNCFAKEFPMNFOAEGJLELNECHEGOAOHEKJALPKOGKEBPFMNE!M!S!PKHDIGFKEFPMNFOAEDGNBAHBMBHMJKBNENLGGOOJBLJAKBOAO!Sheets!1!A1</mon>
  </GetTabRangeComment>
  </s:Body>
  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<GetTabRangeCommentResult 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">
  <trc xmlns="">Source data area</trc>
  </GetTabRangeCommentResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

{
"GetTabRangeComment" :
{
"mon" : "HBNCFAKEFPMNFOAEGJLELNECHEGOAOHEKJALPKOGKEBPFMNE!M!S!PKHDIGFKEFPMNFOAEDGNBAHBMBHMJKBNENLGGOOJBLJAKBOAO!Sheets!1!A1"
}
}

JSON response:

{
"GetTabRangeCommentResult" :
{
"trc" : "Source data area"
}
}
public static TabRangeComment GetTabRangeComment(string moniker, string sheetKey, string address)
{
var somClient = new SomPortTypeClient(); // Proxy object for operation execution
// Operation execution parameters
var tTab = new GetTabRangeComment()
{
mon = moniker + "!Sheets!" + sheetKey + '!' + address
};
// Get cell comment
var result = somClient.GetTabRangeComment(tTab);
return result;
}

See also:

Table: Operations