Spire.XSL Pivot table, managing page fields.

[sgrech]

Hi, I have created an excel template with a pivot table within a work sheet. With Spire.XLS, is it possible to filter through page fields within a pivot table?



Using Interop library I can add the page field within a pivot table and toggle as true or false which filter I would want to show.

Code: Select all

//(Interop code)
PivotTable pvt = xlWorkSheet.PivotTables("PivotByTest") as PivotTable;
PivotField pfTMonth = (PivotField)pvt.PivotFields("Month");
pfTMonth.Orientation = XlPivotFieldOrientation.xlPageField;

pfTMonth.EnableMultiplePageItems = true;
for (int i = 1; i <= pfTMonth.PivotItems().count; i++)
{
    if (pfTMonth.PivotItems(i).Value.ToLower() != "(blank)")
        pfTMonth.PivotItems(i).Visible = (pfTMonth.PivotItems(i).Value == DateTime.Now.ToString("MMMM"));
    else
        pfTMonth.PivotItems(i).Visible = false;
}


I know that the pagefield can be targeted by

Code: Select all

//(Spire.XLS code)
pvt.PageFields[0]


Is there a way to manipulate them as showing true or false?

[sweety1]

Hello,

Thanks for your inquiry.
Please refer to the below code:

Code: Select all

 Spire.Xls.Core.Spreadsheet.PivotTables.XlsPivotTable pivotTable = workbook.Worksheets["Pivot Table"].PivotTables[0] as Spire.Xls.Core.Spreadsheet.PivotTables.XlsPivotTable;         
            PivotReportFilter filter = new PivotReportFilter("Name", true);       
            pivotTable.ReportFilters.Add(filter);


Best Regards,
Sweety

E-iceblue support team

[sgrech]

Thanks for the code sample which is useful, but I would want to manipulate the items within a report filter. Eg, I would need to toggle one item as true while the other items within the report filter are set to false.

[sweety1]

Hello,

Thanks for your response.
Sorry that our product does't support this feature at this stage.

Best Regards,
Sweety

E-iceblue support team

[sgrech]

Would this feature be supported in the future?

An other question aside. Is Spire.XLS built from Open.XML platform?

[sweety1]

Hello,

Thanks for your reply.
Sorry that our product does't support this feature in the future.
I recommend you to use add and remove items to implement this function.
About the Open.XML platform, do you mean ods format?

Best Regards,
Sweety
E-iceblue support team

[sweety1]

Hello,

Has your issue been resolved?
Thanks for your response.

Best Regards,
Sweety

E-iceblue support team

[sgrech]

Hi, yes I manage to find a way to work on my problem. Thanks.

[sweety1]

Hello,

Thanks for yor feedback.
I am glad to hear that.
Please feel free to contact us, if you have any questions or needs. We are here for help.

Best Regards,
Sweety

E-iceblue support team