Many times you need to transpose the data from row based to column based and vice versa. This simple utility classes would help to do exactly the same.

Formatted Excel can be downloaded from GUI using the OLE but OLE wont work with WebDynpro application. Let’s see how we can download formatted excels using XML.