topic Re: About Excel Upload in Application Development and Automation Discussions

About Excel Upload

Former Member — Fri, 29 Sep 2006 10:16:50 GMT

Hi, All

There is a Excel who have two sheet, how can i upload

two sheet data to internal table from this excel?

thanks

Re: About Excel Upload

Former Member — Fri, 29 Sep 2006 10:26:27 GMT

Hi,

try the below function module.

ALSM_EXCEL_TO_INTERNAL_TABLE

Hope this will help some what.

Re: About Excel Upload

Former Member — Fri, 29 Sep 2006 10:27:04 GMT

hi,

check this link

Mirza Ifthekhar Baig has posted a function module to upload excel with 2 sheets.

Regards,

Sailaja.

Re: About Excel Upload

Former Member — Fri, 29 Sep 2006 10:29:18 GMT

hi,

Use <b>GUI_UPLOAD</b> FM

Use fm

ALSM_EXCEL_TO_INTERNAL_TABLE

to upload data frm excel.

Use function module GUI_UPLOAD

The FILETYPE refer to the type of file format you need: For e.g 'WK1' - Excel format , 'ASC' - Text Format etc.


CALL FUNCTION 'GUI_UPLOAD'
  EXPORTING
    FILENAME                      = 'C:test.xls'
   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.

Regards,

Santosh

Message was edited by: Santosh Kumar P

Re: About Excel Upload

Former Member — Fri, 29 Sep 2006 14:25:29 GMT

HI,

Try with this FM.

1) GUI_UPLOAD FM

2) ALSM_EXCEL_TO_INTERNAL_TABLE

Go thru this link

http://www.erpgenie.com/abap/functions.htm

Thanks

Sunil