Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Mon Apr 14, 2025 1:40 pm

I need to add filters to my pivot table.

In this image "Screenshot 2025-04-14 153323.png" was created manually.
This image "Screenshot 2025-04-14 153432.png" was created with Python code, but I don't understand how to add filters in the code

I find in the library, this class "PivotReportFilter" but the documentation " e-iceblue .com /api_documents/6760f5367af9b5-90143928/res/html/PivotReportFilter.html#module-PivotReportFilter" is empty

I need it

HELP ME, please
Attachments
Screenshot 2025-04-14 153432.png
Screenshot 2025-04-14 153432.png (4.88 KiB) Viewed 31 times
Screenshot 2025-04-14 153323.png
Screenshot 2025-04-14 153323.png (5.4 KiB) Viewed 31 times

acpython
 
Posts: 1
Joined: Mon Apr 14, 2025 1:23 pm

Tue Apr 15, 2025 10:25 am

Hello,

Thanks for your inquiry.
Sorry, our Spire.Xls for Python does not support creating PivotReportFilter at present. I have added it as a new feature to our update list. Once it is implemented, I will inform you as soon as possible.

Sincerely,
William
E-iceblue support team
User avatar

William.Zhang
 
Posts: 767
Joined: Mon Dec 27, 2021 2:23 am

Mon Jun 02, 2025 9:26 am

William.Zhang wrote:Hello,

Thanks for your inquiry.
Sorry, our Spire.Xls for Python does not support creating PivotReportFilter at present. I have added it as a new feature to our update list. Once it is implemented, I will inform you as soon as possible.

Sincerely,
William
E-iceblue support team


Your website shows an example of creating a PivotReportFilter (yourwebsitename/Tutorials/Python/Spire.XLS-for-Python/Program-Guide/Pivot-Table/How-to-Filter-Excel-Pivot-Tables-with-Python-Step-by-Step.html). I purchased this software because your website showed that it had such features. I cannot make the code example shown work. Can you help?

freesoup
 
Posts: 1
Joined: Wed Apr 23, 2025 11:28 am

Tue Jun 03, 2025 9:25 am

Hello,

Thanks for your message.
Our internal version already supports this feature, but the official version has not yet been released. We have uploaded the tutorial for this feature on the website in advance. Once the official version containing this feature is available, we will notify you as soon as possible. Thank you for your understanding.

Sincerely,
William
E-iceblue support team
User avatar

William.Zhang
 
Posts: 767
Joined: Mon Dec 27, 2021 2:23 am

Thu Aug 14, 2025 2:19 am

Hello,

Thanks for your inquiry.
Please be informed that our latest release of Spire.XLS for Python Version: 15.7.1 supports filtering Pivot Tables. Please update and test.
WebSite Link:https://www.e-iceblue.com/Download/Spire-XLS-Python.html

Sincerely,
William
E-iceblue support team
User avatar

William.Zhang
 
Posts: 767
Joined: Mon Dec 27, 2021 2:23 am

Return to Spire.XLS