Excel columns out of order

[Former Member]

Hello,

I have an alv grid that shows some information and when i have to export that information to an excel file, in that file the columns doesn't appear in the same order than in the alv.

Do you know what does it happen?

Thanks

[former_member194669]

Please try to fill up field catalog COL_POS in proper order and try

a®

[Former Member]

Hi,

When you export an ALV to excel, it will be exported as your initial field catalog was, so try to modify the ALV as needed, for instance COL_POS, nad give the correct order, and then export again.

Bye

gabriel p.-

[Former Member]

If you download the data from internal table it takes the order of internal table and

if you download the data from alv then it takes the order of field catalog.

Regards,

Lalit Mohan Gupta.

[Former Member]

Hello again,

i have checked my fieldcatalog and my internal table and both have the same order, with the description field in the last position.

Curiously, when i export the alv to an excel file, the description column doesn't appear in the last position, the amount field (decimal) appears in that position.

could anyone help me?

[Former Member]

Hallo,

Pls order ur structure

TYPES: BEGIN OF TY_HEAD,

F1(10) TYPE C,

F2(15) TYPE C,

F3(15) TYPE C,

END OF TY_HEAD.

Regards,

Mani