topic Problem with function 'GUI_DOWNLOAD' with EXCEL in Application Development and Automation Discussions

Problem with function 'GUI_DOWNLOAD' with EXCEL

Former Member — Thu, 04 Aug 2011 14:43:01 GMT

Good Morning My Friends.

I'm having 02 problems, use 'GUI_DOWNLOAD' to EXCEL.

I will explain.

problem 01

I have a table with text fields, these fields accept special characters like (ã, ç & * é' ").

when I use this function characters lose their formatting and saw type (@%$#%#).

EX:

Value of the field before the download.

concetração

Field Value After Download

concetraÃ@Ä©Üo

problem 02

I want to format the text, I am sending to excel, I have a field that has 3000 characters.

I want to do a line break at 300 characters, the problem and I do not know what symbol to use to make this break.

EX:

Value of the field before the download.

aiming to attract, develop, # keep, reward, and # motivating

Field Value After Download

aiming to attract, develop,

keep, reward, and

motivate

Re: Problem with function 'GUI_DOWNLOAD' with EXCEL

Former Member — Thu, 04 Aug 2011 19:26:35 GMT

Hope you are passing the data in binary format for problem 1(you can use FM SCMS_TEXT_TO_BINARY for this). I am not sure if this will resolve your problem.

And can use new line character CL_ABAP_CHAR_UTILITIES=>cr_lf at places where you want new line in for windows front end.

Hope this helps.

Regards

Pawan

Re: Problem with function 'GUI_DOWNLOAD' with EXCEL

Former Member — Fri, 05 Aug 2011 12:46:40 GMT

1º Prob.

Call Function 'gui_download'

codepage = '1100'

2º Prob.

cl_abap_char_utilities=>newline