topic Re: GUI_UPLOAD - EXCEL FILE PROBLEM in Application Development and Automation Discussions

GUI_UPLOAD - EXCEL FILE PROBLEM

Former Member — Thu, 12 May 2005 11:56:41 GMT

Hi All,

I am using GUI_UPLOAD function for BDC. I want to upload a file but there i m gatting error. I tried with both file type excel & txt.

While running the recording it takes ##### chars.

Regards,

Dilip

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = 'c:\excel.xls'

FILETYPE = 'BIN'

HAS_FIELD_SEPARATOR = ' '
HEADER_LENGTH = 0
READ_BY_LINE = 'X'
DAT_MODE = ' '
CODEPAGE = ' '
IGNORE_CERR = ABAP_TRUE
REPLACEMENT = '#'
CHECK_BOM = ' '
IMPORTING
FILELENGTH =
HEADER =

tables

data_tab = it_bdc

Re: GUI_UPLOAD - EXCEL FILE PROBLEM

Former Member — Thu, 12 May 2005 12:20:09 GMT

Change File type tp DAT and try.

Rgds,

Manohar

Re: GUI_UPLOAD - EXCEL FILE PROBLEM

Former Member — Thu, 12 May 2005 12:23:45 GMT

Hi Dilip,

Try saving the excel file as CSV file ( file type *.csv in save as function of Excel) and change the FILETYPE in "GUI_UPLOAD" to 'ASC'.

Regards,

Sanjeev

Re: GUI_UPLOAD - EXCEL FILE PROBLEM

Former Member — Thu, 12 May 2005 12:52:08 GMT

Dear Dilip,

I have used GUI_UPLOAD a lot, but never like this.

Well i'll tell you to upload .txt file . Download or save EXCEL file as text delimited by tab as it gets saved normally. Dont forget that except characters all other fields are in formatted as text field in Excel, they will get alinged as a normal text field only.

My txt file have data like below.

RAJESH 10

RAJSALECHA 11

BCONE 13

Then in program i have done as below.

Report ZTEST5.

PARAMETERS : FILE TYPE RLGRAP-FILENAME.

DATA : BEGIN OF IT OCCURS 0,

NAME(20),

AGE(4),

END OF IT.

DATA : PATH TYPE STRING.

PATH = FILE.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = PATH

FILETYPE = 'ASC'

HAS_FIELD_SEPARATOR = 'X'

TABLES

DATA_TAB = IT.

LOOP AT IT.

WRITE : /1 IT-NAME COLOR 1, 20 IT-AGE COLOR 4.

ENDLOOP.

Kindly see this and tell me if you face any problem in it.

Raj Salecha

rajeshkumar.salecha@bcone.com

Re: GUI_UPLOAD - EXCEL FILE PROBLEM

Former Member — Wed, 08 Apr 2009 12:05:16 GMT

This message was moderated.