Special character in grouped data header is not exported correctly

Please excuse me for sending the wrong information.

In the context of excel export, the data that will be exported will be the data from the data items as is, which means that if you are storing the & symbol as "&", that`s what will be added to the exported file. With that in mind, you can replace "&" in the string value before passing the data. 

If further assistance is needed, please isolate the issue is stackblitz, so we can test and debug it locally.

Hello Krishna,

Thank you for creating an example demonstrating the issue.

After long debugging and going through the source code I have noticed that the issue is with compiling of the templates, which encodes special characters. I will have to discuss this further with the developers team, but for now you can try the following workaround, where the cells value is manually changed before saving:

• https://stackblitz.com/edit/react-ugsqbb-lzxubd?file=app/main.jsx

  const save = (component) => {
    const options = component.current.workbookOptions();
    const rows = options.sheets[0].rows;
    let altIdx = 0;
    rows.forEach((row) => {
      if (row.type === 'group-header') {
        row.cells.forEach((cell) => {
          var elem = document.createElement('textarea');
          elem.innerHTML = cell.value;
          cell.value = elem.value;
        });
      }
    });
    component.current.save(options);
  };

  const excelExport = () => {
    if (_exporter.current) {
      save(_exporter);
    }
  };