cancel
Showing results for 
Search instead for 
Did you mean: 

Need Sample code to upload user created excel sheet data in SAP 4.0B

Former Member
0 Kudos

Need Sample code to upload user created excel sheet data in SAP 4.0B

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Use ws_upload or upload function modules.

For WS_UPLOAD ,it will prompt you for the file name with path.

Former Member
0 Kudos

check this function module

call function 'ALSM_EXCEL_TO_INTERNAL_TABLE'

exporting

filename = p_path

i_begin_col = 1

i_begin_row = 2

i_end_col = 70

i_end_row = 10000

tables

intern = i_excel

exceptions

inconsistent_parameters = 1

upload_ole = 2

others = 3.

if sy-subrc <> 0.

endif.

Former Member
0 Kudos

The function module suggested by you does not exist in 4.0B.Please suggest some other option.

Former Member
0 Kudos

If you really cant find any other option. The last resort is, you can create a Zfunction module and copy the code available in 4.7 into the Zfunctionmodule.

Former Member
0 Kudos

Probably you need to use ws_upload function module. you need ask the user to convert excel file into tab delimited format txt file and upload.

Former Member
0 Kudos

ws_upload will support excel upload directly.