Refresh

[Former Member]

I am exporting my output list to an Excel file.

But i want to over write into Excel every time i execute my report

with new MATNR.

Is there any FM available ?

Thanks,

Reddy.

[Former Member]

Hi,

If you are using GUI_DOWNLOAD FM, if you give the same file name, I think it'll automatically overwrite the contents whenever you call the FM.

Regards,

Aswin

[Former Member]

hi,

use FM GUI_DOWNLOAD

Check this therad for the same

Regards,

Santosh

[Former Member]

Reddy,

Will the below work for you..?

Give the same excel file name for the second execution. It will overwrite the existing detials...

Cheers,

Thomas

[Former Member]

hi,

use FM <b>GUI_DOWNLOAD</b>.

thanks,

priya.

[Former Member]

Hi,

GUI_dounload Fm will ask for user path

to save the data. Give same file path the

previous contents will be overwritten.

Regards,

Amole

[Former Member]

Hi,

if you give the same file name it will over write it.

are you using GUI_DOWNLOAD FM. if so try to check are you passing APPEND = ' ' or 'X' if it is X it will append, but if it is space then it will over write.

Regards

vijay

[Former Member]

Hi,

Use GUI_DOWNLOAD. it automatically overites the values.

keep the same file path & Name.

Eg:-

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = 'c:/abc.xls'

filetype = 'DAT'

write_field_separator = 'X'

codepage = '4103'

TABLES

data_tab = lit_head_data

EXCEPTIONS

file_write_error = 1

Mark Helpfull Answers

Regards