In July 2010, SAP Mentor Ivan Femia released the first version of the open source project abap2xlsx that allowed ABAP developers to generate professional spreadsheets from scratch with all the advanced features that stand alone Excel editors provide like: style and cell data formats, drawings support, conditional formatting, formulas, and so on.
This project has improved the user experience compared to excel generated using SAP standard components (such as ABAP ALV, WebDynpro ALV, System menu, etc.) and it has made ABAP developers more freedom adding, for example, the ability to generate an excel from non dialog processes and to include the generated excel as email attachment. At last but not least, this framework allows the use of spreadsheets in an interactive way, making possible to read them via ABAP for further processing.
Time after time, more and more SDN community members joined into the project and improved its functionalities. The abap2xlsx project reaches a large number of contributors, so today it is almost time for the new release that will include many new features such as the use of template files for charts, very hidden sheet, many bug fixes and so on. In this blog we will focus on one of the most important news: the ability to create custom charts from scratch!
Yes, that’s right: with just a few simple ABAP code lines, you can create business graphics within the excel file and send it, for example, to many iPhone/iPad via a push notification or via an html email (as weekly summary for example).
Another interesting way to use abapxlsx charts is to generate them using abap and then catch them as an image in order to show the chart in a WebDynpro or to send it directly to a mobile device! You believe that this is not possible? It is not easy, but you can do it following these steps:
- Generate the excel file with the chart as you wish via ABAP using abap2xlsx
- Add a simple macro to the excel via ABAP using abap2xlsx in order to enable the excel to export the chart in an image file like this:
- Write a simple vbs file via ABAP in order to run the image generation like this:
- Save the excel file and the vbs on the SAP NetWeaver Application Server filesystem via ABAP
* Opening the File
OPEN DATASET lv_filename FOR OUTPUT IN TEXT MODE
IF SY-SUBRC NE 0.
WRITE: ‘File cannot be opened. Reason:’, lv_msgtxt.
ENDIF.* Transferring Data
LOOP AT lt_table.
TRANSFER lt_table-line TO FILENAME.
ENDLOOP.* Closing the File
CLOSE DATASET lv_filename.
- Run the saved VBScript file via ABAP
v_command = ‘cscript.exe test.vbs’.
CALL ‘SYSTEM’ ID ‘COMMAND’ FIELD v_command.
- The chart image has been generated! Get it from the Application Server filesystem via ABAP and display or send it!
On Saturday March 17th Sergio Ferrari organized the 3rd edition of our TechedgeGroup Inside Track (#titmil), a company event in the style of SAP Inside Track.
In this event I had the possibility to present to my colleagues the new SCN (they requested for) and we made this available to all the community members in our podcast channel TechedgeGroup podcast.
This is a extract of some of the tweets we got for this session.
Watch TGP19 – Techedge Inside Track – Introduction to SCN. (currently it is available on iTunes sync, it will be visible on iTunes web channel in the next hours)
There are several other podcasts that you may interested in this channel (unfortunately are in Italian), but don’t worry all the new sessions of titmil will be shared in english in order to made this a great resource for all SCN community.
Keep updated on iTunes TechedgeGroup podcast channel 😀
I’m waiting for you comments and suggestions
Dear community, it was in the far July 2011 that I gave you updates on the abap2xlsx project with the reporting of my adventures at SAP Inside Track in Chicago (blog). In the last weeks, I had the idea to write a blog and few days ago a great present by SAP Mentor Gregor Wolf to the project (I will give you more detail below, keep reading) gave me the final sprint to be there on time for the New Year celebration.
Abap2xlsx is still the most popular project on Code Exchange with more than 3,500 downloads and close to 300 members. There is a great interest for this project, discussion board on Code Exchange is very hot, many people are asking and helping and many members are contributing (thanks you all) to improve this project adding new features and fixing some bugs ( yes, we had some 🙂 ).
Continue reading Happy New year SCN and Happy New Excel with abap2xlsx
Many of you already know the application SAP Mentor Outreach published by Thorsten Franz about 6 months ago. This application is designed basically to “help SAP Community to connect o SAP Mentors” as Thorsten wrote. Recently Bjoern Weigand and John Moy published the iOS version porting for iPhone and iPad.
What is still missing? An application that would be useful for all the other mobile devices; few weeks ago I decided to think about a porting of this application in JQuery Mobile and today I’m proud to present SAP Mentor Outreach cross mobile version. I’m just a bit in late for TechEd Bangalore but in time for TechEd Madrid.
Check it out at http://www.plinky.it/SAPMentorOutreach/
Continue reading SAP Mentor Outreach is now available on JQuery Mobile
SAP Inside track ended and it was a great event. When I look back and I think on that day I can have only good memories: great people, interesting sessions, passion and enthusiasm to share and exchange experiences all together.
photo by Giacomo Morittu
As expected, such kind of events is a great opportunity for SAP professionals to meet together in an informal atmosphere; and also is a unique possibility for most of the participants to meet in person many of valuable SCN members and contributors, that usually are known virtually.
Continue reading SAP Inside Track Milan 2011 – The reporting