• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Export to excel without hiding columns

 
S Nikam
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic