Export to excel is not working properly

Hello,

Thank you for reaching out to us.

Kindly note that this behavior occurs when using the customizeCell function. To display data correctly, we recommend setting the useCustomizeCellForData to false in the exportTo API call:

function exportToExcel() {
 pivot.exportTo('excel', {useCustomizeCellForData: false});
}

To add this functionality to the Toolbar, you can use the beforetoolbarcreated event:

new Flexmonster({
  container: "#pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  beforetoolbarcreated: customizeToolbar,
  // other properties
});

function customizeToolbar(toolbar) {
  let tabs = toolbar.getTabs();
  toolbar.getTabs = function() {
    let exportTab = tabs.find(tab => tab.id == "fm-tab-export");
    if (!exportTab) return tabs;
    let exportToPdfTab = exportTab.menu.find(tab => tab.id == "fm-tab-export-excel");
    exportToPdfTab.handler = exportToExcel;
    return tabs;
  }
}

More details on how to customize the Toolbar can be found in our documentation: https://www.flexmonster.com/doc/customizing-toolbar/. 
You are welcome to check the following example for reference: https://jsfiddle.net/flexmonster/cero148f/ 

Please let us know if it works for you. Looking forward to hearing from you.

Kind regards,
Nadia

Hello Jose,

Hope you are doing well.

We were wondering if you had a chance to check the suggested approach. Could you please confirm if it works for you?

Looking forward to hearing your feedback.

Kind regards,
Nadia

Hello Jose,

Thank you for the feedback.

We are glad to hear that it works for you.

As always, do not hesitate to contact us in case other questions arise.

Kind regards,
Nadia