Seam - Uploading excel and display using rich datatable

[valatharv]

Hi,

We have a requirement to upload single excel spreadsheet into existing seam CRUD application.

Use case :

a) User will select file (s:fileupload or rich file upload) from UI and upload excel spread-sheet

b) Mainly from back-end I should parse the excel and set to bean and finally display data... say in rich data table on the screen during create.

As this is the best community, need your valuable suggestions... I was thinking of using JExcelAPI but never used it before.

Environment : jboss-seam-2.0.2.SP1, jboss-4.2.3, richfaces 3.3.1.GA

Regards

[mattyclown]

I have to state that I have not used JExcel api as well. But I found several posts that might help you. Hope you can have a good start with your Excel uploading application.

Seam - Export datatable to Excel

http://java2s.com/Open-Source/Java/JBoss/jboss-seam-2.2.0/org/jboss/seam/excel/jxl/JXLExcelWorkbook.java.htm

http://stackoverflow.com/questions/9807626/seam-export-datatable-in-excel-format