Skip to Content
0
Aug 16, 2016 at 07:43 AM

Excel upload Error!!!!!!!!!!!

1914 Views

Hi Friends,

I am uploading Excel to Internal Table Using F4_FILENAME and TEXT_CONVERT_XLS_TO_SAP!!!!!!

Sometime It getting uploaded and sometime is not.

I have searched lot in SCN not able to find the solution.

My file path : C:\Users\Sony\Desktop\Go Colors\Upload1.xls

Upload program for FB60.

Program:

CALL FUNCTION 'F4_FILENAME'

EXPORTING

FIELD_NAME = 'PA_FILE'

IMPORTING

FILE_NAME = pa_file

.

if sy-subrc <> 0.

message id sy-msgid type sy-msgty number sy-msgno

with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

endif.

call function 'TEXT_CONVERT_XLS_TO_SAP'

exporting

* I_FIELD_SEPERATOR =

i_line_header = 'X'

i_tab_raw_data = it_raw

i_filename = v_file

tables

i_tab_converted_data = it_data1[]

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.

clear v_file.


Please guide I don't know why is not working!!!!!!!



Regards,

Sudarshan D