Skip to end of metadata
Go to start of metadata

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

CopyColumnWidth

A boolean value indicating whether or not to copy column width.

CopyComments

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.

CopyFormatting

A boolean value indicating whether or not to copy cell formatting. Cell formatting includes font, color, number formatting, fill color, fill pattern and borders.

CopyFormulas

A boolean value indicating whether or not to copy cell formulas.

CopyMergedCells

A boolean value indicating whether or not to copy merged cells.

CopyRowHeight

A boolean value indicating whether or not to copy row height.

CopyValues

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

CopyPasteType

A CopyPasteType value specifies the type of data that will be copied.
  • No labels