topic Re: Problem with Excel Download in Application Development and Automation Discussions

Problem with Excel Download

Former Member — Wed, 23 Aug 2006 11:27:51 GMT

Hi There,

Were upgradding to version 700 (ECC 2005) and we have a problem when we download to excel.

When program (customer) is run (in foreground) we get an dump when we try to download to excel using the MS_EXCEL_OLE_STANDARD_DAT Function Module. it seems to have a problem when it gets to the; call method cl_gui_frontend_services => file_exist

SAP kernal 700

SAP database 700

SAP Gui 640

Any thought on the problem ?

Thanks

Re: Problem with Excel Download

Former Member — Wed, 23 Aug 2006 11:30:27 GMT

Cud you forward the snap shot of dump at devajyothi2000@yahoo.com

Regards,

Deva.

Re: Problem with Excel Download

Former Member — Wed, 23 Aug 2006 11:33:08 GMT

hi Conor,

Try Passing the parameters as specified here in the below code ...

DATA : l_result,
         l_filename TYPE string.

  l_filename = fp_name.

  CLEAR l_result.

  CALL METHOD cl_gui_frontend_services=>file_exist
    EXPORTING
      file                 = l_filename
    RECEIVING
      result               = l_result
    EXCEPTIONS
      cntl_error           = 1
      error_no_gui         = 2
      wrong_parameter      = 3
      not_supported_by_gui = 4
      OTHERS               = 5.

  IF sy-subrc <> 0.
    MESSAGE s007 DISPLAY LIKE c_e.
    LEAVE LIST-PROCESSING.
  ELSEIF l_result IS INITIAL.
    MESSAGE s008 DISPLAY LIKE c_e.
    LEAVE LIST-PROCESSING.
  ENDIF.

Re: Problem with Excel Download

Former Member — Wed, 23 Aug 2006 12:03:58 GMT

Hi Santosh,

I cant change the code because it's SAP standard (I would njeed to find an OSS note and there doesnt seems to be one there) the SAP Standard incluse is LSLPCF02 and the code is as follows:

DATA: fname type string,

result type abap_bool.

fname = file_name.

CALL METHOD cl_gui_frontend_services=>file_exist

EXPORTING

file = fname

receiving

result = result

EXCEPTIONS

others = 0.

call method cl_gui_cfw=>flush.

IF result = abap_false.

RAISE file_not_exist.

ENDIF.

This seems to be the same, only difference is the way i_result is declared ??

Thanks