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.

Wed May 24, 2017 6:57 pm

Is there a way in Spire to do grouping inside a pivot table. Grouping inside a pivot table is possible in Excel, but I can't seem to find how to do it in Spire. I found an enumeration, PivotFieldGroupType, but nothing else so far.

Excel Pivot Table Grouping:
Image
Attachments
pivotGrouping.png
pivotGrouping.png (17.11 KiB) Viewed 4302 times

greyw49103ads
 
Posts: 1
Joined: Wed May 24, 2017 5:14 pm

Thu May 25, 2017 3:45 am

Dear greyw49103ads,

Thanks for your inquiry.
We are investigating this issue, once there is any progress, we will let you know.

Thanks,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Tue May 30, 2017 7:36 am

Dear greyw49103ads,

Sorry for late reply.
We have added the new feature into our schedule, and will inform you when it is finished.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Tue Mar 24, 2020 10:58 am

Hello,

I have the same problem. Did you solve it?

Thanks.,

dmaciasaviles
 
Posts: 6
Joined: Wed Oct 09, 2019 11:56 am

Wed Mar 25, 2020 2:59 am

Hi David,

Thanks for your inquiry.
Sorry this new feature is still under development. And at present there is no significant progress due to its complexity.
If there is any good news in the future, we will let you know.

Sincerely,
Rachel
E-iceblue support team
User avatar

rachel.lei
 
Posts: 1571
Joined: Tue Jul 09, 2019 2:22 am

Fri Jan 20, 2023 10:59 am

Hello,
Do you have any news about this feature ?

ab899799
 
Posts: 2
Joined: Mon Dec 12, 2022 11:13 am

Mon Jan 23, 2023 8:01 am

Hello,

Thanks for your inquiry.
We are now having our Spring Festival holiday from 21/01/2023 to 27/01/2023 (GMT+8:00), we cannot query the status of this function. Once we get back to the office on 28/01/2023, I will inform you of the completion of this function ASAP. Sorry for the inconvenience caused by us and we appreciate your understanding.

Sincerely,
Annika
E-iceblue support team
User avatar

Annika.Zhou
 
Posts: 1643
Joined: Wed Apr 07, 2021 2:50 am

Sat Jan 28, 2023 2:17 am

Hello ab899799,

Thank you for your patience.
I just checked the status of this new feature. Sorry this new feature is still under development. And at present there is no significant progress due to its complexity.
If there is any good news in the future, we will let you know.

Sincerely,
Annika
E-iceblue support team
User avatar

Annika.Zhou
 
Posts: 1643
Joined: Wed Apr 07, 2021 2:50 am

Tue Mar 19, 2024 9:46 am

Hello,

Thanks for your patience.
Glad to inform that we just released the latest Spire.XLS Pack(Hotfix) Version:14.3.3 which has implemented pivot table grouping function(SPIREXLS-765). Please update and refer to the following code snippet for testing.
Website link: https://www.e-iceblue.com/Download/down ... t-now.html
Nuget link: https://www.nuget.org/packages/Spire.XLS
Code: Select all
XlsPivotTable pt = worksheet.PivotTables[0] as XlsPivotTable;
IPivotField field = pt.RowFields[0];
DateTime start = new DateTime(2024, 5, 6);
DateTime end = new DateTime(2024, 10, 6);
PivotGroupByTypes[] types = new PivotGroupByTypes[]{ PivotGroupByTypes.Days };
field.CreateGroup(start, end, types, 1);

Sincerely,
William
E-iceblue support team
User avatar

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

Return to Spire.XLS