wood burning stoves*
The moose likes Other Java Products and Servers and the fly likes Export to excel without hiding columns Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Java Products and Servers
Bookmark "Export to excel without hiding columns" Watch "Export to excel without hiding columns" New topic
Author

Export to excel without hiding columns

S Nikam
Greenhorn

Joined: Dec 28, 2010
Posts: 11

I am working on Export to Excel functionality using jxls,where I will search the records,store in a bean,dispaly it in dispaly tag and when click on
the button 'Export to Excel' it will go to another jsp where I can select the fileds to export.
While exporting I am hiding the columns that has not been selected using

transformer.setColumnPropertyNamesToHide(hideCols);
and then
transformer.transformXLS("c:\\Test.xls", beans, "C:\\genereatedsheet.xls");

But now I dont want to use hide functionality.

Anybody knows is there any way where I can create excel only with selected fileds.
I dont want to use setColumnPropertyNamesToHide,only selected columns should be created in excel.

Thanks

ssn
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Export to excel without hiding columns