Table of Contents

Enum XLTransposeOptions

Namespace
SlapKit.Excel.Excel
Assembly
SlapKit.Excel.dll

A behavior of extra outside cells for transpose operation. The option is meaningful only for transposition of non-squared ranges, because squared ranges can always be transposed without effecting outside cells.

public enum XLTransposeOptions
Extension Methods

Fields

MoveCells = 0

Shift cells of the smaller side to its direction so there is a space to transpose other side (e.g. if A1:C5 range is transposed, move D1:XFD5 are moved 2 columns to the right).

ReplaceCells = 1

Data of the cells are replaced by the transposed cells.