Arabic Text problem in Excel

[pavanm592]

Hi All,

I am downloading my data using GUI_DOWNLOAD FM into Excel ,

Here the issue is in excel the Arabic text is displayed as # ,

I have gone through the scn and worked on some suggestions given like to add code page

tab delimiter etc... but could get the desired output..

can anyone suggest me the way to get the Arabic text correct in Excel.

Thanks,

Pavan

[Former Member]

Insufficient information. You should rename the excel file to .txt and upload it here.

[Former Member]

This message was moderated.

[pavanm592]

Hi Kushi,

I have used CODEPAGE = '1100' and '8700' but it don't see any change in the output,

Thanks

Pavan

[Former Member]

Hi Pavan,

Could you please describe shortly about how ,where is the data being retrieved to the program?

whether you are performing any conversions?

what kind of encoding used ?

it would help me to understand and give you the useful inputs to achieve the desired output

Regards,

Prakash

[pavanm592]

Hi Prakash,

I have my data in internal table where one of the field contains some long text in which there is some

Arabic words,

the problem is i am not using any conversions but those Arabic texts in that field are displayed as # in Excel.

Thanks

Pavan

[Aiolos]

Hi Pavan,

please check the upload/download code setting in sap front end.

[ThangaPrakash]

Hello Pavan,

Use the function module "NLS_GET_FRONTEND_CP" to find the correct code page based on the language, pass the code page determined from this function module to the GUI_DOWNLOAD.

Regards,

Thanga

[ThangaPrakash]

Try to download the file in different extension .txt, there might be problem in your local system,

the excel software installed in your system is not arabic compatible, if so install arabic language add on in your system and try again.

Regards,

Thanga

[Former Member]

I am repeating my 3 days old reply.

Insufficient information. You should rename the excel file to .txt and upload it here.

[pavanm592]

Hi Manish,

my requirement is to download the table data to Excel not in Text format, for that i used GUI_DOWNLOAD, in the table i have a string field where it contains some Arabic words the main problem is those words are printed as #.

Thanks

Pavan

[former_member226419]

Hi,

Put your file on application server and then use FM 'NLS_GET_FRONTEND_CP' to find the correct code page based on the language, pass the code page determined from this function module to the GUI_DOWNLOAD.

BR

Sumeet

[ThangaPrakash]

Have you enabled Unicode check in the attributes of your program ??

Regards,

TP

[Former Member]

Is this necessary to download in only excel.. ? Recently when we download the Arabic text to text file or Excel.. it used to download reversed string of Arabic text.

As a alternative.. I would suggest you to create a spool and then download the result into PDF.using RSTXPDFT4.

Thanks,

Rajesh