Skip to Content
0
Former Member
Mar 02, 2009 at 07:09 AM

Error while uploading excel file

485 Views

Hi All,

I am using class cl_gui_frontend_services=>gui_upload, to upload an excel file for ASCII as well as for DAT format.

I am passing the following parameters to the method :

IF ascii EQ 'X'.

CALL METHOD cl_gui_frontend_services=>gui_upload

EXPORTING

filename = gv_filename

filetype = 'ASC'

has_field_separator = space

CHANGING

data_tab = inputdata_itab

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

not_supported_by_gui = 17

error_no_gui = 18

others = 19

ELSEIF dat EQ 'X'.

CALL METHOD cl_gui_frontend_services=>gui_upload

EXPORTING

filename = gv_filename

filetype = 'DAT'

has_field_separator = 'X'

CHANGING

data_tab = inputdata_itab

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

not_supported_by_gui = 17

error_no_gui = 18

others = 19.

endif.

In both the cases it is giving junk characters in the inetrnal table 'inputdata_tab'.

I tried without using the separator also but still sam eerror.

Can anyone please help me out of this.

Thanks in Advance.

Sunanda.