Is it possible to export all the data of a pivot, even that not expanded
Thank you for the question.
Actually, you can expand all data before export and then collapse after it using API.
Please take a look at the following sample: https://jsfiddle.net/flexmonster/82xhLktm/
Hope it helps.