SAP Knowledge Base Article - Preview

3476908 - Illegal XML characters causing excel export issues.

Symptom

Execute a line item report (FBL*N, FAGLL03), And export the displayed data to a excel using spreadsheet functionality,

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"

Which may be accompanied of other error pop ups such as "We found a problem with some content in '<filename>.XLS'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes."


Read more...

Environment

  • Financial Accounting (FI)
  • SAP R/3
  • SAP ERP Central Component
  • SAP ERP
  • SAP enhancement package for SAP ERP
  • SAP enhancement package for SAP ERP, version for SAP HANA
  • SAP S/4HANA

Product

SAP ERP 6.0 ; SAP S/4HANA 1709 ; SAP S/4HANA 1809 ; SAP S/4HANA 1909 ; SAP S/4HANA 2020 ; SAP S/4HANA 2021 ; SAP S/4HANA 2022

Keywords

FBL1N, FBL3N, FBL5N, FAGLL03, excel error, illegal characters, corrupted data, spreadsheet error, fi-gl-gl-d. , KBA , FI-GL-GL-D , Reporting/Analysis/Display , FI-GL-GL , Basic Functions , Problem

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.