abap2xlsx team has a present for you...

[_IvanFemia_]

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.

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:

• abap2xlsx - Generate your professional Excel spreadsheet from ABAP
• xlsx2abap - Read and edit your Excel files from ABAP
• abap2xlsx - I'm no longer a baby, I grow up and now I'm a fully featured tool

[guillaume-hrc]

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

[_IvanFemia_]

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

[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

[_IvanFemia_]

Hi,

I already replied on GitHub.

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

Ivan

[Former Member]

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

[Former Member]

Hi,

Good Post. Thanks for sharing.

Regards,

Swati

[SharathYaralkattimath]

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

[Former Member]

SAP Code exchange is dead long ago...

You should download it via abap2xlsx.org.

[_IvanFemia_]

Correct. It is not OOXML standard.

[markus_grossmann]

Auf abap2xlsx.org kommt folgende Meldung:

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

[raviaswani1982]

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,