GUI_UPLOAD & GUI_DOWNLOAD

[Former Member]

Hi Could anyone please explain me kind of inputs that I need to give to this Function Module. I want to import one excel file and need to do some processing on it and replace original excel file by new one.

Can i Use above mentioned Function Modules to satisfy my requirements?

Thanks & Regards

Jigar

[Former Member]

Hi Could anyone please explain me kind of inputs that I need to give to this Function Module. I want to import one excel file and need to do some processing on it and replace original excel file by new one.

Can i Use above mentioned Function Modules to satisfy my requirements?

Thanks & Regards

Jigar

[Former Member]

No..,

u cannot use above function module (Gui Upload) to upload data from an excel file into an internal table..

U need to use the function module <b>ALSM_EXCEL_TO_INTERNAL_TABLE</b> to import data from excel file into an internal table...

But u can use the function module <b>GUI_DOWNLOAD</b> to populate an excel file with the data in an internal table...

while giving the file path give the filename with the extension '.XLS'...

reward points for all helpful answers...

sai ramesh

[Former Member]

Hi...

for uploading file from Excel sheet you can use "ALSM_EXCEL_TO_INTERNAL_TABLE". go through that FM...

then..for downloading that use "GUI_DOWNLOAD" ..In that give ".xls" at the end of your file name. and " WRITE_FIELD_SEPARATOR = 'x'".

Ram

[Former Member]

HI,

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = 'C:/VEND.XLS'(file path)

FILETYPE = 'ASC'(file type)

TABLES

DATA_TAB = ITAB.(internal table.)

UR MODUFICATIONS IN THE DATA.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

• BIN_FILESIZE =

FILENAME = 'C:/VEND.XLS'(file path)

• FILETYPE = 'ASC'

• APPEND = ' '

• WRITE_FIELD_SEPARATOR = ' X'(IN CASE IF U WANT FIELD SEPERATOR)

• HEADER = '00'

• TRUNC_TRAILING_BLANKS = ' '

• WRITE_LF = 'X'

• COL_SELECT = ' '

• COL_SELECT_MASK = ' '

• DAT_MODE = ' '

• CONFIRM_OVERWRITE = ' '

• NO_AUTH_CHECK = ' '

• CODEPAGE = ' '

• IGNORE_CERR = ABAP_TRUE

• REPLACEMENT = '#'

• WRITE_BOM = ' '

• TRUNC_TRAILING_BLANKS_EOL = 'X'

• WK1_N_FORMAT = ' '

• WK1_N_SIZE = ' '

• WK1_T_FORMAT = ' '

• WK1_T_SIZE = ' '

• WRITE_EOL = ABAP_TRUE

• IMPORTING

• FILELENGTH =

TABLES

DATA_TAB = ITAB(MODIFIED INTERNAL TABLE DATA).

REGARDS,

BHARAT.

[Former Member]

HI

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = w_filename_tx

filetype = 'ASC'

IMPORTING

filelength = w_filelength_pd

TABLES

data_tab = t_data_in

EXCEPTIONS

file_open_error = 1

file_read_error = 2

no_batch = 3

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = l_f_fname

filetype = 'ASC'

TABLES

data_tab = itab[]

Thanks .