Function module for excel file

[Former Member]

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

[Former Member]

Hello,

You can use the FM GUI_DOWNLOAD.

Just add four blank lines in ur itab.

Cheers,

Vasanth

[Former Member]

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.............................

[Former Member]

Hi

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

[Former Member]

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