I have a table in a jsf fragment. And some columns are LOV ( af:selectOneChoice).
When I export the table to excel, only the selected item in the dropdown (af:selectOneChoice) is exported.
But I want all the drop down (in the adf table column) to be exported to excel.
How to achieve this result ?
what ur usecase? R u exporting data from table.. or you just want to export value from some form?
what your jdev version
If you want to export all value of selectOneChoice then use apachePoi for this.
this will be helpful for you http://www.techartifact.com/blogs/2013/08/generate-excel-file-in-oracle-adf-using-apache-poi.html
It's unclear what you want to achieve, but maybe you can use this blog post as starting point to implement custom export to excel functionality:
Vinay, I want to Export data from table (including full drop down content).
KDario, after exporting my table to excel, I want (in a colum of the exported table) a drop down like here (only the drop down in column C is of interest for me):
it is also simple.. Use apache POI as by my above link
this link will be helpful
You just need to get the list of all value of selectOneChoice.Populate all value of dropdown and make dropdown like these links...
please let me know if face any issue.
I am not sure using jasper report.....
but may be these links will be helpful
But i am sure POI is best for excel generation.Can you share why can't use poi?
You just need to add few .jar files .that's it.Its open source..
If not you can also look for jexcel....
Is there a way to create the dropdown in the exported excel file, using JasperReports rather than Apache POI ?
No, that isn't possible.
(Jasper Reports can create autofilter in exported excel file, but this is not your usecase if I understood it correctly)
But, you can generate excel file with Jasper Reports and then use Apache POI to add dropdown validations