Excel Export

[MarkusKlein]

Hello all,

im currently trying to get an excel export running using the interfaces i_oi_document_proxy and i_oi_spreadsheet

The question I have is, how can I open more than one sheet(tab) in Excel at a time?

call method control->get_document_proxy
    exporting
      document_type  = 'Excel.Sheet'
    importing
      document_proxy = document
      error          = error.

  if not document is initial.
    call method document->create_document
      exporting
        open_inplace = ''.

* Sheet 1
    call method document->get_spreadsheet_interface
      importing
        sheet_interface = sheet.

    call method sheet->insert_full

* Sheet 2
    call method document->get_spreadsheet_interface
      importing
        sheet_interface = sheet2.

    call method sheet2->insert_full

This way it doesn’t work. Still just one sheet gets opend.

Has anyone an idea?

[MarkusKlein]

The above logic is from FM 'XXL_FULL_API', which SAP uses with its ALV Export functionality.

[MarkusKlein]

Seems this document is going into more details

http://www.esnips.com/doc/741a848e-f49a-4436-bec4-e21950f6c94c/desktop-office-integration.pdf