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