topic UPLOADING THE DATA FROM EXCEL FILES in Application Development and Automation Discussions

UPLOADING THE DATA FROM EXCEL FILES

Former Member — Fri, 09 Mar 2007 09:02:29 GMT

Hi Friends,

Good evening ..

Can any one send me the reply about the FUNCTION MODULE that helps to upload an Excel file??

Thanks @ Anjali

Former Member — Fri, 09 Mar 2007 09:13:03 GMT

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.

Former Member — Fri, 09 Mar 2007 09:29:21 GMT

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