Skip to Content
Author's profile photo Ivan Femia

abap2xlsx team has a present for you…

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:

Assigned Tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Guillaume GARCIA
      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

      Author's profile photo Ivan Femia
      Ivan Femia
      Blog Post Author
      Hi Guillaume,

      there is an issue open on this topic on abap2xlsx code page.

      #93 Enable changing legacy color palette (to change colors on Excel ver <= 2003)

      Regards,
      Ivan

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Ivan Femia
      Ivan Femia

      Hi,

      I already replied on GitHub.

      Please check my reply https://github.com/ivanfemia/abap2xlsx/issues/444

      Ivan

      Author's profile photo Former Member
      Former Member

      Thank you!~ I guess there is no way for now to achieve it..

      Author's profile photo Ivan Femia
      Ivan Femia

      Correct. It is not OOXML standard.

      Author's profile photo Swati Garg
      Swati Garg

      Hi,

      Good Post. Thanks for sharing.

      Regards,

      Swati

      Author's profile photo Sharath Yaralkattimath
      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

      Author's profile photo Former Member
      Former Member

      SAP Code exchange is dead long ago...

      You should download it via abap2xlsx.org.

      Author's profile photo Markus Großmann
      Markus Großmann

      Auf abap2xlsx.org kommt folgende Meldung:

      NOTICE: This domain name expired on 12/29/2016 and is pending renewal or deletion.

      Author's profile photo Ravi Aswani
      Ravi Aswani

      Hi,

      How can I generate xlsx file from a program with header line and multiple line items. The Header section (13 fields) is having it's own columns with description and line item section (20 fields) with it's own column description.

      something like :

      Header --> ( Col 1   Col 2   Col 3......)

      Header Data --> ( ABC 123M XYX...)

      Line Item --> ( Col 1 Col2  Col 3....)

      Line Items --> ( 123  hfkh 3242........

      898  84280 84298492....

      984 98439 94039094.... )

       

      Please suggest !

      Thanks,