Standard document interface is not available

Former Member — Sun, 01 Jan 2012 08:10:58 GMT

Hi All,

I am using the method "get_spreadsheet_interface" from class "i_oi_document_proxy" to get the interface from an 2007 Excel File with multiple worksheets. I have successfully opened the file using "open_document" but when I execute the "get_spreadsheet_interface" I got the error "Standard Document Interface is not available". My gui is 710 and the patch level is 21. I would like to ask is there any additional plugin which I have to install?

Thanks.

Re: Standard document interface is not available

madhu_vadlamani — Sun, 01 Jan 2012 16:44:45 GMT

Hi Jamison,

Can you paste the code.

Regards,

Madhu.

Re: Standard document interface is not available

Former Member — Mon, 02 Jan 2012 00:18:12 GMT

Hi Madhu, I got stuck at the get_document_interface... thanks

DATA:

oref_container TYPE REF TO cl_gui_custom_container,

iref_control TYPE REF TO i_oi_container_control,

iref_document TYPE REF TO i_oi_document_proxy,

iref_spreadsheet TYPE REF TO i_oi_spreadsheet,

iref_error TYPE REF TO i_oi_error.

DATA:

v_document_url TYPE c LENGTH 256,

i_sheets TYPE soi_sheets_table,

wa_sheets TYPE soi_sheets,

i_data TYPE soi_generic_table,

wa_data TYPE soi_generic_item,

i_ranges TYPE soi_range_list,

AVAILABLE TYPE I.

PARAMETERS:

p_file TYPE localfile OBLIGATORY,

p_rows TYPE i DEFAULT 100 OBLIGATORY, "Rows (Maximum 65536)

p_cols TYPE i DEFAULT 10 OBLIGATORY. "Columns (Maximum 256)

INITIALIZATION.

CALL METHOD c_oi_container_control_creator=>get_container_control

IMPORTING

control = iref_control

error = iref_error

retcode =

IF iref_error->has_failed = 'X'.

CALL METHOD iref_error->raise_message

EXPORTING

type = 'E'.

ENDIF.

CREATE OBJECT oref_container

EXPORTING

parent =

container_name = 'CONT'

style =
lifetime = lifetime_default
repid =
dynnr =
no_autodef_progid_dynnr =

EXCEPTIONS

cntl_error = 1

cntl_system_error = 2

create_error = 3

lifetime_error = 4

lifetime_dynpro_dynpro_link = 5

OTHERS = 6.

IF sy-subrc <> 0.

MESSAGE e001(00) WITH 'Error while creating container'.

ENDIF.

CALL METHOD iref_control->init_control

EXPORTING

dynpro_nr = SY-DYNNR
gui_container = ' '

inplace_enabled = 'X'

inplace_mode = 0
inplace_resize_documents = ' '
inplace_scroll_documents = ' '
inplace_show_toolbars = 'X'
no_flush = ' '
parent_id = cl_gui_cfw=>dynpro_0

r3_application_name = 'EXCEL CONTAINER'

register_on_close_event = ' '
register_on_custom_event = ' '
rep_id = SY-REPID
shell_style = 1384185856

parent = oref_container

name =
autoalign = 'x'

IMPORTING

error = iref_error

retcode =

EXCEPTIONS

javabeannotsupported = 1

OTHERS = 2

IF iref_error->has_failed = 'X'.

CALL METHOD iref_error->raise_message

EXPORTING

type = 'E'.

ENDIF.

CALL METHOD iref_control->get_document_proxy

EXPORTING

document_format = 'NATIVE'

document_type = soi_doctype_excel_sheet

no_flush = ' '
register_container = ' '

IMPORTING

document_proxy = iref_document

error = iref_error

retcode =

IF iref_error->has_failed = 'X'.

CALL METHOD iref_error->raise_message

EXPORTING

type = 'E'.

ENDIF.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.

To provide F4 help for the file

PERFORM sub_file_f4.

START-OF-SELECTION.

CONCATENATE 'FILE://' p_file INTO v_document_url.

CALL METHOD iref_document->open_document

EXPORTING

document_title = 'Excel'

document_url = v_document_url

no_flush = ' '

open_inplace = 'X'

open_readonly = ' '
protect_document = ' '
onsave_macro = ' '
startup_macro = ''
user_info =

IMPORTING

error = iref_error

retcode =

IF iref_error->has_failed = 'X'.

CALL METHOD iref_error->raise_message

EXPORTING

type = 'I'.

LEAVE LIST-PROCESSING.

ENDIF.

CALL METHOD iref_document->get_spreadsheet_interface

EXPORTING

no_flush = ' '

IMPORTING

error = iref_error

sheet_interface = iref_spreadsheet

retcode =

IF iref_error->has_failed = 'X'.

CALL METHOD iref_error->raise_message

EXPORTING

type = 'I'.

LEAVE LIST-PROCESSING.

ENDIF.

Re: Standard document interface is not available

madhu_vadlamani — Mon, 02 Jan 2012 01:59:18 GMT

Hi Jamison,

Where you called this sub routine PERFORM sub_file_f4..Get the ERROR,RETCODE and see.

Regards,

Madhu.

Edited by: madhurao123 on Jan 2, 2012 7:34 AM

Re: Standard document interface is not available

former_member199670 — Fri, 27 Feb 2015 11:37:30 GMT

Hi Jamison,

Did you find the solution for this ?

If Yes can you please provide the answer.

Thanks

Manimaran K

topic Re: Standard document interface is not available in Application Development and Automation Discussions

Standard document interface is not available

Re: Standard document interface is not available

Re: Standard document interface is not available

Re: Standard document interface is not available

Re: Standard document interface is not available