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
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKPcXmY7jJ7Xox2299p7-HnMsEiBhiwYiDUColNusYKt73RnF3wE0lUDrsKp-uYIlXrqRcOsd012U5ZiRkit5Ja0NSsdEa07bnI9Yxb9SHSvg1ApEra3qWz0-Lzso09-6IG_FoMkF2IZs/s320/excel_export_1.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1Iekx_7SoNDoIsHKWZyH_Bh0NkQ1PSjl8kRHXqsOOVyVcOaieLsLN8evblbwY4YpD6QZUJytOgXbE5jaQ8D3TvT3nWoPCYp3YJ2d3llxS_wkUlIWJclEeGfz59uN1ApgHvMYG3CAliLk/s320/excel_export_2.jpg)
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
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMBRJaz5RuP-u9VGswXTFiWlX2kXwGhqsG-85EtZl2iBDSLMZL6fdQQXjMMI0QqMGhqkF-kCtul2yP_WUVBQBnjRR0bwKKEjA-R-bz2ToDuEvztHXYtUfvf-LiFNx0v8sA6INrlrvY_Dk/s320/excel_export_3.jpg)
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