topic Re: Header with multipal lines in Application Development and Automation Discussions

Header with multipal lines

Former Member — Wed, 25 Feb 2009 05:31:04 GMT

Hi Experts,

I have created one program to download internal table to excel, In that i have added header but it,s single line, I also created header internal table with mulipal lines

e.g amount

BASiC | DA | HRA

But at the time of display ( in excel format ) it shows only first line ( i.e. amount ), i am using gui_download FM.

so please guide me regarding this.

Thanks

Vishal

Re: Header with multipal lines

vishal_sharda2 — Wed, 25 Feb 2009 08:36:57 GMT

Hi Vishal,

Can you please paste your code??

Regards,

Vishal.

Re: Header with multipal lines

Former Member — Wed, 25 Feb 2009 08:40:51 GMT

hi Vishal,

declare the internal Table without header type,

data: i_itab type standard table of ztable,

wa_ itab like line of i_itab.

With this internal tabel tyr out , it will work.

Thanks

Suraj

Re: Header with multipal lines

Former Member — Wed, 25 Feb 2009 08:50:38 GMT

Hi,

Try like this.

First send header details only to excel fiel( i.e, amount and hra, da,pf ), try like this

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = filename

FILETYPE = 'ASC'

APPEND = 'X'

WRITE_FIELD_SEPARATOR = '#'

Tables

data_tab = it_display1.

Again Call gui_download fm with line item data. When u call try like this,

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = filename

filetype = 'ASC'

append = 'X'

write_field_separator = '#'

TABLES

data_tab = it_display2

Regards,

S.Senthil