Desktop Office Integration in SAP GUI for HTML - dont works?

[Former Member]

Hello all,

my program reads an Excel-File with multiple Worksheets into SAP by using class:

CL_GUI_CUSTOM_CONTAINER

and intefaces:

I_OI_CONTAINER_CONTROL,
I_OI_DOCUMENT_PROXY AND
I_OI_SPREADSHEET.

All works fine, but when I integrated the SAP Transaction into our Portal and using the Program through the WEBGUI it dont works.

It looks like that he can't create a container Control, to open the File in Background in Excel.

I worked with Desktop Office Integration to read all Worksheets into SAP, like here:

http://abap-explorer.blogspot.com/2008/12/upload-data-from-multiple-worksheets-of.html

Is there any solution to solve my problem?

it returns me this message

"Cannot initialize control"

It seems that the error comes from this Method in Webgui:

Data iref_document    type ref to i_oi_document_proxy.

  call method iref_document->open_document
    exporting
      document_title = 'Excel'
      document_url   = v_document_url
      open_inplace   = 'X'
    importing
      error          = iref_error.
  if iref_error->has_failed = 'X'.
    call method iref_error->raise_message
      exporting
        type = 'I'.
    leave list-processing.
    exit.
  endif.

I hope someone can help me.

Thanks.

EDIT:

Today I tested the ABAP Report SAPRDEMOOFFICEINTEGRATION in our webgui

it returns me this error:

In dem Programm "C_OI_CONTAINER_CONTROL_CREATORCP" wurde durch eine

RAISE-Anweisung die Exception

(Ausnahmebedingung) "JAVABEANNOTSUPPORTED" ausgelöst.

Da die Exception nicht durch ein in der Aufrufhierarchie

Auslösestelle des Laufzeitfehlers

Programm C_OI_CONTAINER_CONTROL_CREATORCP

Include OFFICEINTEGRATIONDCCIMP

Zeile 70

Modultyp (METHOD)

Modulname I_OI_CONTAINER_CONTROL~INIT_CONTROL

Edited by: Sascha Baumann on Jul 15, 2009 9:18 AM

Edited by: Sascha Baumann on Jul 16, 2009 8:04 AM

[Sm1tje]

well I don't think that using CL_GUI_CUSTOM_CONTAINER will work in HTML based applications. These enjoy sap controls use a different framework which is only supported by standard SAP GUI.

[Former Member]

do you know a sap control which works in sap html gui?

its very important that it works with multiple worksheets in excel files

[Former Member]

Hi Sascha,

I have the same issue as yours.

Did you find a way to open your excel file in the WebGui?

Regards,

[christian_grail]

We have developed a solution for the "JAVABEANNOTSUPPORTED" error for SAP GUI for HTML and SAP GUI for JAVA.

The solution will be available with SAP S/4HANA Cloud 2305 (SAP_BASIS release 7.92 or newer) and SAP S/4HANA on premise 2023 (SAP_BASIS release 7.58 or newer).

You can find more information about the solution in the following blog entry:
https://blogs.sap.com/2023/03/08/how-to-enable-the-sap-desktop-office-integration-for-sap-gui-for-ht.../