topic Re: Uploading Excel file using GUI_UPLOAD in Application Development and Automation Discussions

Uploading Excel file using GUI_UPLOAD

Former Member — Tue, 09 Feb 2010 12:49:09 GMT

Hi Friends,

I want to upload a excel file to internal table,iam facing a issue with GUI_UPLOAD? can you please tell me how to upload it?

any sample code will be greatly helpful.

Regards

Babu

Former Member — Tue, 09 Feb 2010 12:52:11 GMT

Please search.. there are more than 1000 posts for these...

use other FMs as well... search and you will get them..

Former Member — Tue, 09 Feb 2010 12:53:23 GMT

Hello

Are you read RULES and use SEARCH before posting ?

former_member188827 — Tue, 09 Feb 2010 12:54:27 GMT

check FM documentation in se37.sample code is available there

Former Member — Tue, 09 Feb 2010 12:56:29 GMT

hi,

these are basic things which are already present in SDN do search before posting

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = 'c:\itab_mat.xls'

FILETYPE = 'DAT'

HAS_FIELD_SEPARATOR = 'X'

TABLES

DATA_TAB = ITAB

IF SY-SUBRC <> 0.

ENDIF.

thanks

shivraj

Edited by: ShivrajSinha on Feb 9, 2010 1:56 PM

BH2408 — Tue, 09 Feb 2010 12:59:19 GMT

Hi ,

USe the FM ALSM_EXCEL_TO_INTERNAL_TABLE to upload the file from Excel to internal table.

Reagrds,

Bharani

Former Member — Tue, 09 Feb 2010 13:04:35 GMT

Next time, please search before asking basic questions.