Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How can i take an excel sheet input into my report

Former Member
0 Kudos

I am having one interactive report.For this how can I take input as excel record as input.

Please note I am having interactive report not BDC.

3 REPLIES 3

Former Member
0 Kudos

Hi ,

use FM upload ,gui_upload ,ws_upload ...

Regards

Renu

GauthamV
Active Contributor
0 Kudos

hi,

use this function module.

ALSM_EXCEL_TO_INTERNAL_TABLE.

Former Member
0 Kudos

you can use the fm gui_upload

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = lv_filet

filetype = 'ASC'

has_field_separator = 'X'

read_by_line = 'X'

dat_mode = ' '

TABLES

data_tab = gi_upload

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