Skip to Content
avatar image
Former Member

web dynpro for abap about excel

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 )

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 05, 2015 at 05:17 AM

    Hi,

    What exactly your problem.

    Regards,
    Rajesh K

    Add comment
    10|10000 characters needed characters exceeded

    • 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 )

  • Jan 28, 2015 at 12:47 PM

    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 - Flexible MS Excel documents with ABAP/4

    Best wishes,
    Valeriy.

    Add comment
    10|10000 characters needed characters exceeded