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


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, � , KBA , BC-SRV-ALV , SAP List Viewer , BC-WD-CMP-ALV-ABA , Web Dynpro 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 ONE Support launchpad (Login required).

Search for additional results

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