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

Export to Excel from ALV grid

former_member125661 — Wed, 16 Jun 2010 15:23:10 GMT

When you click on the spreadsheet option on an ALV grid, why do all the date fields move to the end on the excel sheet ? Is this a standard bug in SAP ? This happens in both custom as awell as standard SAP ALV grid. You expect the display and the columns in the excel sheet to be in sync., which isn't happening ..Whats special with the date fields ?

For eg : Export VBAP using 'Spreadsheet' ) from SE16. . In the exported excel, the ERDAT is the last field..

Also try making a custom layout with date fields and use spreadsheet option.

ALV Grid with SE16N works fine. I think SE16's grid uses REUSE FM's and SE16N uses ALV class objects..

Thanks in advance..

Edited by: Shareen Hegde on Jun 16, 2010 6:02 PM

Re: Export to Excel from ALV grid

Former Member — Wed, 16 Jun 2010 17:01:14 GMT

Doesn't happen to me...my download into excel matches my SALV layout.

Re: Export to Excel from ALV grid

former_member125661 — Wed, 16 Jun 2010 17:43:30 GMT

Breakpoint..Try to create a custom layout for your SE16 display with date fields on it and see where it is when you click on spreadsheet ..

Re: Export to Excel from ALV grid

Former Member — Wed, 16 Jun 2010 18:37:57 GMT

My apologies...you're absolutely right...have not seen this happen before (we just upgraded to NWAS 7.01).... strange indeed and it happens for both Excel in place and Excel after print preview....Amazing!