PasteSpecial
Pastes the Range object to the specified range using the special paste options.
Syntax
expression.PasteSpecial(sPasteType, sPasteSpecialOperation, bSkipBlanks, bTranspose);
expression - A variable that represents a ApiRange class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| sPasteType | Optional | PasteType | "xlPasteAll" | Paste option. |
| sPasteSpecialOperation | Optional | PasteSpecialOperation | "xlPasteSpecialOperationNone" | The mathematical operation which will be applied to the copied data. |
| bSkipBlanks | Required | boolean | [bSkipBlanks=false] - Specifies whether to avoid replacing values in the paste area when blank cells occur in the copy area. | |
| bTranspose | Required | boolean | [bTranspose=false] - Specifies whether the pasted data will be transposed from rows to columns. |
Returns
This method doesn't return any data.
Example
This example pastes data from clipboard(if it possible) with options.
- Code
- Result
let worksheet = Api.GetActiveSheet();
let range = worksheet.GetRange("A1");
range.SetValue("test");
worksheet.GetRange("A1").Copy();
worksheet.GetRange("B1").PasteSpecial("xlPasteAll", "xlPasteSpecialOperationNone", false, false);