topic Re: OOPS ALV export to Excel in Application Development and Automation Discussions

OOPS ALV export to Excel

Former Member — Thu, 01 Mar 2012 06:37:48 GMT

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

Re: OOPS ALV export to Excel

surajarafath — Thu, 01 Mar 2012 07:06:50 GMT

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.

Re: OOPS ALV export to Excel

Former Member — Thu, 01 Mar 2012 07:34:46 GMT

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....

Re: OOPS ALV export to Excel

ThomasZloch — Thu, 01 Mar 2012 08:08:55 GMT

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