Skip to Content
avatar image
Former Member

Display ALV GRID output in Excel Form

Dear Friends ,

As i want to know , is there is any possibility to display ALV Grid output in Excel form instead of ALV Grid design.

Exactly like the below Screen shot.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Jan 08, 2015 at 09:01 AM

    Hi,

    do I understand correctly, you do not want to use the download functionality from the ALV to download to excel? You do not want the ALV grid at all?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2015 at 09:13 AM

    you can open a report as excel without displaying in alv using the below code:

    CALL METHOD cl_gui_frontend_services=>execute

           EXPORTING

             document               = c_file

             operation              = 'OPEN'

           EXCEPTIONS

             cntl_error             = 1

             error_no_gui           = 2

             bad_parameter          = 3

             file_not_found         = 4

             path_not_found         = 5

             file_extension_unknown = 6

             error_execute_failed   = 7

             synchronous_failed     = 8

             not_supported_by_gui   = 9

             others                 = 10.

         IF sy-subrc <> 0.

    * Do Nothing

         ENDIF.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

      You need DOI tech. Just check this standard program 'SAPRDEMO_DOI_BDS', after you execute,click 'Create' on toolbar to create a excel table.

      regards,

      Archer

  • Jan 08, 2015 at 09:43 AM

    From ALV click the "Change Layout" icon, then go to tab "view" and in field "Preferred View" select "E Excel", select a template. You could then save this in a variant or debug to analyze current layout definition used by ALV.

    Ref: 548409 - ALV view: Consulting note about Integrated Excel & templates

    Regards,
    Raymond

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2015 at 12:18 PM

    You can use Shift+cntrl+F7

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 08, 2015 at 01:21 PM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2015 at 06:08 PM

    To be able to get this result, you need to create your own dynpro screen, to getthat result you can check that url.

    Open Excel document in SAP inplace from Local PC

    Regards,

    Choulli.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12, 2015 at 01:06 PM

    Peace be upon you,

    you can Press: Microsoft Excel icon

    in Menu Views > Microsoft Excel

    or Press: Ctrl+Shift+F7

    you may be prompted with a confirmation popup from Excel

    click Allow Macros

    Hope you find this helpful

    Add comment
    10|10000 characters needed characters exceeded