download to excel from alv display

[Former Member]

Hi,

How to download to excel from alv display.I am using object oriented abap for using alv.If i click export->spreadsheet i am getting fatal error and if i export->local file->spreadsheet i am getting only the column names and heading but no contents.Can anyone tell me how to overcome this problem.

Regards,

Sowmya.

[Pawan_Kesari]

i think there might be some problem with fieldcatelog. check if it is filled correctly..

[Former Member]

hi check this..

did you see the content in the alv..means there is data on the alv output..

[Former Member]

Hi,

Yes there is output in the alv but it is not getting displayed in the excel.Do you know what might be the problem.

Regards,

Sowmya.

[Former Member]

hi

once see that all the fields in the field catalog are given in capitals..

[Former Member]

Hi Sowmya,

Check field names in the field catalog.

Regards,

Charumathi.B

[Former Member]

I had this problem. It was happening with me because I have a table with a field that was a structure. So, verify the field catalog and the names is a very good approach

[former_member213851]

Hi Sowmya,

Just put break point near FM reuse_alv_grid_display and check if internal table which is used to display output is popullated or not.

Regards Sachin.