exporting ALV to spreadsheet

[jp_2303]

Hi Experts 

I Have a ALV report when i export the output to spreadsheet  xlsx. format it showing an error but in xls.there is no issues.

[Sandra_Rossi]

If you are using standard SAP code, check the SAP notes which are valid for your SAP release.

[jp_2303]

Hi Sandra

Actually it's a standard program only mm60 and I have copied to zmm60 but still I face this issue.

[Sandra_Rossi]

Nowadays, NEVER copy standard code, do modifications of code if needed (e.g. implement enhancement options). It has been discussed recently these last months and last years. If MM60 fails, then check SAP notes or contact SAP Support.

[jp_2303]

Thanks for your reply I will check for the sap notes and revert you back

[jp_2303]

But in Quality client its working fine....problem in production client

@Sandra_Rossi 

[Sandra_Rossi]

Bugs usually depend on reproduction steps and on data. Data are different between quality and production. So check the SAP notes etc.

[jp_2303]

if i could not find any notes regarding the xlsx is there any way to achieve this..

[Sandra_Rossi]

As I already said, if SAP notes don't solve the standard bug of MM60 Excel export (if you confirm?), then contact the SAP Support. It's the only way to do it.

[ArunJacob]

Hi

yes data differs from client to client(QA, Prod etc.).

Special characters in the ALV report, could you please check for some special characters like(\x00, \x1F)?
This becomes the Illegal xml character(as mentioned in the error log).

In the custom(ZMM60), try to clean the report before displaying in ALV.

DATA(lv_value) = <field>.
REPLACE ALL OCCURRENCES OF REGEX '[^\x09\x0A\x0D\x20-\x7E]' IN lv_value WITH ''.

Thanks