Export all data including collapsed rows

Question

Hi,

I have ej2-angular-pivotview version - 19.4.55. Our Angular version is Angular 9.1.1.

below is a screenshot of a grid with over 80 locations, when the default export occurs only location A, B & C display all child rows, is it possible to set it up in a way that when you export, all data including all the collapsed rows is exported?. If not, is it possible to have a toggle/button that expands all rows.

is exported?. If not, is it possible to have a toggle/button that expands all rows.

AngelinFaithSheeba PaulvannanRajadurai · Answer

Hi Mark,Currently,
we don’t have support to export the pivot table as its own format to Excel
sheet. However, We have already logged your requirement as a feature task, and
it will be available in any one of our upcoming releases. You can track the
same in the following link,https://www.syncfusion.com/feedback/15634/support-to-export-excel-pivot-table-as-its-own-formatPlease
let us know if you have concerns.Regards,Angelin Faith Sheeba