DataGrid In Java Struts Web Application

Question

Hi

After scouring the web I have edited my question from the one below to what it is now. Ok I seem to understand that I don't need all the capabilities of excel right now. I think i am satisfied having a data grid to display data. Basically i am working on Struts 2 and I wat my jsp page to have an excel like feel and hence looks like even a datagrid is sufficient. I came across This Technology

I am not sure whether I must go ahead and use it. Any other suggestions, alternatives are welcome

---

The older version of the question "I have a java web application running on windows currently. I may host it in future in a Linux Server.

My application allows people to upload data. I want to display the data they have uploaded in an excel file and render it in a portion of my webpage.

How do I go about this ?"

Answer 1

Basically you would need to read the excel files, get the data in some kind of java objects, and then show it back to user as a normal HTML page with tables etc.. If you want to show the excel files in such a way that your users are also able to edit these then you need to look into javascript / ajax to make a UI as per your needs.

An easy and open source way of reading the uploaded excel files in java is via Apache POI. It is capable of reading .xls files as well as the newer OOXML .xlsx files.

http://poi.apache.org/spreadsheet/

They have very helpful examples which can get you started within 10 minutes..

http://poi.apache.org/spreadsheet/quick-guide.html

If you can allow data to go to another site, then you can use ZOHO. Their online Excel Editing is reasonably good and you don't really have to do anything much.

Answer 2

Maybe you can try http://www.jxcell.net:

It is a java spreadsheet component which allow you to edit your Excel via web page.