update data into excel

[Former Member]

Hi Friends..

I am using gui_download function module for transfer the data from internal table to excel sheet.

whenever I am executing the program it appends the data into excel sheet perfectly.

My question id I need to insert the heading in first row..how can i do that?

Thanks in advance

Gowrishankar

[Former Member]

Hi,

Assume this is your final internal table.

DATA : BEGIN OF ITAB OCCURS 0,

field1 (20),

field2(20),

END OF ITAB.

After appending all records to final internal table write like below.

MOVE : 'NAME' TO ITAB-field1,

'NUMBER' TO ITAB-field2.

INSERT ITAB INDEX 1.

now GUI_DOWNLOAD.......

[Former Member]

Hi Murali..

Thanks For your reply..

my question is..

my itab having the integer values..

whenever I am executing my program it stores the data into excel sheet one by one ..

for that I am using the function module gui_download.

my requirment is..

i need to give the heading for all the columns.

your answer is ok.if itab having all the value.

for my question itab generate different values in different time.

so i cant move all the datas into itab.

periodically my program generate the values and store it into

excel.

I need to give heading for that each column.

Thanks

Gowrishankar