Symptom
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.
Read more...
Environment
- SAP NetWeaver
- SAP Web Application Server for SAP S/4HANA all versions
- Web Dynpro for ABAP
Product
Keywords
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 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.