topic Re: Problem with Excel Download in Application Development and Automation Discussions

Problem with Excel Download

Former Member — Mon, 15 Jun 2009 15:26:25 GMT

Hi everyone, i call the function GUI_DOWNLOAD to download an intern table into Excel format.

the problem is

a field for exemple tab1-f1 = '4.5', but after downloaded into excel, it turns out automatically into Date format. which shows. 04.May.(i used German office version).

by the way i define the intern table like

types: begin of ts_tval,

aubel(20),

posnr(20) ,

matnr(20) ,

vbeln(20) ,

posnr_re(20) ,

atinn(20) ,

atnam(20) ,

atkla(20) ,

atwrt(20) ,

atflv(20) ,

end of ts_tval,

data lt_tval type table of ts_tval.

then the field will be valued as:

lt_tval-atwrt = cawn-atwrt.

anyone can tell how to set the format of excel cells???

thanx a loooot!!!!!!

Re: Problem with Excel Download

Former Member — Mon, 15 Jun 2009 15:56:42 GMT

Hi ,

Keep the cursor on the cell of your excel sheet and right click , go to format cell , click the number tab and select the general category. I think it will solve your problem

Re: Problem with Excel Download

Former Member — Mon, 15 Jun 2009 16:15:25 GMT

hi, thanx for reply, but no

i tried,

if u correct it in excel, it will turn 04.Mai into 39937 because actually the value is already turned into 04.05.2009

so here is the programm i wrote

types: BEGIN OF t_interface ,

var1(4) TYPE c ,

END OF t_interface .

data t_tab type table of t_interface.

data wa_var type t_interface.

wa_var-var1 = '3.00'.

APPEND wa_var to t_tab.

wa_var-var1 = '4.5'.

APPEND wa_var to t_tab.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

BIN_FILESIZE =

filename = 'C:\temp\file_test.xls'

filetype = 'ASC'

TABLES

data_tab = t_tab

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

OTHERS = 22

Re: Problem with Excel Download

Former Member — Mon, 15 Jun 2009 16:36:20 GMT

Hi ,

Change file type as 'DAT' like -

CALL FUNCTION 'WS_DOWNLOAD'

EXPORTING

FILENAME = P_FILENM

FILETYPE = 'DAT'

Re: Problem with Excel Download

Former Member — Mon, 15 Jun 2009 16:37:12 GMT

USe GUI_DOWNLOAD not WS_DOWNLOAd

Re: Problem with Excel Download

Former Member — Tue, 16 Jun 2009 07:24:00 GMT

sorry, i tried data type = 'DAT', it doesnt work, Using GUI_DOWNLOAD, whether FILETYPE = 'DAT' or 'ASC', if it is opened in Excel, it shows 04.Mai instead of 4.5,

can anyone help???

Re: Problem with Excel Download

Former Member — Tue, 16 Jun 2009 08:17:50 GMT

Hi yunfan Wang ,

Just clik on the cell Right click -> format cells -> Number Tab - > Catergory: Number.

Try this it will be helpful

Regards,

Sunil kairam.

Re: Problem with Excel Download

Former Member — Tue, 16 Jun 2009 08:24:23 GMT

Sunil kairam

Thanx for ur reply

I have already tried this, as i said above, the '4.5' is changed automatically to date format, 04.05.2009, if i do what u said in Number Catelog-> Number, it will be 39973, not back to 4.5.

Re: Problem with Excel Download

kesavadas_thekkillath — Tue, 16 Jun 2009 08:26:37 GMT

try declaring tab1-f1 as character format

Re: Problem with Excel Download

Former Member — Tue, 16 Jun 2009 08:33:07 GMT

Hi,

Declare wa_var as shown below

data wa_var type t_interface-var1.

Regards,

sunil kairam.

Re: Problem with Excel Download

Former Member — Tue, 16 Jun 2009 09:13:14 GMT

Hi sunil kairam.

thanx,

but it will be syntax error if i define wa_var like u said.

by the way, i solved the problem in some other way,

i used CONCATENATE to add SPACE infront of the value 4.5 , then in German Excel , it will not be translated into Date format, but kept as 4.5.

anyway, thanx for the help, and all u guys.