topic Re: Problem while exporting the data from a report to an excel file. in Application Development and Automation Discussions

Problem while exporting the data from a report to an excel file.

Former Member — Fri, 20 Jan 2012 09:17:16 GMT

Hi SAP guru's,

I have a problem while exporting the data from a report to an excel file.

The problem is that after exporting, the excel file seems to have some irrelevant characters....I am checking this using SOST transaction..

Required text (Russian):

Операции по счету

№ документа Тип документа № учетной записи Дата документа Валюта Сумма, вкл. НДС Срок оплаты Описание документа

Current Text :

? 5 @ 0 F 8 8 ? > A G 5 B C

! 4 > : C "" 8 ? 4 > : C ! C G 5 B = > 9 7 0 ? 8 A 8 0 B 0 4 > : C 0 ; N B 0 ! C < ! @ > : > ? ; 0 B K ? 8 A 0 = 8 5 4 > : C

Can you help me making configuration settings if any?

Regards,

Avinash Raju

Re: Problem while exporting the data from a report to an excel file.

andrs_sarcevic — Mon, 23 Jan 2012 21:53:10 GMT

Perhaps something to do with the text encoding?

Re: Problem while exporting the data from a report to an excel file.

Former Member — Tue, 24 Jan 2012 04:26:26 GMT

Hi,

Before exprting the text to excel sheet translate the russian language to english using transilator TCODE and export then in excel, then it will be displayed in correct format.

Regards,

Goutam Kolluru.

Re: Problem while exporting the data from a report to an excel file.

former_member214857 — Tue, 24 Jan 2012 10:39:59 GMT

Hi Avinash

To download such characteres you need to adjust code page to be used during export. You can review SAP note 73606 to identify which code page is required for this language

Best regards