Problem with excel upload function

Former Member — Thu, 11 Aug 2011 12:33:54 GMT

Hello all,

I'm currently doing a modification in a program that uses this function:



  call function 'KCD_EXCEL_OLE_TO_INT_CONVERT'     

       exporting                                   

            filename    = p_file                   

            range_begin = 'A1'                     

            range_end   = 'I9999'                  

       tables                                      

            intern      = t_excel                  

       exceptions                                  

            others      = 1.                       

  if sy-subrc <> 0.                                

    berror = 'X'.                                  

    message i208(00) with 'Error Load Excel File'. 

    stop.                                          

  endif.

instead of upload the content of the excel to internal table, its literally copying the content of my clipboard to it.

Someone know why this is happening?

My version of SAP is the 4.0b and I looked for the alsm_excel_to_internal_table function, but my version don't have it.

Thanks

Re: Problem with excel upload function

Former Member — Thu, 11 Aug 2011 20:36:49 GMT

Hi,

an excel sheet can be uploaded in to a internal table of similar sequence and type using the following FMs

TEXT_CONVERT_XLS_TO_SAP

ALSM_EXCEL_TO_INTERNAL_TABLE

I think you already checked with the FMs UPLOAD and WS_UPLOAD.

Thanks,

Teja.

topic Re: Problem with excel upload function in Application Development and Automation Discussions

Problem with excel upload function

Re: Problem with excel upload function