ALV Grid Export Function

[Former Member]

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.

[Former Member]

Hi,

when building the field catalog table,

append this parameter also.

i. e IT_FIELCAT-NO_CONVEXT = 'X'.

Hope this will help you.

[Laxmana_Appana_]

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

[Former Member]

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