Two Laptop Bag*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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
 
 
subject: Export to excel without hiding columns
 
Similar Threads
Export to Excel not Working
Deleting columns in excel file to create new Excel file
exporting as excel
Display Tag
Write Data to Excel