Skip to Content
*Introduction*  My users love Microsoft Excel! Many of them would struggle to get through a work day if they didn’t have their beloved Excel. One of the biggest challenges our development group faced when we began working with BSP is that there isn’t any build in Microsoft Office Itegration. Our users were spoiled by such conventions of classic Basis technologies like Excel Integration in the ALV Grid and the ability to just about any report to Excel. Over the years we had even developed some applications that took advantage of the office integration classes.    Finally we came to an application that was being redeveloped in BSP. Originally this application completely ran in Excel with many macros developed over the years. To avoid recreating all these complex Macros in BSP and ABAP it was decided that a portion of the application would remain in Excel. The challenge was how to integration this with the rest of the bsp application. We had to be able to pass data into the Excel spreadsheet from the main application. From there users would work with the data in Excel and allow the imbedded macros to manipulate the data. Finally the resulting data had to be passed back to the main application.   image
To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

    1. Thomas Jung
      In this case it is just a variable of type string.  We took the existing Excel spreadsheet and saved it as XML using the File->Save As – XML Spreadsheet.  We then have a program that uploads this file (just using plain Ccl_gui_frontend_services=>gui_upload) and saves it into a custom database table field (type string). 
      (0) 
  1. Luca Grilli
    I’ve tried your solution, and it’s very nice. Works very well … some works with serializer /deserializer but the result is great.
    Luca
    (0) 
    1. Thomas Jung
      Your guess is as good as mine when it comes to what makes Mendocino tick.  I saw some screen shots at ASUG in the Microsoft Booth. However hard, detailed facts about exactly how it was going to work were difficult to come by.  Perhaps by SAP TechED in the fall there will be more details.
      (0) 

Leave a Reply