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¶

ExcludeFormulas = 1

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

ExcludeValues = 2

Will exclude formulas and values from being copied

ExcludeStyles = 4

Exclude styles from being copied.

ExcludeComments = 8

Exclude comments from being copied.

ExcludeThreadedComments = 16

Exclude threaded comments from being copied.

ExcludeHyperLinks = 32

Exclude hyperlinks from being copied.

ExcludeMergedCells = 64

Exclude merged cells from being copied.

ExcludeDataValidations = 128

Exclude data validations from being copied.

ExcludeConditionalFormatting = 256

Exclude conditional formatting from being copied.

Transpose = 512

Transpose the copied data

ExcludeDrawings = 1024

Exclude drawings from being copied