topic uploading data into & from excel sheet in Application Development and Automation Discussions

uploading data into & from excel sheet

Former Member — Fri, 22 Jun 2007 16:29:34 GMT

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

Re: uploading data into & from excel sheet

Former Member — Fri, 22 Jun 2007 16:38:43 GMT

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

Re: uploading data into & from excel sheet

Former Member — Fri, 22 Jun 2007 16:41:43 GMT

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