WorksheetCopyOptions Members
Allows you to define copy options when you copy data from one worksheet to another.Constructors
| Name | Description |
|---|---|
| WorksheetCopyOptions() | Initializes a new WorksheetCopyOptions class instance. |
Properties
| Name | Description |
|---|---|
| CopyDefinedNames | Specifies which defined names should be copied in case they contain references to non-existent worksheets. |
| InvalidFormulaReplacementMode | Specifies how to replace copied formulas if they contain references to worksheets that do not exist in the destination workbook. |
| OverwriteProtectionOnLockedWorksheet | Specifies whether to apply cell protection options of the source worksheet to cells in the protected destination worksheet. |
| PasteOptions | Specifies the part of data to paste from the copied worksheet into the target worksheet. |
| SheetMappings | Allows you to specify mappings between worksheet names in the source and destination workbooks. |
Methods
| Name | Description |
|---|---|
| Equals(Object, Object) static | Determines whether the specified object instances are considered equal. Inherited from Object. |
| Equals(Object) | Determines whether the specified object is equal to the current object. Inherited from Object. |
| GetHashCode() | Serves as the default hash function. Inherited from Object. |
| GetType() | Gets the Type of the current instance. Inherited from Object. |
| MemberwiseClone() protected | Creates a shallow copy of the current Object. Inherited from Object. |
| ReferenceEquals(Object, Object) static | Determines whether the specified Object instances are the same instance. Inherited from Object. |
| ToString() | Returns a string that represents the current object. Inherited from Object. |
See Also