Problem in exporting ALV Layout to excelsheet!!!

[Former Member]

Hi,

I am facing a problem while trying to export an ALV layout to Excel sheet. While the values appear correctly, the order of the columns gets distorted. So the table in Excel appears with correct values but with columns in disarray. I have checked the settings of Excel (SECURITY LEVEL is Medium and TRUSTED SOURCES "Trust All Installed Add-Ins and Templates" and "Trust Access to Visual Basic Project" is checked.) and its doesn’t seem to be change anything.

Any suggestions?

[Former Member]

Hi,

The same problem I also faced. Tried at that time but i didnt get it.

I think there is no any options for that.

Thanks.

[Former Member]

Think it could be solved only.. by BASIS, as v met with the same problem once..

[former_member188685]

Hi,

Try with Local File->Spread Sheet=> option.

Regards

vijay

[Former Member]

Hi Arpit,

u can do this way...

Go to List->Export->Spreadsheet

or else u can use 'get_frontend_fieldcatalog' to capture current layout and pass it to excel.

regards,

Kiran B

[laxmanakumar_appana]

Hi,

Follow the below procedures to export data to excel.

Normal ALV :

Click on the local file option and select spreadsheet option from the radio button list and click on ok , file save window will open , select the correct directory path and give the file name , then ALV contents will be downloaded into Excel sheet.

In OO ALV :

click on the Export button in the ALV toolbar ->click on the spreadsheet , then information message window will open , select ok button , then you will get three options , click on the table option and press ok , data will be exported to Excel sheet , then save the excel data in specified directory.

Regards

Appana