topic Re: update data into excel in Application Development and Automation Discussions

update data into excel

Former Member — Mon, 24 Mar 2008 02:53:20 GMT

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 — Mon, 24 Mar 2008 02:59:56 GMT

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 — Mon, 24 Mar 2008 03:38:48 GMT

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