How to set the color of a cell in an Excel sheet using Web Dynpro

[Former Member]

Hi,

I have a requirement. I am downloading my Web Dynpro table contents to an Excel sheet. I need to set the color of some cells in that excel sheet according to some condition. How can I write the code to achieve the same?

Any help would be appreciated!

Regards

Kishan

[former_member185086]

Hi

U have to use Jxl jar files(As suggested by previous reply ) in External DC Project, then only u will able to work with data and property of excel files.

Further ,take the help from following threads

1.[Download Data to an excel sheet, with colours|;

2.[Color cells in excel file|;

3.[Changing properties of only few selected cells in MS excel..??|;

Best Regards

Satish Kumar

[Former Member]

Hi,

Please have a look at Jxl Api or apche POI.

Regards

Ayyapparaj