TabRangeCopy

Syntax

TabRangeCopyResult TabRangeCopy(string mon, TabRangeCopyArg tArg)

Parameters

mon. Moniker for working with table cell range.

tArg. Parameters for copying cell range.

Description

The TabRangeCopy operation copies cell range contents.

Comments

The operation copies text, formulas and cell range formatting. To execute the operation, in the mon field specify regular report instance moniker with the !Sheets!sheet key!range address postfix.

The operation results in the collection of single elements containing copied data. To paste, use the TabRangePaste operation.

Example

Below is the example of copying cell range contents. The request contains range moniker and the format of copied data. The response contains range contents as a byte stream.

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">
<TabRangeCopy xmlns="http://www.fsight.ru/PP.SOM.Som">
  <mon xmlns="">S1!M!S!P1!Sheets!1!C0:D3</mon>
<tArg xmlns="">
  <type>1</type>
  </tArg>
  </TabRangeCopy>
  </s:Body>
  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<TabRangeCopyResult 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">
<data xmlns="">
<it type="1">
  <data>egAAAAMAAAB4nNVV2w3CMAw8O33t0wFQB2AH+KmE1C8WoKMwSgdgIj6AhORKmgrxWWIpVWK7zl0udadhf4c1hTcThlsXiOyG0j47nHHCEYNzdQ0wvoM2NM6Laz+1bbuLB4vI0xq+mItdDnj4md9canV159ckdWjqMIlD4i2UHhFlQPKmRhomokYxM6b2UWepmpmnLvGf0XPEwhT+1O10y7NHih5r9BpAu6IO7DKDF0wTdcos1CE3TdSpyHdDdSr9pQ7PnB16rY4JANjHya8m6nzbAj9//qZIrQlUt5SuwEq6JOMF7LZ1uw==</data>
  </it>
  </data>
  </TabRangeCopyResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

{
 "TabRangeCopy" : 
  {
   "mon" : "S1!M!S!P1!Sheets!1!C0:D3",
   "tArg" : 
    {
     "type" : "1"
    }
  }
}

JSON response:

{
 "TabRangeCopyResult" : 
  {
   "data" : 
    {
     "it" : 
      {
       "@type" : "1",
       "data" : "egAAAAMAAAB4nNVV2w3CMAw8O33t0wFQB2AH+KmE1C8WoKMwSgdgIj6AhORKmgrxWWIpVWK7zl0udadhf4c1hTcThlsXiOyG0j47nHHCEYNzdQ0wvoM2NM6Laz+1bbuLB4vI0xq+mItdDnj4md9canV159ckdWjqMIlD4i2UHhFlQPKmRhomokYxM6b2UWepmpmnLvGf0XPEwhT+1O10y7NHih5r9BpAu6IO7DKDF0wTdcos1CE3TdSpyHdDdSr9pQ7PnB16rY4JANjHya8m6nzbAj9\/\/qZIrQlUt5SuwEq6JOMF7LZ1uw=="
      }
    }
  }
}
public static TabRangeCopyResult CopyTabRange(string moniker, string sheetKey, string address)
{
    var somClient = new SomPortTypeClient(); // Proxy object for operation execution
    // Operation execution parameters
    var tTab = new TabRangeCopy()
    {
        mon = moniker + "!Sheets!" + sheetKey + '!' + address,
        tArg = new TabRangeCopyArg()
        {
            type = 1
        }
    };
    // Copy cell range
    var result = somClient.TabRangeCopy(tTab);
    return result;
}

See also:

Table