topic Re: Uploading excel file in Application Development and Automation Discussions

Uploading excel file

Former Member — Sat, 28 Jun 2008 09:03:54 GMT

hi all,

will you please suggest me the process to upload an excel file with more than 1 worksheet from presentation server to ABAP?

Anirban Bhattacharjee

Re: Uploading excel file

Former Member — Sat, 28 Jun 2008 09:07:13 GMT

Anirban,

i rekon there is no method to upload more than one worksheet.

you have to upload one by one only.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
    EXPORTING
*     I_FIELD_SEPERATOR          =
      i_line_header              = 'X'
      i_tab_raw_data             = it_raw
      i_filename                 = pfile
    TABLES
      i_tab_converted_data       = it_excel[]
*   EXCEPTIONS
*     CONVERSION_FAILED          = 1
*     OTHERS                     = 2
            .
  IF sy-subrc <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
  ENDIF.

Amit.

Re: Uploading excel file

Former Member — Sat, 28 Jun 2008 09:12:23 GMT

hi check this..