ABAP WebDynpro Table to Excel

Here’s a clean way to download your WD Table to Excel (Without Getting the Error:  “The file you are trying to open , ‘filename.xls’, is in a different format than

specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now? “”).

Create the following code in a method:

method wd_download_table_to_excel.
******************************************************************************************************************
*Purpose:  Accept any table and and sends to Excel from ABAP WebDynpro
******************************************************************************************************************
  data: lv_xstring type xstring.
  data: lv_mime_type type w3conttype.
  data: lv_mime_type_string type string.
  data: ref_data type ref to data.

  get reference of lt_tbl into ref_data.

  call function ‘SDOK_MIMETYPE_GET’
    exporting
      extension = ‘xlsx’
    importing
      mimetype  = lv_mime_type.

  lv_mime_type_string = lv_mime_type.

  cl_fdt_xl_spreadsheet=>if_fdt_doc_spreadsheet~create_document( exporting itab = ref_data iv_call_type = 1 columns = lt_column receiving xdocument = lv_xstring ).
  cl_wd_runtime_services=>attach_file_to_response( exporting i_filename = i_filename i_content = lv_xstring i_mime_type = lv_mime_type_string i_in_new_window = abap_false ).

endmethod.

Image of Method Below: