The 'Export to excel' function of an ALV grid creates a corrupt xlsx file, which cannot be opened by 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."
After clicking "Yes", there is another popup, which describes an illegal xml character:
- Web Dynpro for ABAP
- SAP NetWeaver
- SAP Web Application Server for SAP S/4HANA all versions
Web Dynpro; Webdynpro, 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 , KBA , BC-WD-CMP-ALV-ABA , Web Dynpro ALV for ABAP , BC-WD-ABA , Web Dynpro ABAP , BC-WD-ABA-REN , Web Dynpro ABAP Rendering , BC-WD-ABA-RUN , Web Dynpro ABAP Runtime , BC-WD-ABA-CFG , Configuration / Personalization , BC-WD-ABA-GEN , Web Dynpro ABAP Generation , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.