Skip to Content

Yes, finally we reached the next level!

abap2xlsx is close to its first birthday and we are celebrating our 100th member on the project. 

On Friday May 13th, 2011 (it is not a bad day) we reached the goal of 100th members and we would like to have fun publishing the new stable release of abap2xlsx: Release 4.0.

What is new on this release?

 

  • Manage all type of data validation
  • Worksheet gridlines on/off
  • Add images from MIME repository
  • Add support to other coloring options
  • Add support to hidden sheets
  • Add support to sheet hide zeros property
  • Reader reads styles
  • Diagonal border
  • Demo reports collection improvements
  • Many code improvements
  • Bug fixing

One of the greatest new feature is the improvement of the reader (xlsx2abap), now you can import not only the data but also most of the excel styles! 

Moreover the color enhancement gives you the possibility to use all the gamma color available with Excel.

Color Picker

 

As always thanks to all the SDN Contributors for their time and passion on this project, I hope than many others will join us.

Project is available on SAP Code Exchange.

 

Compatibility note: we always tried to maintain the back compatibility but in this realease we had to change the managing of the color setting; if you install this release you have to adapt your existing project. This is a really easy task, all the functionalities are shown in demo reports.

 

Related blog:

To report this post you need to login first.

10 Comments

You must be Logged on to comment or reply to a post.

  1. Guillaume GARCIA
    Hi,
    What an amazing addition to the ABAP toolbox!
    Many thanks for the team and its members.
    PS : is the coloring support works under MsExcel 2003 (and its awful color palette…)?

    Best regards,
    Guillaume

    (0) 
  2. Gabriel Paolo Isidro

    Hi,

    I’ve been using this amazing tool for a couple years now but now i have a requirement to password protect the workbook…

    Sheet protect works, but password for the whole workbook doesn’t, i have tried to edit ZEXCEL_DEMO18 too to put the password but still no luck…

    I have read somewhere in SCN that workbook protect is not possible.. is it really not possible?

    As my requirement is to generate excel on background and password protect it.

    Thank you

    -Gabby

    (0) 
  3. Sharath Yaralkattimath

    Congrats team! I have used the older versions & it is great. Does the new version support Excel 2013? I tried to access the project on SAP Code exchange, but I got the message as “Access to this place or content is restricted. If you think this is a mistake, please contact your administrator or the person who directed you here.” Is is not accessible to everyone?

    Thanks,

    Sharath

    (0) 

Leave a Reply