uploading data into & from excel sheet

[Former Member]

i hav data in 5 internal tabels i want the data into one excel sheet

each internal table in differnt tabs in that sheet

plz help its urgent

helpfull answers will be rewarded

[Former Member]

Check withl this FM : EXCEL_OLE_STANDARD_DAT

DATA_SHEET_NAME -> give diffrent names for each internal table and use file name as same name for all internal tables

Thanks

Seshu

[Former Member]

use gui_download FM 5 times.

first time dont specify the append.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = 'C:\test.XLS'

filetype = 'ASC'

write_field_separator = '#'

TABLES

data_tab = itab1.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = 'C:\test.XLS'

write_field_separator = '#'

<b> append = 'X'</b>

TABLES

data_tab = itab2.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = 'C:\test.XLS'

write_field_separator = '#'

<b> append = 'X'</b>

TABLES

data_tab = itab3

similarly call for 4th & 5th itab