topic Move internal table to excel in Application Development and Automation Discussions

Move internal table to excel

Former Member — Thu, 20 Mar 2008 14:22:41 GMT

Hi,

I wont to now how i move data from internal table to Excel?

there is simple way to do it?

Regards

Re: Move internal table to excel

rahulkavuri — Thu, 20 Mar 2008 14:27:57 GMT

Use GUI_DOWNLOAD.. tab seperator as X

Many sample codes for the above FM in SDN.. search for a sample

Re: Move internal table to excel

Former Member — Thu, 20 Mar 2008 14:31:31 GMT

Use this FM:

GUI_DOWNLOAD

Re: Move internal table to excel

Former Member — Thu, 20 Mar 2008 16:40:55 GMT

Hi,

Using GUI_download u can download into excel format

call method cl_gui_frontend_services=>gui_download

exporting

filename = 'C:/test1.xls'

write_field_separator = 'X'

changing

data_tab = it_excel.

Hope this is helpful.

Plz reward points if helpful.

Thanks.

Re: Move internal table to excel

Former Member — Thu, 20 Mar 2008 16:47:49 GMT

Try with this FM SAP_CONVERT_TO_XLS_FORMAT

Re: Move internal table to excel

Former Member — Thu, 20 Mar 2008 16:58:30 GMT

hi use this...

&----

*& Report ZTESTPROG003

&----

REPORT ZTESTPROG003.

TYPES:

BEGIN OF ty_upload,

matnr like mara-matnr,

meins like mara-meins,

mtart like mara-mtart,

mbrsh like mara-mbrsh,

END OF ty_upload.

DATA it_upload TYPE STANDARD TABLE OF ty_upload WITH header line.

DATA wa_upload TYPE ty_upload.

DATA: itab TYPE STANDARD TABLE OF alsmex_tabline WITH header line.

DATA itab TYPE STANDARD TABLE OF ty_upload WITH header line.

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = 'C:\Documents and Settings\venkatapp\Desktop\venkat.xls'

i_begin_col = 1

i_begin_row = 1

i_end_col = 4

i_end_row = 65535

TABLES

intern = itab.

if not itab[] is initial.

loop at itab .

case itab-col.

when '0001'.

it_upload-matnr = itab-value.

when '0002'.

it_upload-meins = itab-value.

when '0003'.

it_upload-mtart = itab-value.

when '0004'.

it_upload-mbrsh = itab-value.

append it_upload.

clear it_upload.

clear itab.

endcase.

endloop.

endif.

regards,

venkat.