Skip to Content
Technical Articles
Author's profile photo Stefan Schnell

[abap2xlsx] Formatter Class to Refine Excel Spreadsheets

Today I published in my GitHub repository a formatter class for abap2xlsx. The class offers six methods to format a range in an Excel spreadsheet. E.g. with the method set_border_outline_range you can set a border around a range. You must initialize the class with a zcl_excel object and optional with the number of the worksheet. Now you can set a border with the start and end column and row, as well as the border style and color. The other five methods offers the possibility to set the font size and color, the bold style, the background color of a cell and last but not least a grid border. These methods are a good pattern to build your own format methods for ranges of cells easily. I use the abap2xlsx method change_cell_style, which offers the possibility to change special attributes. Hope it is a good base for other abap2xlsx programmers.

Hint: This is an outdated post. The class is not longer available.

Assigned tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Kumar Biswas
      Kumar Biswas

      Hi Stefan

      I am using abap2xlsx to download data to a multiple sheet workbook.  Things are going well and I am doing the final piece which involves applying borders and  defining print areas.  Your formatter class sounds ideal but I get a 404 - Page not found when I follow the link.  Would you be able to repair it? Many thanks

      Kumar

      Author's profile photo Stefan Schnell
      Stefan Schnell
      Blog Post Author

      Hello Kumar,

      thanks for your hint, you are right, I reorganized my GitHub presence and now I actualize my link above also.

      Cheers
      Stefan

      Author's profile photo Kumar Biswas
      Kumar Biswas

      Thanks Stefan - sorry my reply wasn't so schnell..

       

      Author's profile photo Nida Khan
      Nida Khan

      Hello Stefan,

      Would like to get hand on your class as I don't see a link here.

       

      Many Thanks.

      Author's profile photo Nico Feldmann
      Nico Feldmann

      me too - where do I get the coding

      Author's profile photo Sandra Rossi
      Sandra Rossi

      See what says the author:

      • "Hint: This is an outdated post. The class is not longer available."

      Good luck.