topic Re: upload excel file in Application Development and Automation Discussions

upload excel file

Former Member — Tue, 01 Aug 2006 11:46:46 GMT

Is there any function module to upload excel file from

presentation server

Re: upload excel file

Former Member — Tue, 01 Aug 2006 11:48:45 GMT

check <b>ALSM_EXCEL_TO_INTERNAL_TABLE</b>.

regards

Prabhu

Re: upload excel file

Former Member — Tue, 01 Aug 2006 11:49:00 GMT

hi,

Use FM <b>GUI_UPLOAD</b>

Check this thread out for the same

Re: upload excel file

Former Member — Tue, 01 Aug 2006 11:49:01 GMT

Hi you can do it in two ways.

1. save the excel file as tab delimited file and use GUI_UPLOAD.

2. use this FM

'ALSM_EXCEL_TO_INTERNAL_TABLE'

Regards,

Sumit.

Re: upload excel file

ashok_kumar24 — Tue, 01 Aug 2006 11:50:19 GMT

Hi Ronie James ,

You can upload data from presentation server to an internal table using gui_upload.

Use gui_download to download from internal table to flat file.

Use fm ALSM_EXCEL_TO_INTERNAL_TABLE to upload data frm excel.

Use function module GUI_UPLOAD

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = 'C:\test.csv'

FILETYPE = 'ASC'

TABLES

DATA_TAB = 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

OTHERS = 17.

Good LUck and reward me for the same

Thanks

Ashok

Re: upload excel file

Former Member — Tue, 01 Aug 2006 11:57:45 GMT

hi Ronie,

You can use the FM GUI_UPLOAD.

http://www.sap-img.com/abap/upload-direct-excel.htm

http://www.sapdevelopment.co.uk/file/file_upexcel.htm

These links will give you detailed example.

The FM TEXT_CONVERT_XLS_TO_SAP/ALSM_EXCEL_TO_INTERNAL_TABLE will also solve the purpose

Hope you will find this info useful

Regards,

Richa

Re: upload excel file

Former Member — Tue, 01 Aug 2006 12:02:02 GMT

check these links

http://www.sapdevelopment.co.uk/file/file_upexcel.htm

http://www.sapdevelopment.co.uk/file/file_upexcelalt1.htm

http://www.sapdevelopment.co.uk/file/file_upexcelalt2.htm

regards

Srikanth