Pivot Table Grouping

[greyw49103ads]

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:

[Betsy.jiang]

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

[Betsy.jiang]

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

[dmaciasaviles]

Hello,

I have the same problem. Did you solve it?

Thanks.,

[rachel.lei]

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

[ab899799]

Hello,
Do you have any news about this feature ?

[Annika.Zhou]

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

[Annika.Zhou]

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

[William.Zhang]

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