TabRangeCopyResult TabRangeCut(string mon, TabRangeCopyArg tArg)
mon. Moniker for working with table cell range.
tArg. Parameters for cutting cell range.
The TabRangeCut operation cuts cell range contents.
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.
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.
{
"TabRangeCut" :
{
"mon" : "S1!M!S!P1!Sheets!1!C0:D3",
"tArg" :
{
"type" : "1"
}
}
}
{
"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: