topic Re: Export to Excel in Application Development and Automation Discussions

Export to Excel

Former Member — Wed, 20 Jun 2007 13:39:13 GMT

Dear Experts,

When I export the output of ALV grid to excel using the option from the application tool bar of the ALV and also using the SPREAD SHEET option and not using LOCAL FILE, then three columns of the list are moved to the last in the excel sheet.

Kindly let me know why this happens and help me to rectify the same.

Thanks in advance.

Arunkumar Sankaran

Re: Export to Excel

Former Member — Wed, 20 Jun 2007 13:54:17 GMT

Hi Arunkumar,

To download the data correctly, follow the stps below:

Run your ALV report.

Follow the Menu options LIST > EXPORT > SPREAD SHEET > TABLE > MICROSOFT EXCEL.

This will probably solve your problem.

Reward points if helpful please.

Regards

Re: Export to Excel

Simha_ — Wed, 20 Jun 2007 13:57:33 GMT

Hi,

Just check the order in the field catalog these fields are ?

Then try to download by using spread sheet option..

Cheers,

Simha.