topic Re: Error in upload excel in Application Development and Automation Discussions

Error in upload excel

Former Member — Fri, 26 Oct 2018 01:33:08 GMT

Hi Experts,

I'm receiving an error when i use fm ALSM_EXCEL_TO_INTERNAL_TABLE to upload excel, the system return UPLOAD_OLE = 2 error.

Pls help me.....

My Ms Office Version is 2016 ; and SAP GUI version is SAP GUI 750 ,Patch 7.

Re: Error in upload excel

prad_k — Fri, 26 Oct 2018 06:11:11 GMT

Please check the below link.

https://archive.sap.com/discussions/thread/1267508

Re: Error in upload excel

Former Member — Fri, 26 Oct 2018 07:12:18 GMT

I have checked this link， it's not this issue, thanks.

Re: Error in upload excel

TMSingh_SAP — Fri, 26 Oct 2018 16:14:11 GMT

Hi,

can you share the code how it is written.

Thanks,

Mohan

Re: Error in upload excel

Former Member — Mon, 29 Oct 2018 01:10:21 GMT

Hi Mohan,

When I use SAP GUI 740 , It's OK. so.. t think the code is not relevant , thanks. the code as below.



SPAN {
font-family: "Courier New";
font-size: 10pt;
color: #000000;
background: #FFFFFF;
}
.L0S32 {
color: #3399FF;
}
.L0S52 {
color: #0000FF;
}
.L0S55 {
color: #800080;
}

      PERFORM FRM_UPLOAD_DATA_FROM_EXCEL

        TABLES GT_LIST

        USING P_FNAME 1 1 50000 16

        CHANGING GS_UPLOAD

        .


SPAN {
font-family: "Courier New";
font-size: 10pt;
color: #000000;
background: #FFFFFF;
}
.L0S31 {
font-style: italic;
color: #808080;
}
.L0S32 {
color: #3399FF;
}
.L0S33 {
color: #4DA619;
}
.L0S52 {
color: #0000FF;
}
.L0S55 {
color: #800080;
}
.L0S70 {
color: #808080;
}

FORM FRM_UPLOAD_DATA_FROM_EXCEL

   TABLES PT_UPLOAD

   USING PV_IP_FNAME PV_IP_BEGIN_ROW PV_IP_BEGIN_COL PV_IP_END_ROW

   PV_IP_END_COL

   CHANGING CV_PS_UPLOAD  "LIKE GS_UPLOAD

   .



  CONSTANTS:

    C_BEGIN_ROW TYPE I VALUE 2 ,

    C_END_ROW TYPE I VALUE 50000 ,

    C_BEGIN_COL TYPE I VALUE 1 ,      "起始列

    C_END_COL TYPE I VALUE 18.        "结束列



  DATA: LT_EXCEL TYPE ALSMEX_TABLINE OCCURS 0 WITH HEADER LINE.

  FIELD-SYMBOLS: <LV_F> TYPE ANY.



  CLEAR: PT_UPLOAD.

  REFRESH:PT_UPLOAD.



  CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

    EXPORTING

      FILENAME                = PV_IP_FNAME

      I_BEGIN_COL             = PV_IP_BEGIN_COL

      I_BEGIN_ROW             = PV_IP_BEGIN_ROW

      I_END_COL               = PV_IP_END_COL

      I_END_ROW               = PV_IP_END_ROW

    TABLES

      INTERN                  = LT_EXCEL

    EXCEPTIONS

      INCONSISTENT_PARAMETERS = 1

      UPLOAD_OLE              = 2

      OTHERS                  = 3.

  IF SY-SUBRC <> 0.

*IF NOT ( SY-MSGTY IS INITIAL OR SY-MSGID IS INITIAL OR SY-MSGNO IS

*INITIAL ).

*    MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

*      WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

*    ENDIF.

    MESSAGE E001(00) WITH TEXT-029 '' '' ''.

  ENDIF.





  LOOP AT LT_EXCEL.

    CONDENSE LT_EXCEL-VALUE.

* TRANSLATE LT_EXCEL-VALUE TO UPPER CASE.

    ASSIGN COMPONENT LT_EXCEL-COL OF STRUCTURE CV_PS_UPLOAD TO <LV_F>.

    IF SY-SUBRC = 0.

      <LV_F> = LT_EXCEL-VALUE.

      UNASSIGN <LV_F>.

    ENDIF.

    AT END OF ROW.

      MOVE-CORRESPONDING CV_PS_UPLOAD TO PT_UPLOAD.

      APPEND PT_UPLOAD.

      CLEAR: PT_UPLOAD ,

             CV_PS_UPLOAD .

    ENDAT.

  ENDLOOP.



ENDFORM.

Re: Error in upload excel

Lakshmipathi — Mon, 29 Oct 2018 04:35:40 GMT

Have a look at OSS note 933420

Re: Error in upload excel

Former Member — Mon, 29 Oct 2018 06:25:12 GMT

Thanks, but may be is not this issue, i debug into this function module, change the rows and cols ,the system error in row "

CREATE OBJECT application 'Excel.Application'. "as below.

Re: Error in upload excel

Former Member — Mon, 29 Oct 2018 06:27:32 GMT

In GUI 740, anything is OK.

Re: Error in upload excel

jayaraj2018 — Fri, 16 Aug 2019 13:49:55 GMT

Hi Ming,

Did you manage to resolve your problem. I am also facing the same error with the FM ALSM_EXCEL_TO_INTERNAL_TABLE while the program runs fine in others' PC.

I even tried reinstalling MS office and SAP GUI still no luck.
Appreciate your valuable feedback.

Regards,

Jay

Re: Error in upload excel

Sandra_Rossi — Fri, 16 Aug 2019 16:21:42 GMT

Can you mention inside your question that you debugged and that the error is triggered at that line:

CREATE OBJECT application 'Excel.Application'.

(otherwise people may ask you the solution although they have unrelated issues)

Re: Error in upload excel

Nawanandana — Fri, 16 Aug 2019 17:53:55 GMT

Hi,

Can you check error message ? sy-msgv1,sy-msgv2,sy-msgv3. or debug it, you will find the issue.

Re: Error in upload excel

Nawanandana — Fri, 16 Aug 2019 17:58:36 GMT

If its not work, try to use FM TEXT_CONVERT_XLS_TO_SAP