formatting when using gui_download

[Former Member]

Hi All,

I am using method gui_download to download data containing korean characters to .txt file. If i dont mentioned codepage in gui_download, korean characters appears as # but formatting is ok. When i mentioned codepages korean characters appear fine but some extra spaces get added and that is why column looks zigzag. Is there any other way to mention codepage. how to get proper formatting of the column.

My code is as foolowing:

CALL METHOD CL_GUI_FRONTEND_SERVICES=>GUI_DOWNLOAD

EXPORTING

• BIN_FILESIZE =

FILENAME = Zfilename

FILETYPE = 'ASC'

• APPEND = SPACE

WRITE_FIELD_SEPARATOR = 'X'

• HEADER = '00'

• TRUNC_TRAILING_BLANKS = SPACE

• WRITE_LF = 'X'

• COL_SELECT = SPACE

• COL_SELECT_MASK = SPACE

DAT_MODE = 'X'

• CONFIRM_OVERWRITE = SPACE

• NO_AUTH_CHECK = SPACE

CODEPAGE = '8500'

• IGNORE_CERR = ABAP_TRUE

• REPLACEMENT = '#'

• WRITE_BOM = SPACE

• TRUNC_TRAILING_BLANKS_EOL = 'X'

• WK1_N_FORMAT = SPACE

• WK1_N_SIZE = SPACE

• WK1_T_FORMAT = SPACE

• WK1_T_SIZE = SPACE

IMPORTING

FILELENGTH = LEN

CHANGING

DATA_TAB = downtab[]

EXCEPTIONS

FILE_WRITE_ERROR = 1

NO_BATCH = 2

GUI_REFUSE_FILETRANSFER = 3

INVALID_TYPE = 4

NO_AUTHORITY = 5

UNKNOWN_ERROR = 6

HEADER_NOT_ALLOWED = 7

SEPARATOR_NOT_ALLOWED = 8

FILESIZE_NOT_ALLOWED = 9

HEADER_TOO_LONG = 10

DP_ERROR_CREATE = 11

DP_ERROR_SEND = 12

DP_ERROR_WRITE = 13

UNKNOWN_DP_ERROR = 14

ACCESS_DENIED = 15

DP_OUT_OF_MEMORY = 16

DISK_FULL = 17

DP_TIMEOUT = 18

FILE_NOT_FOUND = 19

DATAPROVIDER_EXCEPTION = 20

CONTROL_FLUSH_ERROR = 21

NOT_SUPPORTED_BY_GUI = 22

ERROR_NO_GUI = 23

others = 24 .

Please reply.

Thanks

[Former Member]

Hi All,

I am using method gui_download to download data containing korean characters to .txt file. If i dont mentioned codepage in gui_download, korean characters appears as # but formatting is ok. When i mentioned codepages korean characters appear fine but some extra spaces get added and that is why column looks zigzag. Is there any other way to mention codepage. how to get proper formatting of the column.

My code is as foolowing:

CALL METHOD CL_GUI_FRONTEND_SERVICES=>GUI_DOWNLOAD

EXPORTING

• BIN_FILESIZE =

FILENAME = Zfilename

FILETYPE = 'ASC'

• APPEND = SPACE

WRITE_FIELD_SEPARATOR = 'X'

• HEADER = '00'

• TRUNC_TRAILING_BLANKS = SPACE

• WRITE_LF = 'X'

• COL_SELECT = SPACE

• COL_SELECT_MASK = SPACE

DAT_MODE = 'X'

• CONFIRM_OVERWRITE = SPACE

• NO_AUTH_CHECK = SPACE

CODEPAGE = '8500'

• IGNORE_CERR = ABAP_TRUE

• REPLACEMENT = '#'

• WRITE_BOM = SPACE

• TRUNC_TRAILING_BLANKS_EOL = 'X'

• WK1_N_FORMAT = SPACE

• WK1_N_SIZE = SPACE

• WK1_T_FORMAT = SPACE

• WK1_T_SIZE = SPACE

IMPORTING

FILELENGTH = LEN

CHANGING

DATA_TAB = downtab[]

EXCEPTIONS

FILE_WRITE_ERROR = 1

NO_BATCH = 2

GUI_REFUSE_FILETRANSFER = 3

INVALID_TYPE = 4

NO_AUTHORITY = 5

UNKNOWN_ERROR = 6

HEADER_NOT_ALLOWED = 7

SEPARATOR_NOT_ALLOWED = 8

FILESIZE_NOT_ALLOWED = 9

HEADER_TOO_LONG = 10

DP_ERROR_CREATE = 11

DP_ERROR_SEND = 12

DP_ERROR_WRITE = 13

UNKNOWN_DP_ERROR = 14

ACCESS_DENIED = 15

DP_OUT_OF_MEMORY = 16

DISK_FULL = 17

DP_TIMEOUT = 18

FILE_NOT_FOUND = 19

DATAPROVIDER_EXCEPTION = 20

CONTROL_FLUSH_ERROR = 21

NOT_SUPPORTED_BY_GUI = 22

ERROR_NO_GUI = 23

others = 24 .

Please reply.

Thanks

[Former Member]

Hi,

You may try passing REFERENCE TABLE & REFERNCE FIELD in the FIELDCATALOG of ALV, if its an ALV output.

Export to LOCAL file of ALV will then provide an excel file with proper alignment.

Best regards,

Prashant