REGARDING GUI_DOWNLOAD

[Former Member]

Hi,

i am using gui_download function module to down load data into excel

here i have field like matnr

FILE type is ASC

the output into excel is like 2E+13

can view the full field with out changing the excel setting

i.e direcly when user checks the excell it must be like 19999999.

regards,

siva

[Former Member]

Hi,

Just double click on that field or increase the width of the column by dragging it.You should be able to see the numeric value of Material.

Regards,

Lalit

[Former Member]

hi,

if the excel file is using reading it with some different format what i can suggest is u change the data type of that field before gui_download into some other format.

Reward points if helpful,

Regards,

Sumanjeet.

[Former Member]

Hi,

To which format i need to change

ie aas of now it was type c 18 length

but itried wih n too

but the same result occurs

regads,

siva

[Former Member]

Hi,

have you kept the separator as 'X'.

if not just try with this.

Regards,

Lalit

[Former Member]

Hi,

tried using seperator

regards,

siva

[Former Member]

Hi,

pls try out.

report ztest.

DATA: IT LIKE MARA OCCURS 0 WITH HEADER LINE.

DATA: FILENAME TYPE STRING.

SELECT * FROM MARA INTO TABLE IT.

filename = 'C:\Documents and Settings\sarunch1\Desktop\test.xls'.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

• BIN_FILESIZE = BIN_FILESIZE

FILENAME = FILENAME

FILETYPE = 'ASC'

• APPEND = ' '

WRITE_FIELD_SEPARATOR = 'X'

• HEADER = '00'

• TRUNC_TRAILING_BLANKS = ' '

• WRITE_LF = 'X'

• COL_SELECT = ' '

• COL_SELECT_MASK = ' '

• DAT_MODE = ' '

• CONFIRM_OVERWRITE = ' '

• NO_AUTH_CHECK = ' '

• CODEPAGE = ' '

• IGNORE_CERR = ABAP_TRUE

• REPLACEMENT = '#'

• WRITE_BOM = ' '

• TRUNC_TRAILING_BLANKS_EOL = 'X'

• WK1_N_FORMAT = ' '

• WK1_N_SIZE = ' '

• WK1_T_FORMAT = ' '

• WK1_T_SIZE = ' '

• WRITE_LF_AFTER_LAST_LINE = ABAP_TRUE

• SHOW_TRANSFER_STATUS = ABAP_TRUE

• IMPORTING

• FILELENGTH = FILELENGTH

TABLES

DATA_TAB = IT

• FIELDNAMES = FIELDNAMES

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

.

if sy-subrc = 0.