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…...//Replace "Person1" by "Person one": Worksheet sheet = wb.Worksheets[0];...Cells[row, 0].Value = "Person one"; } } wb.Worksheets[1].PivotTables[0]...