07-15-2008 8:59 AM
Hi,
Can anyone suggest me a function module to upload the data from an excel file into ztable other than the function module ALSM_EXCEL_TO_INTERNAL_TABLE.
07-15-2008 9:01 AM
Hi,
Use this FM:
TEXT_CONVERT_XLS_TO_SAP
********************************************************
For example, go through tje following link:
http://www.sapdevelopment.co.uk/file/file_upexcel.htm
Thanks,
Shailaja
Edited by: Shailaja on Jul 15, 2008 10:11 AM
07-15-2008 9:03 AM
07-15-2008 9:08 AM
Welcome to SDN,
just see these report in se38 for more help.
FILA_HELP_UPLOAD_EXCEL_01 Report FILA_HELP_UPLOAD_EXCEL_01
FILA_HELP_UPLOAD_EXCEL_03 Report FILA_HELP_UPLOAD_EXCEL_03
also you can use:
TYPE-POOLS: truxs .
DATA: it_raw TYPE truxs_t_text_data.
PARAMETER: pfile LIKE rlgrap-filename." OBLIGATORY.
CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
EXPORTING
* I_FIELD_SEPERATOR =
i_line_header = 'X'
i_tab_raw_data = it_raw
i_filename = pfile
TABLES
i_tab_converted_data = it_excel[]
* 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.
Amit.
07-15-2008 9:12 AM
There is no any FM that ll directly load ur data to Ztable.
Instead u can do one thing u load the data into ur Internal table
And from interal Table u can load ur ztable.
use this FM for loading into IT
TEXT_CONVERT_XLS_TO_SAP
then
insert <ztable> from IT.