Rank 1
Hello Team,
I hope your weak is going smoothly. I am reaching out to you because , I am facing problem to remove Row and Column header from pivot table view. Also, I dont want these fields to be downloaded in excel download as well. I am using kendo react pivot grid version:
"@progress/kendo-react-pivotgrid": "^5.9.0",
I have succesfully expanded all fields (defaultRowAxes and defaultColumnAxes) by defaut. So, I do not need this fields in my pivot table view and downloaded excel file. I am using built in saveAsExcel function to download excel file. I want to remove the fields highlighted in rectangle (check attached image) from downloaded excel file also. I am attaching the screenshot for better understanding.Your assistance in resolving this matter would be grately appreciated.
Thanks in advance
1 Answer, 1 is accepted
Hello Jaskaran,
As I have mentioned in the other thread that you have opened with the same request, it is not possible to remove the elements in question from the PivotGrid structure. As for the export to Excel, the implementation in the example in our documentation is using the columns/rows structure of the PivotGrid to generate the exported file, which means that if you want to customize it, you can change how the rows and the cells are generated in the "export-to-excel.js" file;
Regards,
Konstantin Dikov
Progress Telerik
Stay tuned by visiting our public roadmap and feedback portal pages! Or perhaps, if you are new to our Kendo family, check out our getting started resources!