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