cancel
Showing results for 
Search instead for 
Did you mean: 

Arranging column headings in Excel file

Former Member
0 Kudos

Hi SDN,

I have imported BAPI in to Webdynpro. And converted the context data in to XML, from XML to excel with help of XSLT. Now here the problem is when the out put displaying in excel file the headings are displaying randomly. But I want to display as per my requirement.

How to change the order of colum headings in excel file?

I have found few threads in SDN but they are based on HashMap is there any other way with out Hashmap?

Appreciate your help.

With Regards,

Ravi.D

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Ravi,

Use the following blog for excel.

It is easy and good.

/people/subramanian.venkateswaran2/blog/2006/08/16/exporting-table-data-to-ms-excel-sheetenhanced-web-dynpro-binary-cache

Former Member
0 Kudos

You need to use an ArrayList (or similar list) to hold the list of columns. See forum web log

/people/sap.user72/blog/2006/05/04/enhancing-tables-in-webdynpro-java-150-custom-built-table-utilities

and look in the 'Creating an Excel File' section.

The problem with Map is that it does not keep the columns in the order you add them to the map.