Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

abap2xlsx is a complete library for the creation of professional Excel (XLSX) from scratch.

Community project is shared on GITHub www.plinky.it/abap/abap2xlsx.php and it is licensed under the Apache License, Version 2.0 

Read the presentation blog to the community abap2xlsx - Generate your professional Excel spreadsheet from ABAP

What are the business advantages?

What are the technical advantages?

Official blogs:

For any issue or question related to the framework please use https://github.com/ivanfemia/abap2xlsx/issues

41 Comments

  1. After importing the transport files:

    None of the demos are running: implementations missing:

    An exception occurred that is explained in detail below.
    The exception, which is assigned to class 'CX_SY_DYN_CALL_ILLEGAL_METHOD', was
     not caught in
    procedure "CONSTRUCTOR" "(METHOD)", nor was it propagated by a RAISING clause.
    Since the caller of the procedure could not have anticipated that the
    exception would occur, the current program is terminated.
    The reason for the exception is:
    It was tried to call a not-implemented method
     "ZIF_EXCEL_SHEET_PROTECTION~INITIALIZE" in the class "ZCL_EXCEL_WORKSHEET".

    Best regards,

    Stefan 


  2. Guest

    Hello Stefan,

    i had the same problem.

    I implemented the method in  ZCL_EXCEL_WORKSHEET as an empty method.

    now the examples are working.

    I think there will be a fix with the correct implementation in a view days.

    regards

    joachim 

  3. Hi All ,

    I Have succesfully converted my reports to xlsx, but now my problem is i want to use merge cells functionality which is not supporting in my older version,now i want to download abap2xlsx nudd file but i am not getting newer version of that file & also suggest how implement merge cells in xlsx

  4. Guest

    Hi,

    I have succesfully installed abap2xlsx .   But  when I want to open the generated .xlsx  files to popups occurs :

    •   Excel found unreadable content in 'XXXX. xlsx' .  Do you want to recover the contents of this workbooj ?  If you trust the source if this workbook , click Yes.
    •   Repairs   to 'XXXX.xlsx'    ... Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.    [Close]

    Probably those are Excel - issues .   How can those popups be avoided ?

    regards

    Jan

  5. Hi Jan,

    can you please open an issue also providing if possible the report you're using to create the XLSX file and the created XLSX. Are you able to open the content created by the Demo reports without errors?

    Best regards
    Gregor

  6. Guest

    Hi.

    I can't download sap link file of abap2xlsx from SAP Code Exchange.

    It says

    Code Exchange Terms of Use

    You have already accepted the Code Exchange Terms of Use and your request is being processed.
    You can download them here for your reference.

    Best regards.

  7. Guest

    Please use the code exchange platform for comments or issue.

    @Frank please do not cross post. You have to forward your request to SAP Code Exchange Team, we cannot do nothing with the code exchange TOU related error.

  8. Guest

    My installation is missing class ZCL_EXCEL where I can get this class. I can activate ZCL_CHTMLB_TAB_EXCEL_EXPORT class.

    Please let me know.

  9. Dear Ian,

    please try to install the latest build or stable version from the project homepage at https://cw.sdn.sap.com/cw/groups/abap2xlsx and if it still fails let us know in the project discussion forum.

    Best regards

    Gregor

  10. Hi team,

    I have a problem with the code in background.

    My Program does not work in background but the same code works in fore ground. Could you please help me if there are any setting for the same.

     

    Regards

    Prasanth Kasturi

  11. Dear Prasanth,

    unfortunately we don't have a crystall ball to analyze your problem. Please describe it in more detail and especially let us know if it is abap2xlsx related. Have you based your code on one of the examples?

    Best regards
    Gregor

    1. Hi Gregor,

      Good one (smile).. 

      It is related to ABAP2XLSX.

      The below is the report program. When I check the data placed in the application server I find some garbage values. This is the same way I placed my code in app server in background mode but with the difference that I used  the below code as my excel comprises of tables.

            lo_worksheet->bind_tableip_table          <fs_history_data>
                                      is_table_settings ls_table_settings
                                      it_field_catalog  lt_fieldcat ).

       

      REPORT  zdemo_excel25.

      DATAlo_excel                TYPE REF TO zcl_excel,
            lo_excel_writer         TYPE REF TO zif_excel_writer,
            lo_worksheet            TYPE REF TO zcl_excel_worksheet.

      DATAlv_file                 TYPE xstring.

      CONSTANTSlv_file_name TYPE string VALUE '25_HelloWorld.xlsx'.
      DATAlv_default_file_name TYPE string.

      CALL FUNCTION 'FILE_GET_NAME_USING_PATH'
        EXPORTING
          logical_path        'LOCAL_TEMPORARY_FILES'  " Logical path'
          file_name           lv_file_name    " File name
        IMPORTING
          file_name_with_path lv_default_file_name.    " File name with path
      " Creates active sheet
      CREATE OBJECT lo_excel.

      " Get active sheet
      lo_worksheet lo_excel->get_active_worksheet).
      lo_worksheet->set_titleip_title 'Sheet1' ).
      lo_worksheet->set_cellip_column 'B' ip_row ip_value 'Hello world' ).

      CREATE OBJECT lo_excel_writer TYPE zcl_excel_writer_2007.
      lv_file lo_excel_writer->write_filelo_excel ).

      OPEN DATASET lv_default_file_name FOR OUTPUT IN BINARY MODE.
      TRANSFER lv_file  TO lv_default_file_name.
      CLOSE DATASET lv_default_file_name.

  12. Hi,  First, the project is excellent.  I'm trying to password protect a workbook.  I have looked at the examples in  ZDEMO_EXCEL17,  ZDEMO_EXCEL18.   The sheet protection works great, but I am not able to get the workbook protection functioning.  In Excel 2010,  I am not getting the window to enter a password to read the file.  Maybe I'm not using the class corectly.  Please any suggestions?

    lo_excel->zif_excel_book_protection~protected = zif_excel_book_protection=>c_protected.

    lo_excel->zif_excel_book_protection~workbookpassword = zcl_excel_common=>encrypt_password( p_pwd ).

    1. Hi Cindi,

      the functionality is not an OOXML standard, but it is an MS Excel native implementation.

      abap2xlsx aims to fully support only OOXML functionalities... 

      Best

      Ivan

  13. EDIT: Problem solved by reinstalling nugget.

    --------------------------------------

    I have downloaded and installed the latest version of ABAB2XLSX (V 7).

    Installation was quite a hassle but finally and a few short dumps later I managed it. Now, when running the demos, there are only zero-bytes files generated. While debugging DEMO1  I see that lo_worksheet is created and filled with data. But when I debug the statement lcl_output=>outputlo_excel ) I can't find any data of the worksheet. It seems like it gets lost somewhere.

    This effect applies to all demos. Any idea? Many thanks in advance

    Karl

  14. It is best to get SAPlink-plugins_Daily.nugg (12th May 2013) SAPlink_Daily.nugg  (both 31 Jan 2014)
    from  https://code.sdn.sap.com/code/saplink-plugins/subversion/node/blob/build/SAPlink-plugins_Daily.nugg.zip 
    and  other 2 from SVN of https://sap.assembla.com/code/saplink/subversion/nodes# 

    However we have NW 701 and hit 2 problems with syntax errors in
    ZCL_EXCEL_WRITER_XLSM and ZCL_EXCEL_READER_HUGE_FILE
    1st got solved by https://sap.assembla.com/spaces/abap2xlsx/messages/3282273 

    ZCL_EXCEL_READER_HUGE_FILE has 2 "huge" problemsfor NW 701 folks like me

    1. This syntax not 701 version
      error = |Entry { iv_index } not found in Style Table|.
    2. cl_abap_codepage  class is not there in NW701 

     ZCL_EXCEL_READER_HUGE_FILE is perhaps new and incompatible to 701 

    So in the end everything is fie & working apart for the class  ZCL_EXCEL_READER_HUGE_FILE
    which may not needed by me

    Regards
    Jayanta Choudhuri
    Kolkata India 

     



  15. Hi Jayanta,

    please refer to GITHub for question https://github.com/ivanfemia/abap2xlsx.

    ZCL_EXCEL_READER_HUGE_FILE is not a core file and can be deleted if you don't need the functionality.

    Best

    Ivan

     

  16. Hi,

    I know i'm 1 year late. I am using ZCL_EXCEL now to download invoices from SAP to local directory. When I test my program using only 3-10 invoices, i am not encountering the error 'Excel was able to open the file by reparing or removing the unreadable content'. But when I tried 500 or more, i am encountering the error and the excel file does not have any entry.

    My program will create an excel file with 4 sheets. In my program i used SET_TABLE method instead of SET_CELL since i do not need any formatting.

    Any help would be appreciated.

    Thanks,

    Isaac

     

  17. Hi Isaac,

    please open a discussion in SCN http://scn.sap.com/community/open-source so someone can assist you easily.

    Thank you

    Ivan

  18. Hi Evan,

     

    Whenever i execute your program iam getting an error message, Please help me to avoid this message.

    "Excel found unreadable content in '~ SAP{B42E6958-3FA4-4423-9f59}.xlsx'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.

    Thanks ,

    Sanjay D

     

    1. Dear Sanjay,

      please report problems with as much detail as possible at https://github.com/ivanfemia/abap2xlsx/issues.

      Best regards
      Gregor 

  19. DEMOs  are all empty?

    I have installed and activated all the objects on the  latest nugget build successful  but all my demos are empty..

    I reinstall the nugget again but still same issue.

    why are demos all empty? where can I find the souce code for the,?

     

  20. Please report issues via the link you see in my post above.

    1. Hey Greg,

      looks like the weblink you provided is down..

      https://code.sdn.sap.com/spaces/abap2xlsx/tickets/custom_report/1

       

       

      1. I ment my post. But thank you for pointing out that the Wiki page needs also an update. Please post issues here.

        1. Thanks Greg, I have opened an issue.

          https://github.com/ivanfemia/abap2xlsx/issues/449

           

          thanks

           

           

  21. How do I convert this excel in pdf?

    1. It depends on your landscape. PDF conversion is not a functionality of abap2xlsx.

      For more details or support I would suggest to post on SCN a general ABAP question for PDF conversion

      Ivan

  22. Hello Ivan,

    Above are the links are not working. I have an excel formatted template in OAOR(with colors etc), I would like to manipulate this template using ABAP and send an email using this template as an attachment. And would like to do this in Background. Can you please suggest me with any sample program or any process how to achieve this?

    1. Dear Saleem,

      I've updated the links. Please try again.

      Best regards
      Gregor 

    2. Saleem any example as the possibility to send the excel generated as email attachment.

      Demo15 is an example for reading an excel and writing it back.

      Ivan

      1. Hi Ivan,

        Thanks for your reply.


        Can you please suggest or provide any demo program how to send an formatted excel(OAOR) in background? Seems that Demo15 doesn't meet my requirement.

        Thanks,

        Saleem.

        1. Any demo as the functionality to send an excel in an email, so you can easily check the code.

          Ivan

  23. Hi Ivan,

    I tried to import the nugget ABAP2XLSX_V_7_0_6 and the log shows that the objects are installed successfully, but when I see the objects they doesn't actually exist. They even doesn't exists in Inactive Version. Please find the below log of the report. I want to have all the excel demo programs/Classes and Interfaces in my system so that I can check with report would be helpful for my requirement(Excel with email attachment in background). Can you please do the needful in solving my issue.

    PROG ZDEMO_EXCEL1

     PROG ZDEMO_EXCEL10

     PROG ZDEMO_EXCEL11

    PROG ZDEMO_EXCEL12

    PROG ZDEMO_EXCEL13

     PROG ZDEMO_EXCEL14

    PROG ZDEMO_EXCEL15 already exists. Use overwrite orginals option to replace

    PROG ZDEMO_EXCEL16

    PROG ZDEMO_EXCEL29

    PROG ZDEMO_EXCEL28

    PROG ZDEMO_EXCEL27

    PROG ZDEMO_EXCEL26 PROG

     ZDEMO_EXCEL25 PROG

     ZDEMO_EXCEL24 PROG

     ZDEMO_EXCEL23 PROG ZDEMO_EXCEL17 PROG ZDEMO_EXCEL18 PROG ZDEMO_EXCEL19 PROG ZDEMO_EXCEL2 PROG ZDEMO_EXCEL22 PROG ZDEMO_EXCEL21 PROG ZDEMO_EXCEL20 PROG ZDEMO_EXCEL42 PROG ZDEMO_TECHED9 PROG ZDEMO_EXCEL3 PROG ZDEMO_EXCEL30 PROG ZDEMO_EXCEL31 PROG ZDEMO_EXCEL32 PROG ZDEMO_EXCEL33 PROG ZDEMO_EXCEL34 PROG ZDEMO_EXCEL35 PROG ZDEMO_EXCEL36 PROG ZDEMO_EXCEL37

     

    Thanks,

    Saleem.

  24. I'm able to upload all the programs. 

    Thanks for your help. 

  25. hi folks, 

    many thanks for this, it is a real help in a daily life of a consultant.

    There are now XLSB files in Excel possible, unfortunate far away from XML. Is there a chance to get those loaded via ABAP as well?

    Best Regards and many thanks for this, Thomas

     

    1. Hi Thomas,

      xlsb is an Excel Binary Workbook and is not supported via abap2xlsx.

      Ivan

  26. Hello,

    We upgraded MS Office in December. Now each time we access an Excel-file from SAPGui/vis SAP, users get a popup-warning "Excel cannot open the file '*.xlsx' because the file format or file extension is not valid". Not critical, but extremely annoying.

    The files are correct XLSX-files: If we open them directly from Excel, we don't get any popup-warnings.

    Workaround:
    Microsoft recommends to keep this security check on. Switching it off is currently no option.

    Note:
    We face this problem both when accessing XLSX-files via SAP:s OLE-function modules and via ABAP2XLSX-classes.

    As you are experts om this area:
    Is there an elegant way to get MS Excel to not complain any more?
    Or should I raise a SAP-ticket and wait for a solution from SAP?

    I appreciate any hints - thank you in advance (smile)
    / Ulrich

     

  27. Hi Friends,

    After installed all Abap2xlsx pack everything run fine but my "special" client request for the files in XLS format and not XLSX. The problem with XLS format is that after it's created a  warning excel pop-up is display with  "format and extension are no the same....."  ¿it's possible save it as XLS format without this pop-up?

     

    I appreciate a lot your helpfully comment or suggestions.

    Xlton

    1. Dear Elton,

      abap2xlsx does not support XLS. It is a binary format. Ask your client to pay for the development and you're welcome to enhance abap2xlsx. But can your special client give a reason why XLS is needed instead of XLSX?

      Best regards
      Gregor

      1. Thanks you!!

        Best regards

        Elton