METHOD GUI_UPLOAD PROBLEM

[Former Member]

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)

[Former Member]

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

[Former Member]

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

[Clemenss]

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

[madhu_vadlamani]

Dear

Masuke,

Please elaborate your requirement more clear.

Regards,

Madhu.