Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Excel icon on ALV

Former Member

‎08-30-2007 8:22 PM

0 Kudos

Hi all,

Can anyone tell me how to get MicroSoft excel icon for OO ALV

call method g_grid->set_table_for_first_display

  • exporting

  • I_BYPASSING_BUFFER =

  • I_BUFFER_ACTIVE =

  • I_CONSISTENCY_CHECK =

  • I_STRUCTURE_NAME =

  • IS_VARIANT =

  • I_SAVE =

  • I_DEFAULT = 'X'

  • is_layout = g_layout

  • IS_PRINT =

  • IT_SPECIAL_GROUPS =

  • IT_TOOLBAR_EXCLUDING =

  • IT_HYPERLINK =

  • IT_ALV_GRAPHICS =

changing

it_outtab = itab1

it_fieldcatalog = fieldcat

  • IT_SORT =

  • IT_FILTER =

exceptions

invalid_parameter_combination = 1

program_error = 2

too_many_lines = 3

others = 4

.

endif.

Do i need to copy gui status . If yes let me know what gui Status i need to copy from and i want the action to be performed by itself

Thanks

3 REPLIES 3

former_member194669
Active Contributor

‎08-30-2007 8:27 PM

0 Kudos

Hi,

You need to pass the following values in set_table_first_display



    gs_layout-sel_mode      = c_a.
    gs_layout-cwidth_opt    = c_x.
    gs_variant-report       = sy-repid.

    call method grid1->set_table_for_first_display
      exporting
        is_layout                     = gs_layout
        is_variant                    = gs_variant
        i_save                        = 'A'
      changing
        it_outtab                     = i_output[]
        it_fieldcatalog               = i_fieldcat[]
      exceptions
        invalid_parameter_combination = 1
        program_error                 = 2
        too_many_lines                = 3
        others                        = 4.

You can see the Excel inplace toolbar button the ALV toolbar

aRs

Former Member
In response to former_member194669

‎08-30-2007 8:48 PM

0 Kudos

Hi ,

I did exactly as you said . I still don't see the Microsoft Icon

g_layout-sel_mode = 'A'.

g_layout-cwidth_opt = 'X'.

g_variant-report = sy-repid.

call method g_grid->set_table_for_first_display

exporting

is_layout = g_layout

is_variant = g_variant

i_save = 'A'

changing

it_outtab = itab1

it_fieldcatalog = fieldcat

  • IT_SORT =

  • IT_FILTER =

exceptions

invalid_parameter_combination = 1

program_error = 2

too_many_lines = 3

others = 4

.

endif.

I have the export icon from there i can download and open again with excel sg=heet

But i need the excel icon directly . LET ME KNOW WHETHER ITS POSSIBLE OR NOT

Thanks

Former Member

‎08-30-2007 9:50 PM

0 Kudos

Hi,

Do you see 'Views' icon (next to Printer icon) in the application toolbar.

Click on that, you will get Excel Inplace as one of the options.

Cheers,

Vikram

Reward for helpful replies!!