need to upload xl file from service

[Former Member]

Hi All,

I have a requirement in which i have to upload a XL file from Odata service in ABAP Server.

Then after i have to read the XL file and update my DB table .

I have developed a FM to read the XL data and updating my DB table if i am executing the FM it is working fine but when i am including the FM

to service it failing and showing exception.

Kindly suggest me the solution.

Thanks and regard,

Rewati Raman

[kaus19d]

Hi ,

What was the Exception? I think you need to include a Gateway service. Its not mentioned in your query  like as mentioned in the below,

File Attachments Approach in Gateway | SCN

Also in addition needed to check-out the below, in this relevant,

Load data from EXCEL file into Table UI on the ... | SCN

Thanks,

Kaushik

[Former Member]

Thanks Kaushik Debnath for your reply.

I am using ALSM_EXCEL_TO_INTERNAL_TABLE Fm to read data from XL file inside this FM a standerd class is there

CALL METHOD cl_gui_frontend_services=>clipboard_import

    IMPORTING

      data                 = excel_tab

    EXCEPTIONS

      cntl_error           = 1

*      ERROR_NO_GUI         = 2

*      NOT_SUPPORTED_BY_GUI = 3

      OTHERS               = 4

          .

  IF sy-subrc <> 0.

     MESSAGE a037(alsmex).

  ENDIF.

while executing this line i am getting  cntl_error   = 1 exception .

So in service following error is coming                                                                                                   Message A ALSMEX 037 cannot be processed in plugin mode HTTPS.

I didnt upload the XL file to service directly i was trying to read data from XL using FM .

Is it mandatory to upload first the read or directly i can read XL in service ?

Regard,

Rewati Raman

[kaus19d]

Hi ,

please do Upload 1st & check, you will easily observer the difference. If you Debug, its is possible that in your way, it would through a dump in ST22 & can also check the responsible-program lines from there.

Somehow, your similar issue was faced by our friends provided in the below link also,

Error while using File Upload through Frontend | SCN

Thanks,

Kaushik