How to export table values to excel in WebDynpro

Create a button named ‘Export to excel’.

Define an action to your button.

Result:

Click here to see full code.

How to upload an excel file into SAP internal tables

Excel file

 

Selection-Screen

 

Parameter to get excel file destination.

 

Result:

 

 

Codes:

 

** Job: Upload from excel into internal table..

report  zfile_upload_from_excel.

type-pools truxs.

parameter p_excel type rlgrap–filename

               default ‘C:\EXCEL_EXAMPLE.xls’

            obligatory.

* Excel Structure

types: begin of itab,

       val1 type string,

       val2 type string,

       val3 type string,

       end of itab.

data : lt_itab type standard table of itab,

       ls_itab type itab,

       it_type type truxs_t_text_data.

* Getting Excel File Destination

at selection-screen 

   on value-request for p_excel.

call function ‘F4_FILENAME’

 exporting

  field_name    = ‘P_EXCEL’

 importing

  file_name     = p_excel.

start-of-selection.

* Converting Excel File

call function ‘TEXT_CONVERT_XLS_TO_SAP’

 exporting

  i_tab_raw_data       = it_type

  i_filename           = p_excel

 tables

  i_tab_converted_data = lt_itab[].

end-of-selection.

loop at lt_itab into ls_itab.

  write:/ ls_itab–val1.

  write space.

  write ls_itab–val2.

  write space.

  write ls_itab–val3.

endloop.

How to make an multi-sheet excel file with SAP ABAP

Result:

 

Two sheets excel example.

Sheet1.

Sheet2.

Codes:

report  zanil.

*** Job: OLE Excel from SAP

***      with two sheets

**  Include objects

include: ole2incl.

**  Table definitions

tables:  m_mbmps,

         zperlist1,

         zperlist2.

** Macro Definition

define ole_check_error.

  if &1 ne 0.

    message e000 with &1.

    exit.

  endif.

end–of–definition.

endif.

call method of h_excel  ‘Workbooks’ = h_mapl.

---

Click here for the full code

---

Program to view user roles and transaction on ALV and Excel

Selection-Screen

 

 

Codes:

 

report  zanil.

* Job: User Roles and Role Assignees

*      report in ALV and EXCEL format

type–pools: slis.

tables: agr_users,

        usr21,

        usr02,

        adrp,

        indx.

* ALV Data

data : gls_grid_header type slis_t_listheader

       with header line,

       gls_events      type slis_t_event,

       gs_fieldcat_t   type slis_t_fieldcat_alv,

       gs_fieldcat_wa  type slis_fieldcat_alv,

       gs_layout       type slis_layout_alv.

* General User Info Table

data : begin of uinfo occurs 100,

 bname      like usr21–bname,

 persnumber like usr21–persnumber,

 addrnumber like usr21–addrnumber,

 name_first like adrp–name_first,

 name_last  like adrp–name_last,

end of uinfo. 

---

Click here to download full code

---