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));
}
}