1

Does anybody know the EPPlus equivalent of interop code:

pivotTable.DataPivotField.Orientation = Excel.XlPivotFieldOrientation.xlColumnField;

Which moves the values from the rows to the columns.

(Manually you'd set this in Excel by dragging the Values from the rows to the columns)

Jasper
  • 444
  • 3
  • 19

1 Answers1

1

The property is DataOnRows and it must be set to false.

pivotTable.DataOnRows = false;
Coxy
  • 8,844
  • 4
  • 39
  • 62