Move internal table to excel

[Former Member]

Hi,

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

there is simple way to do it?

Regards

[Former Member]

Hi,

Using GUI_download u can download into excel format

OR

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.

[rahulkavuri]

Use GUI_DOWNLOAD.. tab seperator as X

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

[Former Member]

Use this FM:

GUI_DOWNLOAD

[Former Member]

Hi,

Using GUI_download u can download into excel format

OR

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.

[Former Member]

Try with this FM SAP_CONVERT_TO_XLS_FORMAT

[Former Member]

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.