topic Re: Problem in down loading data to Excel sheet in Application Development and Automation Discussions

Problem in down loading data to Excel sheet

Former Member — Tue, 09 Jan 2007 10:01:46 GMT

Hi all

I have to down load the certain fields in to EXCEL sheet.

i need to download the FIELD HEADING ALSO down load dynamically.

its not hard coding in the function module.

please let me know how to do it?

Re: Problem in down loading data to Excel sheet

anversha_s — Tue, 09 Jan 2007 10:03:32 GMT

hi,

1) first download the headings only to the excel sheet.

2) then download the data to the same excel sheet.

Regards

anver

Re: Problem in down loading data to Excel sheet

former_member188829 — Tue, 09 Jan 2007 10:03:53 GMT

use FM:gui_download

Re: Problem in down loading data to Excel sheet

Former Member — Tue, 09 Jan 2007 10:06:18 GMT

Hi,

Store the final data you want to download in a seperate internal table say gt_tab1 having all filed type as string.

Now insert the table heading in each column as required in index 1 i.e first row of gt_tab1.

Download gt_tab1 .

Thanks,

Sutapa.

Re: Problem in down loading data to Excel sheet

anversha_s — Tue, 09 Jan 2007 10:12:15 GMT

hi,

as i mentioned above, look this

Use that FM GUI_DOWNLOAD twice:

First time download only header

Second time append table contents to the same file (import parameter append = 'X')

egx:

or example if your itab used for writing the abap list is like below.

data: begin of details occurs 0 ,

customer type kna1-kunnr,

name type kna1-name1 ,

end of details.

declare another internal table.

data: begin of headers occurs 0 ,

customer(100) ,

name(100),

end of headers.

move: '010101' to headers-customer ,

'Anver' to headers-name .

append headers.

now call GUI_download to download headers to filename c:/tem.xls

again call gui_download with APPEND = 'X' to the same file name and download details itab

Regards

Anver