Skip to Content
Author's profile photo Philip Johnston

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’
      extension = ‘xlsx’
      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 ).


Image of Method Below:


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Christopher Solomon
      Christopher Solomon

      Nice! This bookends well with your blog that talks about "going the other way".

      Author's profile photo Abhilash Pradhan
      Abhilash Pradhan


      The excel generated has some extra sheets like decision table etc. . How to remove these ?