PivotTable not displaying properly as webpage

Aspose.Cells Product Family
1

I’m saving a PivotTable to be viewed on our Intranet site. Yesterday it was working fine with the drop-downs to select a date to view, etc.

I re-saved it today and now it displays as more of a spreadsheet rather than a pivot table. The drop-downs are gone, so you can no longer select a date.

When I saved it as a webpage, I selected “Add Interactivity” and Republish Sheet and clicked the “Publish” button. It gave me the option of spreadsheet or pivot table functionality. I chose pivot table functionality.

I really need the pivottable functionality of this.

Thanks.

2

Could you elaboration your case? Do you use Aspose.Excel?

3

I just figured it out a little while ago.

After I clicked the publish button, at the top is a window to select entire table or pivot table.

I must have selected entire table.

Thanks for your help though.

:slight_smile:

4

@skwilliams,
Aspose.Excel is discontinued and replaced with a latest alternate product Aspose.Cells. This new product not only supports the legacy features of Aspose.Excel but it also supports all the latest features available in different versions of MS Excel. Pivot table is also supported by Aspose.Cells as demonstrated below:

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Obtaining the reference of the newly added worksheet
Worksheet sheet = workbook.Worksheets[0];

Cells cells = sheet.Cells;

// Setting the value to the cells
Cell cell = cells["A1"];
cell.PutValue("Sport");
cell = cells["B1"];
cell.PutValue("Quarter");
cell = cells["C1"];
cell.PutValue("Sales");

cell = cells["A2"];
cell.PutValue("Golf");
cell = cells["A3"];
cell.PutValue("Golf");
cell = cells["A4"];
cell.PutValue("Tennis");
cell = cells["A5"];
cell.PutValue("Tennis");
cell = cells["A6"];
cell.PutValue("Tennis");
cell = cells["A7"];
cell.PutValue("Tennis");
cell = cells["A8"];
cell.PutValue("Golf");

cell = cells["B2"];
cell.PutValue("Qtr3");
cell = cells["B3"];
cell.PutValue("Qtr4");
cell = cells["B4"];
cell.PutValue("Qtr3");
cell = cells["B5"];
cell.PutValue("Qtr4");
cell = cells["B6"];
cell.PutValue("Qtr3");
cell = cells["B7"];
cell.PutValue("Qtr4");
cell = cells["B8"];
cell.PutValue("Qtr3");

cell = cells["C2"];
cell.PutValue(1500);
cell = cells["C3"];
cell.PutValue(2000);
cell = cells["C4"];
cell.PutValue(600);
cell = cells["C5"];
cell.PutValue(1500);
cell = cells["C6"];
cell.PutValue(4070);
cell = cells["C7"];
cell.PutValue(5000);
cell = cells["C8"];
cell.PutValue(6430);

Aspose.Cells.Pivot.PivotTableCollection pivotTables = sheet.PivotTables;

// Adding a PivotTable to the worksheet
int index = pivotTables.Add("=A1:C8", "E3", "PivotTable2");

// Accessing the instance of the newly added PivotTable
Aspose.Cells.Pivot.PivotTable pivotTable = pivotTables[index];

// Unshowing grand totals for rows.
pivotTable.RowGrand = false;

// Draging the first field to the row area.
pivotTable.AddFieldToArea(Aspose.Cells.Pivot.PivotFieldType.Row, 0);

// Draging the second field to the column area.
pivotTable.AddFieldToArea(Aspose.Cells.Pivot.PivotFieldType.Column, 1);

// Draging the third field to the data area.
pivotTable.AddFieldToArea(Aspose.Cells.Pivot.PivotFieldType.Data, 2);
         
// Saving the Excel file
workbook.Save(dataDir + "pivotTable_test_out.xls");

You may visit the following link to get the list of features which are supported for Pivot Tables:
Pivot Tables

Here you will find the download link to the latest version of this product:
Aspose.Cells for .NET (Latest Version)

For a quick review of this product a runnable solution is available here for testing all the exciting features of this product.