Hi Vikas,
what i understood is , u hav a excel file on presentation server (desktop) and want to upload it to the appln server. if so do the following :
step one : save the excel file with all the data u wanted in it.
step two : save as the excel file in tab delimited format.
step three : save as the tab delimited file in ansi .txt format.
Now cg3z to upload the text file (.txt) in appln server .
open the file as below:
DATA: begin of itab,
col1 type <>,
col2 type <>,
end of itab.
DATA : wa_itab like itab.
DATA: wa(100) TYPE c,
xeof(1) TYPE c.
PARAMETERS: p_file(30) TYPE c DEFAULT 'appln server path .txt' LOWER CASE
OBLIGATORY,
OPEN DATASET <p_file> FOR INPUT IN TEXT MODE
ENCODING DEFAULT.
IF sy-subrc NE 0.
WRITE : ' error opening the file "
EXIT.
ELSE.
DO.
READ DATASET p_file INTO wa.
IF sy-subrc NE 0.
xeof = 'X'.
EXIT.
ENDIF.
IF sy-subrc EQ 0.
PERFORM split_data.
ELSE.
EXIT.
ENDIF.
ENDDO.
CLOSE DATASET p_file .
FORM split_data .
SPLIT wa AT cl_abap_char_utilities=>horizontal_tab
INTO wa_itab-col1 wa_itab-col2 wa_itab-col3.
APPEND wa_itab TO gi_itab.
ENDFORM. " SPLIT_DATA
Bluesky
