Dear friends,
I want to develop an application in which the user should be able to view an Excel file in grid format and also should be able to edit/update the cells of that excel. Those changes should be retained thereafter.
Could anybody tell me how to proceed for this?
Errrr just use Excel?
Why do you have to use java to implement functionality already inherent within Excel?
If you really must use java to read and write Excel spreadsheets then try the following link:
http://poi.apache.org/hssf/index.html
The application's requirement is that the view should be in Grid format other than the Excel file itself. Is there no other way to present such a view?
Message was edited by:
subhashmedhi
Try looking at the link I sent you... that will tell you how to read in an Excel file so you can display any which way you choose.
what i wanted to know is that whether it would be possible to create a Java program which would generate HTML in such a way that for each cell in the output html page we could have an edit option. Since the excel file under consideration is quite large would it be possible to create the program in a way that it would repaet the code to generate the html for a cell repeatedly for each cell of the html page? when the user edits and subsequently submits the data should be updated.
Better to use Andy Khan's JExcel. If you combine it with Spring's JExcelView you've really got something.
Why create a new grid when you use all the power already built into Excel? Macros and all the rest will be hard to duplicate for yourself.
%
POI is the best choice for Java 2 Excel and vice versa
You can find it here: www.apache.org
> what i wanted to know is that whether it would be
> possible to create a Java program which would
> generate HTML in such a way that for each cell in the
> output html page we could have an edit option.
Yes it is possible
> Since the excel file under consideration is quite large
> would it be possible to create the program in a way
> that it would repaet the code to generate the html
> for a cell repeatedly for each cell of the html page?
Yes it is
> when the user edits and subsequently submits the data
> should be updated.
Yes again.... it is all possible using Java and Servlets (if it's a web application your after)
