Table of Contents

Enum ExcelRangeCopyOptionFlags

Namespace
OfficeOpenXml
Assembly
EPPlus.dll

Flag enum, specify all flags that you want to exclude from the copy.

[Flags]
public enum ExcelRangeCopyOptionFlags

Fields

ExcludeComments = 8

Exclude comments from being copied.

ExcludeConditionalFormatting = 256

Exclude conditional formatting from being copied.

ExcludeDataValidations = 128

Exclude data validations from being copied.

ExcludeDrawings = 1024

Exclude drawings from being copied

ExcludeFormulas = 1

Exclude formulas from being copied. Only the value of the cell will be copied

Exclude hyperlinks from being copied.

ExcludeMergedCells = 64

Exclude merged cells from being copied.

ExcludeStyles = 4

Exclude styles from being copied.

ExcludeThreadedComments = 16

Exclude threaded comments from being copied.

ExcludeValues = 2

Will exclude formulas and values from being copied

Transpose = 512

Transpose the copied data