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: 

WS_UPLOAD in 4.5

Former Member
0 Kudos

Hello All,

1.      Can WS_UPLOAD FM can be used to upload XL files in SAP 4.5 Version ?

2.       If not then what is the procedure to upload XL Files in 4.5 Version SAP System ?

Regards,

Deepu.K

1 ACCEPTED SOLUTION

Former Member
0 Kudos

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

gui_upload.

Message was edited by:

Karthikeyan Pandurangan

Message was edited by:

Karthikeyan Pandurangan

8 REPLIES 8

Former Member
0 Kudos

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

gui_upload.

Message was edited by:

Karthikeyan Pandurangan

Message was edited by:

Karthikeyan Pandurangan

hymavathi_oruganti
Active Contributor
0 Kudos

alsm_excel_to_internal_table

check this fn module

JozsefSzikszai
Active Contributor
0 Kudos

hi Deepu,

what do you mean by XL file? Is it a big file? And XXL is a very big file?

ec

Former Member
0 Kudos

Hi,

Use WS_UPLOAD you give 'WK1' option while uploading data from Excel.

WK1 is the file type option used in WS_UPLOAD for uploading Excel and it works

regards,

Omkar.

0 Kudos

Hello ,

@Karthikeyan : GUI_UPLOAD FM is not available in my system.

and can u tell me whts the Purpose of the FM 'TEXT_CONVERT_XLS_TO_SAP' ??

@Hymavathi : alsm_excel_to_internal_table FM is not available in my system.

@Eric : I meant MICROSOFT EXCEL Files .

@OMKAR : When I gave WK1 as the filetype it went for a dump as the dump says WK1 is not yet available .

Any other options ??????

Regards,

Deepu.K

0 Kudos

if the type pool OLE2 exists in your system, than you can write a program which uploads data from excel. You should have the following ABAP statements avaliable as well (relevant for OLE):

CALL METHOD OF ...

GET PROPERTY OF ...

SET PROPERTY OF ...

CREATE OBJECT ....

FREE OBJECT ...

otherwise you have one more chance: save the excel file as text file (tab delimited) and you can upload with WS_UPLOAD. Or you can save as CSV as well and upload accordingly.

ec

0 Kudos

Hello All,

Thanks for ur replies.

The FM 'TEXT_CONVERT_XLS_TO_SAP' is working.

Regards,

Deepu.K

former_member386202
Active Contributor
0 Kudos

Hi,

Use FM " ALSM_EXCEL_TO_INTERNAL_TABLE ".

Regards,

Prashant