Aspose.Cells.GridWeb.Examples.CSharp.Miscellaneous.PivotTable.CreatePivotTable.InitData C# (CSharp) Метод

        private void InitData()
        {
            // Create path to xls file
            string path = (this.Master as Site).GetDataDir();

            // Set filename
            string fileName = path + "\\Miscellaneous\\PivotTable.xls";
            
            // Imports from a excel file.
            GridWeb1.ImportExcelFile(fileName);
            
            // 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;


            // Add sheet and get index
            GridWorksheet sheet = GridWeb1.WorkSheets.Add("PivotTable Report");
            GridCells cells = GridWeb1.WorkSheets[0].Cells;

            // Add Pivot Table
            int id = sheet.PivotTables.Add(sourceSheet, sourceRange, "A1", "PivotTable Report");

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


            //Clears all list box
            lbxFields.Items.Clear();
            lbxRowFields.Items.Clear();
            lbxColumnFields.Items.Clear();
            lbxDataFields.Items.Clear();

            //Adds PivotFields to lbxFields box.
            for (int i = 0; i < 6; i++)
            {
                lbxFields.Items.Add(new ListItem(cells[0, i].StringValue, cells[0, i].StringValue));
            }
        }