.
Description
The CopyPasteProperties object represents the types of data that will be copied from a worksheet when you call the CopyPaste() method.
C#
vb.net
Remarks
You can use the CopyPasteType enumeration to specify the type of data that will be copied. If you set CopyPasteType to None, then you must set individual properties on the CopyPasteProperties object before calling the CopyPaste() method.
To create a CopyPasteProperties object, call the CreateCopyPasteProperties() method on a Workbook object.
Examples
C#
vb.net
Properties
Name |
Description |
|---|---|
| A boolean value indicating whether or not to copy column width. | |
| A boolean value indicating whether or not to copy comments. If this value is set to true, then any comments attached to cells in the copy area will be copied. | |
| A boolean value indicating whether or not to copy cell formatting. Cell formatting includes font, color, number formatting, fill color, fill pattern and borders. | |
| A boolean value indicating whether or not to copy cell formulas. | |
| A boolean value indicating whether or not to copy merged cells. | |
| A boolean value indicating whether or not to copy row height. | |
| A boolean value indicating whether or not to copy cell values. If the CopyFormulas property is set to false, then the final value of any formulas will be copied. |
Nested Classes
Name |
Description |
|---|---|
| A CopyPasteType value specifies the type of data that will be copied. |