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

[mattiacoccia]

Hi, I am looking for the same funcionality to be used in python. Is it available?
I could only find doc/reference for C#.

Thanks

[Lisa.Li]

Hello mattiacoccia,

Thank you for your inquiry. We apologize that this feature has not been included to our Python version yet. I have submitted a synchronization task with SPIREXLS-5687 to our tracking system, our Dev team will further implement it. Once the version is available, I will let you know as soon as possible.

Sincerely,
Lisa
E-iceblue support team

[Lisa.Li]

Hello,

Glad to inform you that our newly released Spire.XLS for Python Version:15.5.0 supported grouping PivotTables. Please use the latest version and refer to the following code for testing. If you have any other questions, just feel free to write back.

Code: Select all

        workbook = Workbook()
        workbook.LoadFromFile(inputFile)
        start = DateTime(2024, 3, 2, 0, 0, 0, 0)
        end = DateTime(2024, 11, 15, 0, 0, 0, 0)
        pivoTypes1 = list(PivotGroupByTypes)
        for i, cType in enumerate(pivoTypes1):
            if i!=0:
                worksheet = workbook.Worksheets[i]
                pt = worksheet.PivotTables[0]
                field = pt.ColumnFields[0]
                field.CreateGroup(start, end, [cType], 1)
                pt.CalculateData()
                pt.Cache.IsRefreshOnLoad = True
                pt.Dispose()
                worksheet.Dispose()
        workbook.SaveToFile(outputFile)
        workbook.Dispose()


Sincerely,
Lisa
E-iceblue support team