topic Re: METHOD GUI_UPLOAD PROBLEM in Application Development and Automation Discussions

METHOD GUI_UPLOAD PROBLEM

Former Member — Wed, 26 Jan 2011 08:41:22 GMT

Hi,

I have used method gui_upload with 'ASC' to get data from excel into my internal table.But when i run the program my report is unreadable.By the way I am using method gui_upload because java doesnt support the function TEXT_CONVERT_XLS_TO_SAP.(Also I have tried 'DAT' and 'TXT' with method gui_upload)

Re: METHOD GUI_UPLOAD PROBLEM

Former Member — Wed, 26 Jan 2011 09:33:05 GMT

if you save your excel as txt file separated by tabulator, you can use the f.m. (or the method if you like)

call function 'GUI_UPLOAD'

exporting

filename = l_filename

filetype = 'ASC'

has_field_separator = 'X'

HEADER_LENGTH = 0
READ_BY_LINE = 'X'

dat_mode = 'X'

CODEPAGE = ' '
IGNORE_CERR = ABAP_TRUE
REPLACEMENT = '#'
CHECK_BOM = ' '
VIRUS_SCAN_PROFILE =
NO_AUTH_CHECK = ' '
IMPORTING
FILELENGTH =
HEADER =

tables

data_tab = wt_input[]

regards.

Andrea

Re: METHOD GUI_UPLOAD PROBLEM

Former Member — Wed, 26 Jan 2011 10:14:37 GMT

Use FM 'ALSM_EXCEL_TO_INTERNAL_TABLE' to upload the data from excel.

[http://wiki.sdn.sap.com/wiki/display/Snippets/Howtouse+FM'ALSM_EXCEL_TO_INTERNAL_TABLE']

Edited by: praveen reddy on Jan 26, 2011 12:01 PM

Re: METHOD GUI_UPLOAD PROBLEM

Clemenss — Wed, 26 Jan 2011 11:52:42 GMT

Hi Masuke,

please open your excel file in a text editor and see what it looks like - I suppose like your report as described..

I do not know if it is possible to read proprietary Microsoft excel format and convert this into anything that makes sense.

Please search before post. There is so much stuff available.

Regards,

Clemens

Re: METHOD GUI_UPLOAD PROBLEM

madhu_vadlamani — Fri, 28 Jan 2011 04:58:31 GMT

Dear

Masuke,

Please elaborate your requirement more clear.

Regards,

Madhu.