OOPS ALV export to Excel

[Former Member]

Hi Experts,

I am in need to download the ALV Grid displayed data which is displayed using OOPS ALV,

The standard export to excel functionality is downloading data to the excel without any sequence and data seemed put

randomly anything.

Could you please help me out to get data in proper manner with columns and respective data.

Is there any alternate way to achieve standard export to excel functionality.

Thanks in advance

[surajarafath]

This may be due to the displayed field lenght for each field.

You may have defined your output fieldlenght in the fieldcat for fields, this lenght will not be same as your data type.

So define your data type so that output length and data type length should match. then excel output will come properly.

[Former Member]

Better idea is just to put a push button for DOWNLOAD and download that internal table into a excel. This option will give you much more appropriate solution...

Also search on use of function module "XXL_SIMPLE_API" .... to download the data to excel....

[ThomasZloch]

What is the problem with the standard Excel Inplace functionality? Please describe the symptoms in more detail, "without any sequence" and "seemed put randomly anything" sounds quite vague.

Thomas