web dynpro for abap about excel

[Former Member]

HI:all

     My question about wda of excel,Now what is about the WDA EXCEL best solution ?

     I have used the follow code to implement wad of excel, But there are many problems

  DATA:
      LO_ND_FILE_DOWNLOAD TYPE REF TO IF_WD_CONTEXT_NODE,
      LREF_STRING         TYPE REF TO CL_ABAP_DATADESCR,
      LREF_DATA           TYPE REF TO DATA.

CL_FDT_XL_SPREADSHEET=>IF_FDT_DOC_SPREADSHEET~CREATE_DOCUMENT(
        EXPORTING
          ITAB                   = LREF_DATA
          IV_CALL_TYPE = 2
          COLUMNS         = LT_COLUMN
        RECEIVING
          XDOCUMENT    = LV_XSTRING ).

  CL_WD_RUNTIME_SERVICES=>ATTACH_FILE_TO_RESPONSE(
      EXPORTING I_FILENAME      = 'test.xlsx'
                            I_CONTENT       = LV_XSTRING
                           I_MIME_TYPE     = 'APPLICATION/XLSX'
                    I_IN_NEW_WINDOW = ABAP_FALSE )

[valeriy_zauzolkov2]

Hi!

You can use XSLT-transformation or, if you need images in file, you can take this idea with draft implementation and modify for your concrete purposes -

Best wishes,
Valeriy.

[rajeshkothamasu]

Hi,

What exactly your problem.

Regards,
Rajesh K

[Former Member]

   hi,

    What is the best solution for wda excel now？

     I have used the follow code to implement wda excel, But there are still many problems ,

     For example, when a large amount of data can not be exported.

  DATA:
      LO_ND_FILE_DOWNLOAD TYPE REF TO IF_WD_CONTEXT_NODE,
      LREF_STRING         TYPE REF TO CL_ABAP_DATADESCR,
      LREF_DATA           TYPE REF TO DATA.

CL_FDT_XL_SPREADSHEET=>IF_FDT_DOC_SPREADSHEET~CREATE_DOCUMENT(
        EXPORTING
          ITAB                   = LREF_DATA
          IV_CALL_TYPE = 2
          COLUMNS         = LT_COLUMN
        RECEIVING
          XDOCUMENT    = LV_XSTRING ).

  CL_WD_RUNTIME_SERVICES=>ATTACH_FILE_TO_RESPONSE(
      EXPORTING I_FILENAME      = 'test.xlsx'
                            I_CONTENT       = LV_XSTRING
                           I_MIME_TYPE     = 'APPLICATION/XLSX'
                    I_IN_NEW_WINDOW = ABAP_FALSE )