A couple of days ago there was a about excel export for WD! in Web Dynpro Forum to translate table data to Excel file. The quick answer was to refer to Web Dynpro Binary Cache. However, the requirement was to change font of header, change the colour of the cell etc.. Basically to have an MS-Excel sheet, rather than using the conventional approach of translating data to XML Format or CSV Format.Therefore our toExcelUsingXML() or toExcelUsingCSV() approach will not help in this case.
- Download the file JExcelAPI
- Add it to the library path
Right Click on Properties
Add the jar file to your project
- Make sure you also add the jxl.jar file to the library as well
Create a variable ExcelUrl in the context. This variable will hold the location of the Excel sheet
For more information regarding formatting refer the tutorial available with jexcelapi.