SAP Knowledge Base Article - Preview

2517992 - WDA: Export to Excel creates a corrupt file

Symptom

  • The 'Export to excel' function of an ALV grid creates a corrupt .xlsx file that cannot be opened in Microsoft Excel.
  • The error message is the following: "We found a problem with some content in 'export.XLSX'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes."
    excel_error.PNG

  • After clicking "Yes" there is another popup that describes an illegal .xml character:
    repairs1.PNG

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

  • Web Dynpro for ABAP
  • SAP NetWeaver
  • SAP Web Application Server for SAP S/4HANA all versions
  • ABAP PLATFORM - Application Server ABAP

Product

ABAP platform all versions ; SAP NetWeaver all versions ; SAP Web Application Server for SAP S/4HANA all versions

Keywords

Web Dynpro, Webdynpro, WDA, WDA_GDPR, excel, export to excel, alv, corrupt, xml, illegal character, wrong character, misplaced character, popup, excel warning, try to open, not possible, XML, not opening, warning, popup, recover, workbook, trust , KBA , BC-WD-CMP-ALV-ABA , ALV for ABAP , BC-WD-ABA , Web Dynpro ABAP , BC-WD-ABA-REN , Rendering , BC-WD-ABA-RUN , Web Dynpro ABAP Runtime , BC-WD-ABA-CFG , Configuration / Personalization , BC-WD-ABA-GEN , Generation , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.