topic Re: Function module for excel file in Application Development and Automation Discussions

Function module for excel file

Former Member — Thu, 14 Feb 2008 11:51:33 GMT

Please tell me

Is there any frunction module so that First record in the Output internal table should br populated in the 4th

row of the excel file

Thanks and regards

Ajay

Re: Function module for excel file

Former Member — Thu, 14 Feb 2008 11:53:06 GMT

Hello,

You can use the FM GUI_DOWNLOAD.

Just add four blank lines in ur itab.

Cheers,

Vasanth

Re: Function module for excel file

Former Member — Thu, 14 Feb 2008 11:54:55 GMT

there is no such function module.

u can do like this.....

before populating ur internal table ..

do 4 times.

append is_tab to it_tab.

enddo.

now u insert ur records into ur internal table.

use FM: gui_download.

Regards.............................

Re: Function module for excel file

Former Member — Thu, 14 Feb 2008 11:56:11 GMT

DATA: i_file like rlgrap-filename value '/usr/sap/tmp/file.txt'.

DATA: begin of it_datatab occurs 0,

row(500) type c,

end of it_datatab.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = i_file

filetype = 'ASC'

TABLES

data_tab = it_datatab "ITBL_IN_RECORD[]

EXCEPTIONS

file_open_error = 1

OTHERS = 2.

<REMOVED BY MODERATOR>

Jay

Edited by: Alvaro Tejada Galindo on Feb 14, 2008 11:13 AM

Re: Function module for excel file

Former Member — Thu, 14 Feb 2008 16:26:09 GMT

there is no such Function module there.

But you can do one thing .

you cna write code as:

do 4 times.

append initial lines to itab.

enddo.

then you can use ur internal table to GUI_Download FM .

If you are uploading data from Excel file there , there is a FM

ALSM_EXCEL_TO_INTERNAL_TABLE

With this FM you can specify from which row and which column your data will be read from file.

Hope this will help you