Header with multipal lines

[Former Member]

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

[vishal_sharda2]

Hi Vishal,

Can you please paste your code??

Regards,

Vishal.

[Former Member]

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

[Former Member]

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