10-10-2007 11:59 AM
if i have data in excel format which i save it into tab delimited format then in gui_upload which file type i have to used?
or if i have data in word format which i save in it into tab delimited format then in gui_upload which file type i have to used?
Can any one help me?
Thanks,
Vishal Bhagwat.
10-10-2007 12:01 PM
Hi,
Save it as tab delimeted using the save as
it will be of tab delimeted
Regards
Shiva
10-10-2007 12:01 PM
Hi,
Save it as tab delimeted using the save as
it will be of tab delimeted
Regards
Shiva
10-10-2007 12:06 PM
Hi shiva,
Thanks but i have prob in gui_upload fn i have data in excel i save it as tab delimited but which file type is used in gui_upload is 'ASC' or any other type.
Thanks
Vishal bhagwat.
10-10-2007 1:23 PM
hi
the file type is ASC
Use FM ALSM_EXCEL_TO_INTERNAL_TABLE
TYPES:
BEGIN OF ty_upload,
field1 TYPE c length 12,
field2 TYPE c length 12,
field3 TYPE c length 12,
END OF ty_upload.
DATA it_upload TYPE STANDARD TABLE OF ty_upload WITH DEFAULT KEY.
DATA wa_upload TYPE ty_upload.
DATA itab TYPE STANDARD TABLE OF alsmex_tabline WITH DEFAULT KEY.
FIELD-SYMBOLS: <wa> type alsmex_tabline.
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
EXPORTING
filename = filename
i_begin_col = 1
i_begin_row = 1
i_end_col = 3
i_end_row = 65535
TABLES
intern = itab.
LOOP AT itab ASSIGNING <wa>.
CASE <wa>-col.
WHEN '0001'.
wa_upload-field1 = <wa>-value.
WHEN '0002'.
wa_upload-field2 = <wa>-value.
WHEN '0003'.
wa_upload-field3 = <wa>-value.
ENDCASE.
APPEND wa_upload TO it_upload.
CLEAR wa_upload.
ENDLOOP.
Reward if usefull
10-10-2007 3:39 PM
hello Vishal,
select file type as 'ASC' but then select HAS_FIELD_SEPARATOR to 'X'
or use 'DAT' format which is exclusive for tab deliminated data.
Hope this will answer your doubt. reward points if useful.
Rushikesh
10-12-2007 7:57 AM
Hi Rushikesh,
Thank's for sol'n My prob was solved. but i have one query that if we have data in word format then is it nessesary to save this file in tab delimited or keep the file as it is.
Thanks,
Regards,
Vishal Bhagwat.