Enum ExcelRangeCopyOptionFlags¶
Namespace: OfficeOpenXml
Assembly: EPPlus.dll
Copy options enum. Specify the flags that you want to exclude from the copy or if you want to transpose the output.
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
ExcludeTables = 2048
Exclude any table within the range.
ExcludePivotTables = 4096
Exclude any pivot table within the range. EPPlus will only copy pivot tables within the same workbooks.
ExcludeHiddenCells = 8192
Exclude hidden cells in the range.
Fill = 16384
Fill range with repeated data. The desination ranges rows and columns needs to be a multiple of the source's ranges rows and columns.
ExcludeLocalCellPictures = 32768
Exclude and local cell pictures within the range.
ExcludeWebPictures = 65536
Exclude any web pictures (i.e. added via the IMAGE function) within the range.
IncludeFullColumn = 131072
Copy attributes of the column e.g. width of the column
IncludeFullRow = 262144
Copy attributes of the row e.g. height of the row