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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Chinese characters in EXCEL

Former Member

‎12-12-2011 10:35 AM

0 Kudos

Hi Friends,

I am facing problem regarding EXCEL download with Chinese Language character. I am using following code to download internal table contains Chinese character on presentation server.

CALL METHOD cl_gui_frontend_services=>gui_download

EXPORTING

filename = lv_fullpath

write_field_separator = 'X'

filetype = 'ASC'

  • CODEPAGE = '8400'

fieldnames = lt_header

CHANGING

data_tab = <fs_gt_table>.

*<fs_gt_table>

But after download EXCEL shows # in place of Chinese characters. Please suggest solution on that.

Thanks

1 REPLY 1

Former Member

‎12-12-2011 10:45 AM

0 Kudos

Hi Friends

I solve my problem using below code.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = p_file

filetype = 'DAT' "tried ASC and not working as well

codepage = lv_char_cpage "8404 in this case tried 8400 and same result

replacement = '#'

write_field_separator = 'X'

TABLES

data_tab = i_data_cnvr "table content

fieldnames = i_data_head "table header