Convert ALV to .XLSX including HEAD of ALV

[Former Member]

Hello Guru's

I have an ALV with columnheaders AND also als a header above with some info and a logo (on screen).

When i translate this to a XLSX-spreadsheet (CNTRL-SHIFT-F7). There is an .XLSX made
with data lines, column headers, BUT NO header and NO logo.

i use the good old:

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

  EXPORTING

    I_CALLBACK_PROGRAM     = GD_REPID

    I_CALLBACK_TOP_OF_PAGE = 'TOP-OF-PAGE' "see FORM

    IS_LAYOUT              = GD_LAYOUT

    IT_FIELDCAT            = FIELDCATALOG[]

    I_SAVE                 = 'X'

  TABLES

    T_OUTTAB               = IT_EKKO

  EXCEPTIONS

    PROGRAM_ERROR          = 1

    OTHERS                 = 2.

in FORM TOP-OF-PAGE

i fill some data in

FORM TOP-OF-PAGE.

*ALV Header declarations

DATA: T_HEADER TYPE SLIS_T_LISTHEADER,

fill t_header .......

and ending this form with

CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'

  EXPORTING

    IT_LIST_COMMENTARY = T_HEADER.

    I_LOGO = 'Z_LOGO'.

ENDFORM.   "TOP-OF-PAGE

Does anyone know what i have to do to get also the header into XLSX.

Thanx in advance

[Former Member]

nobody has done or has been asked to this before or knows another ALV Method to achieve this?

[SimoneMilesi]

Hello Frank,

did you already checked this?

[former_member202818]

Hi frank,

In case of LOGO standard alv button will not solve this.

You may have to have your own button and write code to achieve this.

OLE and GUI_DOWNLOAD may help you.

Regards

Sreekanth

[Former Member]

Hi Simone,

Thanx for this thread. I can find enough info in it to solve my problem. Thx.

[former_member202818]

is it working for logo too?

[Former Member]

Hi  Sreekanth,

i get no logo already.

The main issue was that i didn't get an head at all.

I get a head now with this method.
Perhaps it is possible to do it with your method. i do not know.

Maybe you can work out an example.

[former_member202818]

I have tested with log, but log is not getting in XL.

[Former Member]

Hi  Sreekanth,

Thanx for testing this.

Did you test this with your methods or with the methods described in the link of Simone?

[former_member202818]

methods described in the link of Simone