SAP Knowledge Base Article - Preview

2616421 - How to determine and correct illegal XML character error?

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"

symptom

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

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

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.