Aspose.Cells.GridWeb.Examples.CSharp.Miscellaneous.PivotTable.CreatePivotTableFromWorksheet.btnWorksheet_Click C# (CSharp) Method

        protected void btnWorksheet_Click(object sender, EventArgs e)
        {
            // Extract cells from source sheet
            GridWorksheet sourceSheet = GridWeb1.WorkSheets[0];
            Aspose.Cells.GridWeb.Data.GridCellArea sourceRange = new GridCellArea();
            sourceRange.StartRow = 0;
            sourceRange.StartColumn = 0;
            sourceRange.EndRow = 29;
            sourceRange.EndColumn = 5;

            GridWorksheet sheet = GridWeb1.WorkSheets["From WebWorksheet"];

            if (sheet == null)
            {
                // Add worksheet
                sheet = GridWeb1.WorkSheets.Add("From WebWorksheet");

                GridCells cells = GridWeb1.WorkSheets[0].Cells;
                
                // Add pivot table
                int id = sheet.PivotTables.Add(sourceSheet, sourceRange, "A1", "Form WebWorksheet");
                GridPivotTable pivotTable = sheet.PivotTables[id];

                // Apply formatting
                GridWeb1.DefaultFontName = "Arial";
                GridWeb1.DefaultFontSize = new System.Web.UI.WebControls.FontUnit(10);

                pivotTable.AddFieldToArea(GridPivotFieldType.Row, 0);
                pivotTable.AddFieldToArea(GridPivotFieldType.Row, 2);
                pivotTable.AddFieldToArea(GridPivotFieldType.Column, 3);
                pivotTable.AddFieldToArea(GridPivotFieldType.Column, 4);
                pivotTable.AddFieldToArea(GridPivotFieldType.Data, 5);
                pivotTable.Fields(GridPivotFieldType.Data)[0].Function = GridPivotFieldFunction.Sum;

                // Paints PivotTable report
                pivotTable.CalculateData();
            }

            GridWeb1.ActiveSheetIndex = sheet.Index;
        }