Get Free Trial

Export the pivot to excel and filled up the group values

Rommel Manalo asked on September 23, 2020

I want the exact layout to be exported to excel, but I want the empty values to have populated on excel.
The flat form is not an option, here because I need it to be an aggregated result.


2 answers

Milena Pechura Milena Pechura Flexmonster September 24, 2020

Thank you for writing to us and providing screenshots of desired component behavior.
To achieve the mentioned grid appearance, we suggest using customizeCell API call that allows the customizing of separate cells.
Please see the following code snippet for the reference:

var pivot = new Flexmonster({
container: "pivot-container",
componentFolder: "",
customizeCell: customizeCellFunction,
report: {
"dataSource": {
"data": getData()

function customizeCellFunction(cell, data) {
if (data && data.type == "header" && data.member && data.member.caption != 'All' && data.label == "") {
cell.text = "    " + data.member.caption;

Here is an example for illustration:
Also, we would like to mention that the grid will be exported to Excel with all specified customization.
Please let us know if any further questions arise.
Best regards,

Rommel Manalo September 24, 2020

Awesome! This is really what i want.

Please login or Register to Submit Answer