Pivot Tables with "groups" not read/written correctly and cause corruption of spreadsheet
Excel files with pivot tables that have "groups" are not read or written correctly and cause a spreadsheet to be corrupted.
I have attached a very simplified example of the issue. The attached code simply reads the attached example excel and then writes it to a new file, so presumably groups are not read correctly.
If you remove the group on column "x" the same python code executes as expected