dxDataGrid - The "We found a problem with some content in 'Document.xlsx'. Do you want us to try to recover as much as we can?" error occurs in the exported document when exporting large data

Hi,
Another approach is to call exportDataGrid instead of the default export. exportDataGrid uses ExcelJS. ExcelJS converts 0x0007/0x000b symbols (invalid XML symbols) to ' ' (space, 0x20) and encodes xml symbols like '<'/'>' to </>
To cancel the default export, use onExporting and turn on cancel:

JavaScript
onExporting: e => {  
  var workbook = new ExcelJS.Workbook();  
  var worksheet = workbook.addWorksheet('Main sheet');  
  /*  
    The 'DevExpress.excelExporter.exportDataGrid' function uses the ExcelJS library.  
    For more information about ExcelJS, see:  
      - https://github.com/exceljs/exceljs#contents  
      - https://github.com/exceljs/exceljs#browser  
  */  
  DevExpress.excelExporter.exportDataGrid({  
    component: e.component,  
    worksheet: worksheet,  
  }).then(function() {  
    workbook.xlsx.writeBuffer().then(function(buffer) {  
      saveAs(new Blob([buffer], { type: "application/octet-stream" }), "DataGrid.xlsx");  
    });  
  });  
  e.cancel = true;  
},  

Here is a jQuery based sample that illustrates this approach.

Hi,

Having thoroughly examined this issue, we concluded that it is caused by the incorrect characters ("\u001e\u001f") in the underlying data source:

JavaScript
"short_description": "\u001e\u001fDTS241-150: Secure Comms with Type 1B and 2B NB radios fails",  

These are special control characters and Excel does not treat them as valid.

Either remove these characters from the underlying datasource or in the customizeExportData callback function.

See also:

• T668759 - DataGrid - Unable to export tabulation symbols to Excel

Thanks,
Alessandro