How to make PIVOT table in excel automation and how to drag fields into Layouts( value, sum, columns, filter)

excel

#1

like this.


#2

Hello!

Refer to this:

https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Pivot-Table-Create-Pivot-Table-in-Excel-with-C-/VB.NET.html

Hope It Helps :slight_smile:

Regards,