excel output

[Former Member]

Hi friends ,

can you please give me any example where i can output the data of a dynamic internal table to excel.That is when i press f8 this excel should be displayed with data from a dynamic internal tabel.

Thanks & regards,

Sunitha.p

[Former Member]

hi,

u follow this source code ............

DATA:  lt_t005 TYPE STANDARD TABLE OF t005.
TYPES:  xmlline(1024) TYPE x.
DATA:  lt_xml TYPE STANDARD TABLE OF xmlline.

SELECT * FROM t005 INTO TABLE lt_t005.

CALL TRANSFORMATION id
  SOURCE data_node = lt_t005
  RESULT XML lt_xml.

CALL METHOD cl_gui_frontend_services=>gui_download
  EXPORTING
    filename = 'C:table.xml'
    filetype = 'BIN'
  CHANGING
    data_tab = lt_xml.

we can also display the internal table data on EXCEL by using

function module <b>XXL_FULL_API.</b> The Excel sheet which is generated by this function module contains the column headings and the key ...

<b>follow this link also if u have any queries........</b>

https:///people/harry.dietz/blog/2005/11/11/yet-another-from-database-or-internal-table-to-excelhttp... [original link is broken]:///people/harry.dietz/blog/2005/11/11/yet-another-from-database-or-internal-table-to-excel

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/exportingdatatoExcel-XMLtotherescue&

regards,

AshokReddy.