Skip to Content
author's profile photo Former Member
Former Member

upload excel file

Is there any function module to upload excel file from

presentation server

Add comment
10|10000 characters needed characters exceeded

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 11:48 AM

    check <b>ALSM_EXCEL_TO_INTERNAL_TABLE</b>.

    regards

    Prabhu

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 11:49 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 01, 2006 at 11:50 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 11:57 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 12:02 PM
    Add comment
    10|10000 characters needed characters exceeded