09-29-2022 6:27 AM
Hello Experts,
I use cl_salv_table=>factory. It has a button ‘Export’.
The scenario is:
Run the program
1. Press the button ‘Export’.
2. Press ‘spreadsheet’
3. Choose a file
4. An error is displayed:
1. Press yes
2. An error is displayed:
Removed Part: /xl/sharedStrings.xml part with XML error. (Strings) Illegal xml character. Line 3, column 141703.
Removed Records: Cell information from /xl/worksheets/sheet1.xml part
There is not a column number 141703.
My question is how can I debug the code when I press ‘Export’ ‘Spreadsheet’?
Thank you in advance
Hagit
09-29-2022 10:28 AM
Did you find the relevant KBA 2616421 - How to determine and correct illegal XML character error?
09-29-2022 8:09 AM
You don't need to debug if it's standard -> check SAP notes, contact SAP support.
09-29-2022 10:28 AM
Did you find the relevant KBA 2616421 - How to determine and correct illegal XML character error?
09-29-2022 10:58 AM
raymond.giuseppi Thankyou for your answer.
In the above link it is written:
Open it, with an editor, which can show the position of the characters.
Do you know which editor can open xml file and show the position?
Thanks
Hagit
09-29-2022 3:00 PM
Try Notepad++ (column is displayed in status bar, you can navigate to column with Ctrl+G)
10-02-2022 5:52 PM
raymond.giuseppi Thank you for your answer.
The problem is that the excel, which is generated, does not contain the problematic char.
The excel is empty except for the numeric values. The xml file (as mention in the link) is also empty except for the numeric values.
Thanks, Hagit
10-03-2022 10:07 AM
10-03-2022 12:01 PM
11-09-2022 7:18 AM
raymond.giuseppi Thank you for directing me to the note.
It helps to understand that ‘is not ABAP related, but a known limitation in XML.’
Hagit
10-03-2022 12:10 PM
Hi hagit ,
If you just asking in general how to debug, then please save this file debug-sap.txt (take a look what's inside as well), and just drag and drop it over your app. After next click, it will bring a debugger. It works also over modal dialog screens (pop-up), when SAP's main command box is unavailable.
Btw, if you have access to SAP's command box (no modal dialog boxes are shown - pop-ups), then just type "/h" and hit enter. On next PAI event you'll get in a debug mode.
Regards,
Nemanja
10-06-2022 6:56 AM
nemanaj.simovic Thanks for your answer but my question was not in general debugging