In JDeveloper technical preview 2 there is a sneak preview where you can export data of a rich table to excel.
In the next versions of jdeveloper there will be more possible , somehow Oracle made a interface from adf to .net framework. the jars and dll's are already shipped in technical preview 2 ( see the directory adfdi of the jdeveloper root) .
Now a small example of exporting table data to excel
First we have a rich table on a table emp where I put a button commandbutton with the text export to excel see below
now we open the component palette and go to the operations accordion and drag the export collection action listener on the command button.I only have to fill in a few parameters , the first exportedId is the id of the rich table then we select excelHTML . We are finished
We can now run the webapp and we can change the colums and the sorting of the table. The same data and presentation is copied to excel
Hi edwin,
ReplyDeleteReally we can save time with this ,
but i am asking how can we integrate a personal css skin over an ADF project
here you http://www.oracle.com/technology/products/adf/adffaces/11/doc/skin-selectors.html
ReplyDeleteput your css in public_html
add the skin in trinidad-skins
and select it in the trinidad-config
hi,
ReplyDeleteI tried myne with the export collection but the result don't loks very nice the excell file is not regular how can i do to obtain a regular one
Ok what for export in excel do you want, maybe you can make a servlet where you can make your own csv and stream this to the client or use a servlet with apache poi.
ReplyDeleteIt is a table to be displayed in Excell, but when i open the file the column are Disproportionate.
ReplyDeleteHow to do to let them regular