Yet another "from database or internal table to Excel"

[harry_dietz]

Opened in Excel "As a read-only workbook"

And there is even another option where you can play around with called "Use the XML Source task pane"...


So here the coding for a very small program to read database table T005 and put it in an XML-file:
<p>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.</p>



And if you then open "table.xml" in Excel "as an XML list" it will show you the T005 really like in SE16:

Have fun

Harry