Hello,
I would like some help, so please let me explain where and what I am doing.
Using Jdeveloper 11.1.2.4.0 I have done the following:
1. Download and install in to project the Apache POI 3.6 jar.
2. Created a class to help called ~ExcelHelper.java
3. Using a session bean I have the current excel export name being used (there are many places where I need to export excel).
this allows me to access the DCIeteratorBinding name based on the current export.
The export is working fine it displays every column and all the details for each in many rows. However when it creates said excel it also includes the columns which I have set to be non visible.
Example, On my .jsf pages there exists the Columns section in the property inspector which allows you to move or remove said columns from the table a feature which allows for reuse of many viewobjects.
Thus how does one only tell the DCIteratorBinding to only export visible fields regardless of if they are in the view object.