abap2xlsx – Business charts

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).


3.jpg          4.jpg

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:

  1.      Generate the excel file with the chart as you wish via ABAP using abap2xlsx
  2.      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:
  3.      Write a simple vbs file via ABAP in order to run the image generation like this:
  4.      Save the excel file and the vbs on the SAP NetWeaver Application Server filesystem via ABAP 
    * Opening the File
           MESSAGE lv_msgtxt.
          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.
  5.      Run the saved VBScript file via ABAP

    v_command = ‘cscript.exe test.vbs’.



  6.      The chart image has been generated! Get it from the Application Server filesystem via ABAP and display or send it!    

Virtualising Lion OS X and Xcode4 on Windows 7

This blog resumes my experience in virtualising Lion OS X and Xcode4 on Windows 7 64bit.

I would say that I easily achieved this objective following with this guide. My concerns were basically on performance; I configured my virtual machine as 2 double core processors with 2 GB of RAM and I was happy about them my Virtual Apple is really usable.

An other interesting configuration allowed me to use the Apple Wireless Keyboard (I bought it for iPad and I never needed it), in order to have a fully working keypad and using all the shortcuts that Apple Lion X has. I was really surprised when once I turned on my keyboard the Lion OS X detected it, but it was unable to pair the device directly with Lion; so I paired the Wireless Keyboard from Windows and used as alternative input device on Lion OS X.

Below some images of my new iMac and my first xCode application :mrgreen:

Now I have the possibility to experiment xCode without buying a real iMac.

Feelz – iPhone App by Locojet

Another iPhone application is published by Locojet – Feelz.

Feelz is a FACEBOOK based application which simplifies your “communication” with friends! No more writing, just tap our Feelz cat to transform your anger, love, sympathy, tenderness into cat’s reactions.

What can be sweeter than a purring cat appearing on the screen of your girlfriend? Flatter the cat and demonstrate to your FACEBOOK friends that you remember them.

Feel free to read more on our applications web site LocoJet: www.locojet.com

And download the application from AppStore: http://itunes.apple.com/app/id439929992#

The app can only communicate with other Feelz app installed, so as for the time being it is impossible to send feelz to your friends who don’t have the app installed.

Feel free to send your suggestions, ideas and proposals on support@locojet.com

The “i” word

I just received this message from a friend… Very funny

It all began with an iPhone… March was when my son celebrated his 15th birthday, and I got him an iPhone. He just loved it. Who wouldn’t?

Continue reading “The “i” word”

Apple’s castle is under siege, Android is close to the walls

Original posting http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/23834

iPhone Android Blackberry

During the past months I have been following the debate between Android and Apple fans. Each side considers its own device a better performer than the other, but what is the reality? Continue reading “Apple’s castle is under siege, Android is close to the walls”