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 similar to the following example:
"Removed Part: /xl/sharedStrings.xml part with XML error. (Strings) Illegal xml character. Line 1, column 393939.
Removed Records: Cell information from /xl/worksheets/sheet1.xml part"
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
- SAP NetWeaver
- SAP Web Application Server for SAP S/4HANA all versions
- Web Dynpro for ABAP
export to excel, alv, corrupt, XML, illegal character, wrong character, misplaced character, popup, excel error, try to open, not possible, not opening, warning, popup, removed part, /xl/sharedStrings.xml, exportieren, verdorben, falsch character, dialogfenster, warnung, Excel was able to open the file by repairing or removing the unreadable content. , Repairs to 'export.XLSX', ALVGrid, Gridview, ALV grid view, ALVgridview, � Removed Part: /xl/sharedStrings.xml part with XML error. (Strings) Illegal xml character; Removed Records: Cell information from /xl/worksheets/sheet1.xml part.
Line 1, column 670550. , KBA , xml error. (strings) illegal xml charact , BC-SRV-ALV , SAP List Viewer , BC-WD-CMP-ALV-ABA , ALV for ABAP , How To
About this pageThis 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.