Display ALV GRID output in Excel Form

[Former Member]

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.

[Former Member]

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?

[Former Member]

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.

[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

[raymond_giuseppi]

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

[Former Member]

You can use Shift+cntrl+F7

[Former Member]

This message was moderated.

[ilyass]

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

Regards,

Choulli.

[former_member182888]

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