Skip to Content
0
Former Member
Jan 10, 2008 at 06:52 AM

GUI_UPLOAD problem if input data is using Excel

2053 Views

Hi , Some one can answer this quick question.

While i am using GUI_upload i am not able to recieve the data properly.

*************************

  • GUI UPLOAD From Data

*************************

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = lvs_filenm

FILETYPE = 'ASC'

  • HAS_FIELD_SEPARATOR = 'X'

  • HEADER_LENGTH = 0

  • READ_BY_LINE = 'X'

  • DAT_MODE = ' '

  • CODEPAGE = ' '

  • IGNORE_CERR = ABAP_TRUE

  • REPLACEMENT = '#'

  • CHECK_BOM = ' '

  • VIRUS_SCAN_PROFILE =

  • NO_AUTH_CHECK = ' '

  • IMPORTING

  • FILELENGTH =

  • HEADER =

its not working properly . can i give any has field separtor like 'X'

And i copied the same data in excel to text file. GUI_upload is working fine and data is exactly coming in to the internal table.

*************************

  • GUI UPLOAD From Data

*************************

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = lvs_filenm

FILETYPE = 'DAT'

HAS_FIELD_SEPARATOR = 'X'

  • HEADER_LENGTH = 0

  • READ_BY_LINE = 'X'

  • DAT_MODE = ' '

  • CODEPAGE = ' '

  • IGNORE_CERR = ABAP_TRUE

  • REPLACEMENT = '#'

  • CHECK_BOM = ' '

  • VIRUS_SCAN_PROFILE =

  • NO_AUTH_CHECK = ' '

  • IMPORTING

  • FILELENGTH =

  • HEADER =

Any one can help me out in this regard. Client wants to use GUI_upload functional module only...