2

Unfortunately, OpenFaces Datatable has not yet an export capability unlike Primefaces or IceFaces. While Exporting is a piece of cake, filtering an IceFaces or primefaces datatable is less easy, Yet primeFaces's filtering does not work with JSF DataModel (sad but true).

Using OpenFaces DataTable filtering is a piece of cake and so handy and powerful. But how about The end user who wants to export a datatable that s/he filtered, to a format like CSV or MS Excel.

The great Dmitry from OpenFaces, gave me a hint : Use OpenFaces DataTable method: getDisplayedRowDatas() that will grab the currently displayed rows from a datatable, then use some thrid library like Itext to export in PDF for example.

In my head, this should go this way:

  • Create a backing bean for this purpose.
  • Add Apache POI third library to the classpath
  • Write code using Apache POI to export the content of the OpenFaces datatable with its method getDisplayedRowsDatas() - but I am afraid this method does not return the names of columns' headers - or grab the HTML table rendered by an OpenFaces Datatable as a buffered string and use Apache POI to produce an Excel file streamed with the Buffer.

In the MyFaces example I came across recently: MyFaces Datatable Export Example, the developer uses Myfaces component <t:buffer value=#{myExportBean.myBufferString}> datatable here </t:buffer /> to transform the content of the datatable to a buffered String which makes things easier. JSF Core does not have such component unfortunately.

Did someone come across this before? Help or better alternatives are much appreciated.

Kukeltje
  • 12,223
  • 4
  • 24
  • 47
Hanynowsky
  • 2,970
  • 5
  • 32
  • 43

1 Answers1

5

You can check out the experimental DataTable export API, which is available in the current nightly build. We'll declare this API officially if it stands the test of time. For now, only CSV export is available, but you can write your own exporters for other formats. Here's the code that you should put in your action handler to make it work:

DataTable myTable = Faces.component("form:myTable", DataTable.class);
myTable.export(new CSVTableExporter());

It exports the data for all of the rows and columns as currently displayed by the table (only the current page of a paginated table is exported currently).

Dmitry Pikhulya
  • 446
  • 2
  • 6
  • Thanks for the answer. It is exciting to know the incoming version of OpenFaces will include CSV exporter. It suits me well if it is CSV and not excel! However, What should I do? replace the actual Openfaces jar by the nightly build one (which I prefer not). Otherwise, how should I physically use the exporter API? For I imported the NBuild as a second libray and this made a JSF implementation conflict. Regards – Hanynowsky Jun 30 '11 at 21:11
  • I did exactly what you recommended by I get only the Table Headers but no Row data in the exported CSV file. AS if the table was empty which is not the case. Is there something wrong? I posted a question in the forum! Regard @Dmitry – Hanynowsky Jul 07 '11 at 21:33
  • solved after your post on OF forum. But still, how can I use the export APi along with of 3.0. regards @Dmitry – Hanynowsky Jul 13 '11 at 12:03
  • Any idea why this still isn't available in a non-nightly release? – Greg Noe Dec 07 '12 at 20:21