topic Re: Arabic Text problem in Excel in Application Development and Automation Discussions

Arabic Text problem in Excel

pavanm592 — Thu, 06 Mar 2014 13:16:44 GMT

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

Re: Arabic Text problem in Excel

Former Member — Thu, 06 Mar 2014 14:13:07 GMT

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

Re: Arabic Text problem in Excel

Former Member — Thu, 06 Mar 2014 15:02:20 GMT

This message was moderated.

Re: Arabic Text problem in Excel

Former Member — Thu, 06 Mar 2014 15:22:01 GMT

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

Re: Arabic Text problem in Excel

pavanm592 — Sun, 09 Mar 2014 06:06:08 GMT

Hi Kushi,

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

Thanks

Pavan

Re: Arabic Text problem in Excel

pavanm592 — Sun, 09 Mar 2014 06:09:40 GMT

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

Re: Arabic Text problem in Excel

Aiolos — Sun, 09 Mar 2014 07:49:32 GMT

Hi Pavan,

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

Re: Arabic Text problem in Excel

ThangaPrakash — Sun, 09 Mar 2014 17:17:18 GMT

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

Re: Arabic Text problem in Excel

ThangaPrakash — Sun, 09 Mar 2014 17:21:42 GMT

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

Re: Arabic Text problem in Excel

Former Member — Sun, 09 Mar 2014 17:28:44 GMT

I am repeating my 3 days old reply.


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

Re: Arabic Text problem in Excel

former_member226419 — Sun, 09 Mar 2014 20:24:50 GMT

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.

Sumeet

Re: Arabic Text problem in Excel

pavanm592 — Tue, 11 Mar 2014 11:10:28 GMT

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

Re: Arabic Text problem in Excel

ThangaPrakash — Tue, 11 Mar 2014 12:45:28 GMT

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

Regards,

Re: Arabic Text problem in Excel

Former Member — Thu, 03 Apr 2014 10:26:39 GMT

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