05-15-2006 7:24 AM
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 doesnt work. Still just one sheet gets opend.
Has anyone an idea?
05-15-2006 8:14 AM
The above logic is from FM 'XXL_FULL_API', which SAP uses with its ALV Export functionality.
05-15-2006 9:26 AM
Seems this document is going into more details
http://www.esnips.com/doc/741a848e-f49a-4436-bec4-e21950f6c94c/desktop-office-integration.pdf