TabRangeCut

Syntax

TabRangeCopyResult TabRangeCut(string mon, TabRangeCopyArg tArg)

Parameters

mon. Moniker for working with table cell range.

tArg. Parameters for cutting cell range.

Description

The TabRangeCut operation cuts cell range contents.

Comments

The operation cuts 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 cut data. To paste, use the TabRangePaste operation.

Example

Below is the example of cutting cell range contents. The request contains range moniker and the format, in which cutting is executed. 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">
<TabRangeCut 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>
  </TabRangeCut>
  </s:Body>
  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<TabRangeCutResult 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>egAAAAMAAAB4nN2UzQ3CMAyFX5z0Z58OgDoAO8AFCaknFqBswigdgIk4AHFil5AKcSytJbeN7Sb++lQP3fYOb4RoVpzXDondUPhrixOO2KPjUFsDfUj6VD8uroehaZpN6rqJeXrDF+PceYdHfIqHm4p43/E1kwcoD9gsYNIjSCMXQybgSF/LxlNGm+DROvAUje+pelbwTCji4n8mUE8FckJQhKI5NUBOgCkBSeO8KTf7WaHTgzKVisWopHyUqVQKgZtZpZJ+qaTfXif3VCUrDeh8V8YKqxgVFu+fLJWwFrwg8YwSOkwkzCpegSZ7ww==</data>
  </it>
  </data>
  </TabRangeCutResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

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

JSON response:

{
"TabRangeCutResult" :
{
"data" :
{
"it" :
{
"@type" : "1",
"data" : "egAAAAMAAAB4nN2UzQ3CMAyFX5z0Z58OgDoAO8AFCaknFqBswigdgIk4AHFil5AKcSytJbeN7Sb++lQP3fYOb4RoVpzXDondUPhrixOO2KPjUFsDfUj6VD8uroehaZpN6rqJeXrDF+PceYdHfIqHm4p43\/E1kwcoD9gsYNIjSCMXQybgSF\/LxlNGm+DROvAUje+pelbwTCji4n8mUE8FckJQhKI5NUBOgCkBSeO8KTf7WaHTgzKVisWopHyUqVQKgZtZpZJ+qaTfXif3VCUrDeh8V8YKqxgVFu+fLJWwFrwg8YwSOkwkzCpegSZ7ww=="
}
}
}
}
public static TabRangeCopyResult CutTabRange(string moniker, string sheetKey, string address)
{
var somClient = new SomPortTypeClient(); // Proxy object for operation execution
// Operation execution parameters
var tTab = new TabRangeCut()
{
mon = moniker + "!Sheets!" + sheetKey + '!' + address,
tArg = new TabRangeCopyArg()
{
type = 1
}
};
// Cut cell range
var result = somClient.TabRangeCut(tTab);
return result;
}

See also:

Table