03-09-2007 9:02 AM
Hi Friends,
Good evening ..
Can any one send me the reply about the FUNCTION MODULE that helps to upload an Excel file??
Thanks @ Anjali
03-09-2007 9:13 AM
Hi Anjali,
For uploading the data from excell one function module is available.
ALSM_EXCEL_TO_INTERNAL_TABLE.
hope this helps you and reward the points.
Regards,
Ravi.
03-09-2007 9:13 AM
Hi Anjali,
For uploading the data from excell one function module is available.
ALSM_EXCEL_TO_INTERNAL_TABLE.
hope this helps you and reward the points.
Regards,
Ravi.
03-09-2007 9:29 AM
Hi Anjali,
You can upload using this FM GUI_UPLOAD, save the file in tab delimited format and use the FM.
CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
filename = lcl_filename
filetype = 'ASC'
has_field_separator = 'X'
TABLES
data_tab = i_input
EXCEPTIONS
file_open_error = 1
file_read_error = 2
no_batch = 3
gui_refuse_filetransfer = 4
invalid_type = 5
no_authority = 6
unknown_error = 7
bad_data_format = 8
header_not_allowed = 9
separator_not_allowed = 10
header_too_long = 11
unknown_dp_error = 12
access_denied = 13
dp_out_of_memory = 14
disk_full = 15
dp_timeout = 16
OTHERS = 17.
You can also use this FM <b>TEXT_CONVERT_XLS_TO_SAP</b>
Chk this Link
***Reward Points if Useful
All the best
Gokul