Blogs

Ivan Femia

xlsx2abap - Read and edit your Excel files from ABAP
Ivan Femia Active Contributor Platinum: 2,500+ points SAP Mentor
Business Card
Company: Techedge
Posted on Sep. 06, 2010 05:04 AM in ABAP, Community Projects, Open Source, Code Exchange, SAP Developer Network

URL: http://www.plinky.it/blog/2010/09/06/xlsx2abap-read-and-edit-your-excel-files-from-abap/
Subscribe.Subscribe
Print. Print
Permalink Permalink
Share
Share

 

Just two months ago I presented to SDN Community my open source project abap2xlsx. With this blog I would like to announce you the release of xlsx2abap and abap2xlsx v2.0.

I'm very happy of the Community reaction to this project that gives me the power to quickly go on and extend my abap2xlsx and create the new xlsx2abap.

This cannot be real without the active contribution of some SDN community members: Gregor Wolf, Tomek Mackowski and Alvaro Tejada Galindo. Thank you guys!

So coming to the project what's new?

Let's start with xlsx2abap our first release of Excel xlsx file reader, it is capable to load an xlsx file and convert it into an ABAP object ready to be edited. The ABAP object is the same used by abap2xlsx so now you can read à edit à save your Excel file from ABAP. Is really cool!!!!

This first release limits the data load only to data, styles and other stuff will be included in next releases.

Many improvements are also done to the original project abap2xlsx in order to fulfill the community requests:

  • New automatic itab table binding, using the new Excel 2007 table style and field catalog
  • Cell horizontal alignment (center, normal, left, right)
  • Column merge
  • Column and row size
  • Column and row hiding
  • Support to different data type formatting (string, number, date and time)
  • OXML output compliant
  • Fix minor bugs and code improvements

And what's next?

We are working hard in order to move our project into the new SDN Code Exchange (Public availability of Code Exchange for SAP TechEd 2010).

Currently we are looking for the next features to include in the next release such as:

  • Worksheet, Sheet and Cell protection
  • More style options (i.e. Rotation, Vertical alignment)
  • Sheet printing settings
  • Page layout settings
  • Hyperlinks
  • Pivot tables
  • Freezing panes
  • Locking columns and rows for scrolling
  • Read styles from an input file
  • ...and...

A survey is active on this Wave https://wave.google.com/wave/waveref/googlewave.com/w+M57bGePbA,  your opinion is really appreciated.

Related post:

Follow #abap2xlsx news also on Twitter @IvanFemia

Ivan Femia  Active Contributor Platinum: 2,500+ points SAP Mentor SAP Mentor & SAP NetWeaver Consultant at Techedge follow me on Twitter @IvanFemia

Comment on this article
Comment on this weblog
Showing messages 1 through 5 of 5.
Titles Only Main Topics Oldest First

  • Congratulations!
    2010-09-09 06:06:49 Chris Paine Business Card [Reply]

    When I tell some of the people I work with that using these tools in combination with the Web Dynpro Office UI element it will allow them to display and edit SAP data in realtime in Excel, some of them are going to wet themselves with excitement!


    The possibilities that being able to both read and write to a commonly used and well formatted file format are huge.


    You guys have done amazingly well! Huge kudos!

  • Hi..Link not working
    2010-09-06 10:42:38 Srini Tanikella Business Card [Reply]

    Hello Ivan, Thanks again for the great initiative and I'm sure a lot oif the community members will leverage this. I could not get to the link though - http://www.plinky.it/blog/2010/09/05/xlsx2abap-read-and-edit-your-excel-files-from-abap


    Can you please check..


    Thanks,
    Srini

Showing messages 1 through 5 of 5.