Enum ExcelRangeCopyOptionFlags

Copy options enum. Specify the flags that you want to exclude from the copy or if you want to transpose the output.

Namespace: OfficeOpenXml
Assembly: EPPlus.dll
Syntax
[Flags]
public enum ExcelRangeCopyOptionFlags

Fields

Name Description
ExcludeComments

Exclude comments from being copied.
ExcludeConditionalFormatting

Exclude conditional formatting from being copied.
ExcludeDataValidations

Exclude data validations from being copied.
ExcludeDrawings

Exclude drawings from being copied
ExcludeFormulas

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

Exclude hidden cells in the range.

Exclude hyperlinks from being copied.
ExcludeLocalCellPictures

Exclude and local cell pictures within the range.
ExcludeMergedCells

Exclude merged cells from being copied.
ExcludePivotTables

Exclude any pivot table within the range. EPPlus will only copy pivot tables within the same workbooks.
ExcludeStyles

Exclude styles from being copied.
ExcludeTables

Exclude any table within the range.
ExcludeThreadedComments

Exclude threaded comments from being copied.
ExcludeValues

Will exclude formulas and values from being copied
ExcludeWebPictures

Exclude any web pictures (i.e. added via the IMAGE function) within the range.
Fill

Fill range with repeated data. The desination ranges rows and columns needs to be a multiple of the source's ranges rows and columns.
Transpose

Transpose the copied data