Transpose excel data

Apr 24, 2015 at 8:17 AM

Is it possible to transpose data on EPPLUS?

Actual Table Excel data:
Item Quantity Price
Shirt 145 500
Jeans 100 50

Transposed Excel data:
Item Shirt Jeans
Quantity 145 100
Price 500 50
Apr 25, 2015 at 6:27 AM

if you are asking if the TRANSPOSE function is implemented in the calc engine of EPPlus the answer is no. But you could achieve programatically if you write the transpose code yourself, accessing/modifying the spreadsheet via EPPlus.