Start attached sample and click the button.
AsposeCellsPivot.zip (27.1 KB)
The code just loads an excel file with Aspose.Cells and saves it as “bin\Debug\net6.0-windows\result.xlsx”. Open this file, go to sheet 2, sele…...Worksheets[1].PivotTables[0].DataSource..."Person one": Worksheet sheet = wb.Worksheets[0]; for (int row...