Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Problm download excel from ALV

Former Member
0 Kudos

Hi Experts,

I am facing a problem when downloading data from alv into a excel file. all the datas written in english are coming correctly but the japaneese or other chars are replaced by '#'. I am using FM 'GUI_DOWNLOAD'. How can I solve the problem?

6 REPLIES 6

Former Member
0 Kudos

Hi Mini,

kindly explain your requirement, why you have output in combination of two languages.

if you are talking about individual runs, kindly give value to sy-langu of the resepective language.

if not solved , pls let me know.

Thanks,

Pavan

0 Kudos

I am downloading records from a hierarchical ALV.Now tghis ALV has a detail list with some values like material description 'AC3200 エベレストID 30ATM'.Now what is happening,when I am downloading this to excel,this value comes like 'AC3200 ######## 30ATM'.means replacing non eng characters.

0 Kudos

hi mini,

sorry for questioning you again, did you mentioned language key when you are fetching data from MAKT for description, useually we won't display another language inform in one language.

is u r report is displaying japanise output?

Thanks ,

Pavan

0 Kudos

The FM SAP_CONVERT_TO_XLS_FORMAT is not working properly.

Myt program has a o/p of non english char.

Thanks in advance.

0 Kudos

HI,

I solved it by myself just passing 'codepage' and 'write bom' parameters in the FM "GUI_DOWNLOAD".

Former Member
0 Kudos

Hi,

Try using this function Module: SAP_CONVERT_TO_XLS_FORMAT

If it still givin problem then may be u will hav to check the excel features.

Sometimes...when u copy paste values to excel..they hav to be reformatted using excel features.

Hope this helps you..

Best Regards,

Navin Fernandes.