topic Re: Refresh in Application Development and Automation Discussions

Refresh

Former Member — Thu, 01 Jun 2006 09:49:28 GMT

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.

Re: Refresh

Former Member — Thu, 01 Jun 2006 09:52:03 GMT

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

Re: Refresh

Former Member — Thu, 01 Jun 2006 09:53:54 GMT

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

Re: Refresh

Former Member — Thu, 01 Jun 2006 09:53:58 GMT

hi,

use FM GUI_DOWNLOAD

Check this therad for the same

Regards,

Santosh

Re: Refresh

Former Member — Thu, 01 Jun 2006 09:58:14 GMT

hi,

use FM <b>GUI_DOWNLOAD</b>.

thanks,

priya.

Re: Refresh

Former Member — Thu, 01 Jun 2006 09:59:59 GMT

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

Re: Refresh

Former Member — Thu, 01 Jun 2006 10:00:01 GMT

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

Re: Refresh

Former Member — Thu, 01 Jun 2006 10:02:45 GMT

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