publicclassPastry{publicPastry(stringname,intamount,stringmonth){Month=month;Name=name;NumberOfOrders=amount;}publicstringName{get;set;}publicintNumberOfOrders{get;set;}publicstringMonth{get;set;}}

varpastries=newList<Pastry>{newPastry("Croissant",150,"Apr"),newPastry("Croissant",250,"May"),newPastry("Croissant",134,"June"),newPastry("Doughnut",250,"Apr"),newPastry("Doughnut",225,"May"),newPastry("Doughnut",210,"June"),newPastry("Bearclaw",134,"Apr"),newPastry("Bearclaw",184,"May"),newPastry("Bearclaw",124,"June"),newPastry("Danish",394,"Apr"),newPastry("Danish",190,"May"),newPastry("Danish",221,"June"),newPastry("Scone",135,"Apr"),newPastry("Scone",122,"May"),newPastry("Scone",243,"June")};

varworkbook=newXLWorkbook();varsheet=workbook.Worksheets.Add("PastrySalesData");// Insert our list of pastry data into the "PastrySalesData" sheet at cell 1,1vartable=sheet.Cell(1,1).InsertTable(pastries,"PastrySalesData",true);

// Add a new sheet for our pivot tablevarptSheet=workbook.Worksheets.Add("PivotTable");// Create the pivot table, using the data from the "PastrySalesData" tablevarpt=ptSheet.PivotTables.Add("PivotTable",ptSheet.Cell(1,1),table.AsRange());// The rows in our pivot table will be the names of the pastriespt.RowLabels.Add("Name");// The columns will be the monthspt.ColumnLabels.Add("Month");// The values in our table will come from the "NumberOfOrders" field// The default calculation setting is a total of each row/columnpt.Values.Add("NumberOfOrders");