Problems with TEXT_CONVERT_XLS_TO_SAP

[bastinvinoth]

Hi Experts,

I have seen many threads regarding this, but didn't get exact answer   finally posted here

Reg: TEXT_CONVERT_XLS_TO_SAP; Problem opens a n... | SCN

while uploading the excel file , automatically the new excel file is open in client system so i cant able to proceed further

am getting error message like 'cannot be processed'(because file already open). but the same thing working in my system well ,

i don't know why how its possible in my system

Steps which i followed here:

I ran program and did a Simulate of the file

-          I saw an error on the file

-          I hit the back button until I was in the first screen of the transaction.

-          Then went into excel and tried to open the file and got the below popup message

Note: I don't want to use fm - ALSM_EXCEL_TO_INTERNAL_TABLE

see my below code for your reference.

REFRESH t_datatab.
 *get data from excel to prog. itab
   CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
     EXPORTING
       i_field_seperator    = '*'
       i_line_header        = space
       i_tab_raw_data       = t_raw          "WORK TABLE
       i_filename           = p_file
     TABLES
       i_tab_converted_data = t_datatab[]    "ACTUAL DATA
     EXCEPTIONS
       conversion_failed    = 1
       OTHERS               = 2.
 *if its error, display them in ALV
   IF sy-subrc <> 0.
     CLEAR g_err_text.
     CALL FUNCTION 'FORMAT_MESSAGE'
       EXPORTING
         id   = sy-msgid
         lang = sy-langu
         no   = sy-msgno
         v1   = sy-msgv1
         v2   = sy-msgv2
         v3   = sy-msgv3
         v4   = sy-msgv4
       IMPORTING
         msg  = g_err_text.
     w_return-type       = sy-msgty.
     w_return-id         = sy-msgid.
     w_return-number     = sy-msgno.
     w_return-message    = g_err_text.
     w_return-message_v1 = sy-msgv1.
     w_return-message_v2 = sy-msgv2.
     w_return-message_v3 = sy-msgv3.
     w_return-message_v4 = sy-msgv4.
     APPEND w_return TO t_return.
     g_type = c_error_mess.
     g_xl = c_x.
     PERFORM sub_sim_report.
     LEAVE TO CURRENT TRANSACTION.
   ENDIF.

Can anybody help me out to get solution ?

Regards,

Bastin.G

[arindam_m]

Hi,

Check the version of MS EXCEL. The FM is quite a old one so it does have issues if the excel application installed is newer than 97-2003 format. It might more of a excel application problem and happens when people use excel templates. Check the link from Microsoft might help you,

http://answers.microsoft.com/en-us/office/forum/office_2007-office_install/opening-wordexcel-documen...

Cheers,

Arindam

[bastinvinoth]

Hi Arindam Mondal Manish Kumar

Thanks for your reply  

i will start looking on to the issue as per your suggestions

i will get back to you once completed

Note : am having ms-excel 2010 in my system , here it supports perfectly, need to check with user system

Issue transferred to basis

Regards,

Bastin.G

[Former Member]

Since the issue is specific to a system, you could compare MS Office and SAP GUI versions on working and non-working systems.

[former_member797945]

Please refer Excel Pop up issue in some reports | SAP Community.

Regards,

Anil Gouda

[Former Member]

did you get a resolution to this?