Excel Export

MarkusKlein — Mon, 15 May 2006 06:24:17 GMT

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?

Re: Excel Export

MarkusKlein — Mon, 15 May 2006 07:14:03 GMT

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

Re: Excel Export

MarkusKlein — Mon, 15 May 2006 08:26:14 GMT

Seems this document is going into more details

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

topic Re: Excel Export in Application Development and Automation Discussions

Excel Export

Re: Excel Export

Re: Excel Export