Download Webdynpro table data in Cell formatted Excel Sheet (WebDynpro for ABAP)

By Kiruthika P, L&T Infotech

Introduction

This article is to download Webdynpro ABAP table (header & line item) data in cell formatted excel sheet with colors, borders, filters. It was not possible to download data in Cell formatted Excel sheet using Webdynpro ABAP. To make this objective possible, we can use XML mapping.  For the XML mapping, create a dummy Excel Sheet with expected Cell formatting and save it as XML file. Use this XML tags in the method logic of Webdynpro ABAP coding.

Steps

1.     Create one Webdynpro Component

Go to SE80 -> Create Webdynpro component.  

Give name of Webdynpro component and click Display Icon.

Then it will show one pop up message to create the component.

Click Yes.  

2.     Create the component with view and window.

Give the description for Webdynpro component.  

3.     Save the component in local object or package.  

4.     Create a node (Node_Sflight) in Context of Component Controller

5.     Create a attribute in the node for table popin of type string.

6.     Create a sub node (Node_sbook) under Node_Sflight.

7.      Now context of Component Controller looks like as below.  

8.     Map the Context of Component Controller to view.  

9.     In layout of main View,

Create one button “Get Flight” to get the flight details. Under the On_action properties of this element create one event “Flight_Details”.     

10.   Create one table to display the header data flight details.  

Click here to continue...