topic ALV Grid Export Function in Application Development and Automation Discussions

ALV Grid Export Function

Former Member — Fri, 07 Jul 2006 08:33:13 GMT

Hi,

I am facing a problem while downloading the data from ALV grid to spreedsheet using the following steps:

Export --> Spread Sheet --> Table --> Microsoft Excel

(i want to use only this method for exporting)

Now when i download the data some of the columns are not comming in the proper sequence. Is this a configuration problem or i have to make some settings or some thing like that.

When i download it through local file its is coming properly.

Please suggest.

Thanks,

Rajat.

Re: ALV Grid Export Function

Former Member — Fri, 07 Jul 2006 08:39:10 GMT

Hi,

when building the field catalog table,

append this parameter also.

i. e IT_FIELCAT-NO_CONVEXT = 'X'.

Hope this will help you.

Re: ALV Grid Export Function

Laxmana_Appana_ — Fri, 07 Jul 2006 08:45:39 GMT

Hi,

Set the 'COL_POS' field of the feild catelog to each and every column and check.

data is downloaded into excel depending on the field catelog order.

Regards

Laxman

Re: ALV Grid Export Function

Former Member — Fri, 07 Jul 2006 08:46:11 GMT

Hi Rajat,

this is the known problem with the EXCEL it alters the sequences of columns depending on the data type i.e numerics,char.

Regards

vijay