Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Excel Export

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?

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question